explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gnlU

Settings
# exclusive inclusive rows x rows loops node
1. 0.096 68.179 ↑ 128.2 151 1

Sort (cost=237,175.22..237,223.63 rows=19,364 width=265) (actual time=68.163..68.179 rows=151 loops=1)

  • Sort Key: r.fch_evento DESC
  • Sort Method: quicksort Memory: 101kB
  • Buffers: shared hit=8,083 dirtied=70
2. 56.985 68.083 ↑ 128.2 151 1

Bitmap Heap Scan on resumenes_nc_casos r (cost=2,503.05..235,796.4 rows=19,364 width=265) (actual time=53.934..68.083 rows=151 loops=1)

  • Filter: (r.fch_baja IS NULL)
  • Heap Blocks: exact=7,655
  • Buffers: shared hit=8,080 dirtied=70
3. 11.098 11.098 ↓ 1.0 85,705 1

Bitmap Index Scan on ix_resumenes_nc_casos_01 (cost=0..2,498.21 rows=82,165 width=0) (actual time=11.098..11.098 rows=85,705 loops=1)

  • Index Cond: ((r.nunc = '2020128063'::bigint) AND (r.caso = '1'::bigint))
  • Buffers: shared hit=425
Planning time : 0.513 ms
Execution time : 68.318 ms