explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5jVX

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 7.123 ↑ 1.0 1 1

Limit (cost=457.02..457.02 rows=1 width=244) (actual time=7.121..7.123 rows=1 loops=1)

2. 1.061 7.120 ↑ 5.0 1 1

Sort (cost=457.02..457.03 rows=5 width=244) (actual time=7.120..7.120 rows=1 loops=1)

  • Sort Key: pl.last_modification_date DESC
  • Sort Method: top-N heapsort Memory: 1176kB
3. 2.795 6.059 ↑ 1.0 5 1

Hash Right Join (cost=426.98..456.99 rows=5 width=244) (actual time=3.544..6.059 rows=5 loops=1)

  • Hash Cond: (sp.id = pl.service_point_id)
4. 0.120 0.120 ↑ 1.0 1,381 1

Seq Scan on service_point sp (cost=0.00..24.81 rows=1,381 width=8) (actual time=0.005..0.120 rows=1,381 loops=1)

5. 0.007 3.144 ↑ 1.0 5 1

Hash (cost=426.92..426.92 rows=5 width=222) (actual time=3.144..3.144 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 3.137 3.137 ↑ 1.0 5 1

Seq Scan on pricelist pl (cost=0.00..426.92 rows=5 width=222) (actual time=3.133..3.137 rows=5 loops=1)

  • Filter: ((account_id IS NULL) AND (date_active <= now()) AND (last_modification_date <= now()))
  • Rows Removed by Filter: 15041