Re: Slow query on a one-tuple table
| От | Luís Roberto Weck |
|---|---|
| Тема | Re: Slow query on a one-tuple table |
| Дата | |
| Msg-id | ab6ea98e-6266-7665-40b7-151c5736c08d@siscobra.com.br обсуждение исходный текст |
| Ответ на | Re: Slow query on a one-tuple table (Michael Lewis <mlewis@entrata.com>) |
| Ответы |
RE: Slow query on a one-tuple table
|
| Список | pgsql-performance |
Em 19/09/2019 14:21, Michael Lewis escreveu: > Is this result able to be repeated? Yes, I can consistently repeat it. Postgres version is 11.1. Other executions: Index Scan using assessoria_pkey on public.assessoria (cost=0.25..2.47 rows=1 width=62) (actual time=1.591..4.035 rows=1 loops=1) Output: asscod, asscambol Index Cond: (assessoria.asscod = 1) Buffers: shared hit=1187 Planning Time: 0.053 ms Execution Time: 4.055 ms Index Scan using assessoria_pkey on public.assessoria (cost=0.25..2.47 rows=1 width=62) (actual time=1.369..3.838 rows=1 loops=1) Output: asscod, asscambol Index Cond: (assessoria.asscod = 1) Buffers: shared hit=1187 Planning Time: 0.033 ms Execution Time: 3.851 ms
В списке pgsql-performance по дате отправления: