On Tue, May 21, 2019 at 11:12 AM Walter Smith <walter@carezone.com> 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
theslow query, though.
What columns are indexed by
index_unproc_notifications_on_notifiable_type, and what are their
datatypes?
--
Peter Geoghegan