explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WVL0

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 20,342.345 ↑ 1.0 1 1

Limit (cost=25,149.84..25,149.84 rows=1 width=82) (actual time=20,342.343..20,342.345 rows=1 loops=1)

  • Buffers: shared hit=352834
2. 5,650.089 20,342.342 ↑ 55,944.0 1 1

Sort (cost=25,149.84..25,289.70 rows=55,944 width=82) (actual time=20,342.342..20,342.342 rows=1 loops=1)

  • Sort Key: last_modification_date DESC
  • Sort Method: top-N heapsort Memory: 1197kB
  • Buffers: shared hit=352834
3. 14,692.253 14,692.253 ↓ 1.1 60,165 1

Index Scan using pricelist_account_id_idx on pricelist pl (cost=0.42..24,870.12 rows=55,944 width=82) (actual time=0.102..14,692.253 rows=60,165 loops=1)

  • Index Cond: (account_id IS NULL)
  • Filter: ((date_active <= '2020-01-30 00:00:00'::timestamp without time zone) AND (last_modification_date <= '2020-01-30 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=352834