explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mvnv

Settings
# exclusive inclusive rows x rows loops node
1. 37.454 42.222 ↑ 1.6 2,590 1

Bitmap Heap Scan on pdl (cost=873.53..14,561.67 rows=4,165 width=179) (actual time=5.144..42.222 rows=2,590 loops=1)

  • Recheck Cond: (id < 600000)
  • Filter: (nb_lot = 2)
  • Rows Removed by Filter: 39264
  • Heap Blocks: exact=1303
  • Buffers: shared hit=1422
2. 4.768 4.768 ↓ 1.0 41,854 1

Bitmap Index Scan on pdl_pkey (cost=0.00..872.49 rows=41,609 width=0) (actual time=4.768..4.768 rows=41,854 loops=1)

  • Index Cond: (id < 600000)
  • Buffers: shared hit=119