explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uxf3

Settings
# exclusive inclusive rows x rows loops node
1. 10,887.106 32,732.981 ↓ 2.3 260,640 1

HashAggregate (cost=949,992.41..951,417.77 rows=114,029 width=40) (actual time=32,511.404..32,732.981 rows=260,640 loops=1)

  • Group Key: art.cid, art.lease_id
2. 12,116.975 21,845.875 ↓ 1.0 14,311,175 1

Hash Join (cost=11.95..843,049.87 rows=14,259,005 width=13) (actual time=0.240..21,845.875 rows=14,311,175 loops=1)

  • Hash Cond: (art.property_id = load_prop.property_id)
3. 9,728.674 9,728.674 ↓ 1.0 14,311,939 1

Seq Scan on ar_transactions art (cost=0.00..646,976.60 rows=14,259,005 width=17) (actual time=0.008..9,728.674 rows=14,311,939 loops=1)

  • Filter: ((post_date <= '2020-09-30'::date) AND (cid = 13,531))
  • Rows Removed by Filter: 231,894
4. 0.102 0.226 ↑ 1.0 220 1

Hash (cost=9.20..9.20 rows=220 width=4) (actual time=0.226..0.226 rows=220 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
5. 0.124 0.124 ↑ 1.0 220 1

Seq Scan on load_prop (cost=0.00..9.20 rows=220 width=4) (actual time=0.003..0.124 rows=220 loops=1)

Planning time : 0.563 ms