Re: Slow query on a one-tuple table
| От | Luís Roberto Weck |
|---|---|
| Тема | Re: Slow query on a one-tuple table |
| Дата | |
| Msg-id | 18ae8108-acaf-e9cc-96a9-ab20f4147f5a@siscobra.com.br обсуждение исходный текст |
| Ответ на | RE: Slow query on a one-tuple table (Igor Neyman <ineyman@perceptron.com>) |
| Ответы |
Re: Slow query on a one-tuple table
|
| Список | pgsql-performance |
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
В списке pgsql-performance по дате отправления: