Re: slow queries on system tables

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: slow queries on system tables
Date: 2019-08-23 21:55:44
Message-ID: CAHOFxGqftoP6-0YbRqRZbZ=_Zbn6iELvQDfHz3Sc0uJo_z8_Bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Might the issue be with pg_index or pg_attribute rather than pg_class? Is
the query still slow? Do you have the output of explain analyze for use on
https://explain.depesz.com/ or the output of EXPLAIN (ANALYZE, COSTS,
VERBOSE, BUFFERS, FORMAT JSON) for use on
http://tatiyants.com/pev/#/plans/new website?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-08-23 22:23:55 Re: slow queries on system tables
Previous Message PegoraroF10 2019-08-23 21:47:55 Re: slow queries on system tables