explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kaAH

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 20,589.327 ↑ 1.0 1 1

Limit (cost=26,722.52..26,722.52 rows=1 width=94) (actual time=20,589.324..20,589.327 rows=1 loops=1)

  • Buffers: shared hit=353294
2. 5,719.549 20,589.316 ↑ 55,944.0 1 1

Sort (cost=26,722.52..26,862.38 rows=55,944 width=94) (actual time=20,589.316..20,589.316 rows=1 loops=1)

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

Hash Left Join (cost=1,144.55..26,442.80 rows=55,944 width=94) (actual time=1.069..14,869.767 rows=60,165 loops=1)

  • Hash Cond: (pl.service_point_id = sp.id)
  • Buffers: shared hit=353294
4. 79.850 79.850 ↓ 1.1 60,165 1

Index Scan using pricelist_account_id_idx on pricelist pl (cost=0.42..25,011.07 rows=55,944 width=956) (actual time=0.016..79.850 rows=60,165 loops=1)

  • Index Cond: (account_id IS NULL)
  • Filter: ((date_active <= now()) AND (last_modification_date <= now()))
  • Buffers: shared hit=19356
5. 0.070 0.961 ↑ 1.2 448 1

Hash (cost=1,137.56..1,137.56 rows=525 width=8) (actual time=0.961..0.961 rows=448 loops=1)

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

Index Scan using service_point_pkey on service_point sp (cost=0.40..1,137.56 rows=525 width=8) (actual time=0.002..0.891 rows=448 loops=1)

  • Buffers: shared hit=460
Planning time : 0.244 ms
Execution time : 20,589.560 ms