explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5741

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

Limit (cost=29,555.56..29,555.56 rows=1 width=62) (actual time=58.136..58.139 rows=1 loops=1)

2. 11.791 58.134 ↑ 55,944.0 1 1

Sort (cost=29,555.56..29,695.42 rows=55,944 width=62) (actual time=58.134..58.134 rows=1 loops=1)

  • Sort Key: pl.last_modification_date DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 8.031 46.343 ↓ 1.1 60,170 1

Hash Left Join (cost=3,972.70..29,275.84 rows=55,944 width=62) (actual time=7.526..46.343 rows=60,170 loops=1)

  • Hash Cond: (pl.service_point_id = sp.id)
4. 31.882 35.587 ↓ 1.1 60,170 1

Bitmap Heap Scan on pricelist pl (cost=1,319.62..26,474.86 rows=55,944 width=54) (actual time=4.786..35.587 rows=60,170 loops=1)

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

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

  • Index Cond: (account_id IS NULL)
6. 0.063 2.725 ↑ 1.0 448 1

Hash (cost=2,647.48..2,647.48 rows=448 width=8) (actual time=2.725..2.725 rows=448 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
7. 2.662 2.662 ↑ 1.0 448 1

Seq Scan on service_point sp (cost=0.00..2,647.48 rows=448 width=8) (actual time=0.008..2.662 rows=448 loops=1)