explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3hNk

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 21,038.986 ↑ 1.0 1 1

Limit (cost=26,894.44..26,894.44 rows=1 width=82) (actual time=21,038.984..21,038.986 rows=1 loops=1)

2. 5,959.053 21,038.982 ↑ 55,944.0 1 1

Sort (cost=26,894.44..27,034.30 rows=55,944 width=82) (actual time=21,038.982..21,038.982 rows=1 loops=1)

  • Sort Key: last_modification_date DESC
  • Sort Method: top-N heapsort Memory: 742kB
3. 15,075.003 15,079.929 ↓ 1.1 60,165 1

Bitmap Heap Scan on pricelist pl (cost=1,319.62..26,614.72 rows=55,944 width=82) (actual time=7.859..15,079.929 rows=60,165 loops=1)

  • Recheck Cond: (account_id IS NULL)
  • Filter: ((date_active <= now()) AND (last_modification_date <= now()))
  • Heap Blocks: exact=8054
4. 4.926 4.926 ↓ 1.1 60,165 1

Bitmap Index Scan on pricelist_account_id_idx (cost=0.00..1,305.63 rows=56,162 width=0) (actual time=4.926..4.926 rows=60,165 loops=1)

  • Index Cond: (account_id IS NULL)