explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ChWr

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 52.221 ↑ 1.0 1 1

Limit (cost=26,235.03..26,235.03 rows=1 width=62) (actual time=52.218..52.221 rows=1 loops=1)

  • Buffers: shared hit=19818
2. 11.904 52.216 ↑ 55,944.0 1 1

Sort (cost=26,235.03..26,374.89 rows=55,944 width=62) (actual time=52.216..52.216 rows=1 loops=1)

  • Sort Key: pl.last_modification_date DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=19818
3. 8.551 40.312 ↓ 1.1 60,170 1

Hash Left Join (cost=1,077.57..25,955.31 rows=55,944 width=62) (actual time=1.043..40.312 rows=60,170 loops=1)

  • Hash Cond: (pl.service_point_id = sp.id)
  • Buffers: shared hit=19818
4. 30.753 30.753 ↓ 1.1 60,170 1

Index Scan using pricelist_account_id_idx on pricelist pl (cost=0.42..24,730.26 rows=55,944 width=54) (actual time=0.028..30.753 rows=60,170 loops=1)

  • Index Cond: (account_id IS NULL)
  • Filter: ((date_active <= '2020-01-29 00:00:00'::timestamp without time zone) AND (last_modification_date <= '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=19358
5. 0.078 1.008 ↑ 1.0 448 1

Hash (cost=1,071.55..1,071.55 rows=448 width=8) (actual time=1.008..1.008 rows=448 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
  • Buffers: shared hit=460
6. 0.930 0.930 ↑ 1.0 448 1

Index Scan using service_point_pkey on service_point sp (cost=0.40..1,071.55 rows=448 width=8) (actual time=0.003..0.930 rows=448 loops=1)

  • Buffers: shared hit=460