Re: Temporarily very slow planning time after a big delete

Peter Geoghegan <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CAH2-WzkdMf=6P0Dd9rN5dz_JFgjWE0DRCJLQkzoYw=Gw76Jx6Q@mail.gmail.com> 
On Tue, May 21, 2019 at 11:12 AM Walter Smith <[email protected]> wrote
> I did a VACUUM overnight and got the following. The thing that stands out to me is that one index (index_unproc_notifications_on_notifiable_type) took 100x longer to scan than the others. That's not the index used in the slow query, though.

What columns are indexed by
index_unproc_notifications_on_notifiable_type, and what are their
datatypes?

-- 
Peter Geoghegan
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.