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?
- slow queries on system tables PegoraroF10
- Re: slow queries on system tables Michael Lewis
- Re: slow queries on system tables PegoraroF10
- Re: slow queries on system tables Adrian Klaver
- Re: slow queries on system tables PegoraroF10
- Re: slow queries on system tables Tom Lane
- Re: slow queries on system tables PegoraroF10
- Re: slow queries on system tab... PegoraroF10
- Re: slow queries on system tab... Michael Lewis
- Re: slow queries on system tab... PegoraroF10
- Re: slow queries on system tab... Adrian Klaver
- Re: slow queries on system tab... PegoraroF10
- Re: slow queries on system tab... Michael Lewis
- Re: slow queries on system tab... PegoraroF10
- Re: slow queries on system tab... PegoraroF10
- Re: slow queries on system tab... Adrian Klaver