Re: Slow query on a one-tuple table
Luís Roberto Weck <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
Em 19/09/2019 17:11, Igor Neyman escreveu: > With LIMIT 1, I get 3 shared buffers hit, pretty much always. > > ____________________________________________________________________________________ > > Check if assessoria_pkey index is bloated. > > Regards, > Igor Neyman > > With this query[1] it shows: current_database|schemaname|tblname |idxname |real_size|extra_size|extra_ratio|fillfactor|bloat_size|bloat_ratio|is_na| ----------------|----------|----------|---------------|---------|----------|-----------|----------|----------|-----------|-----| database_name |public |assessoria|assessoria_pkey| 16384| 0| 0.0| 90| 0.0| 0.0|false| [1]https://github.com/ioguix/pgsql-bloat-estimation/blob/master/btree/btree_bloat-superuser.sql