| From: | Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br> |
|---|---|
| To: | Michael Lewis <mlewis(at)entrata(dot)com> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Slow query on a one-tuple table |
| Date: | 2019-09-19 18:30:08 |
| Message-ID: | ab6ea98e-6266-7665-40b7-151c5736c08d@siscobra.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2019-09-19 18:34:11 | RE: Slow query on a one-tuple table |
| Previous Message | Christoph Berg | 2019-09-19 17:27:13 | Re: Delete huge Table under XFS |