explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kMGI

Settings
# exclusive inclusive rows x rows loops node
1. 84.857 541.438 ↓ 1.1 5,163 1

HashAggregate (cost=18,168.91..18,225.19 rows=4,502 width=40) (actual time=537.404..541.438 rows=5,163 loops=1)

  • Group Key: art.cid, art.lease_id
2. 110.081 456.581 ↓ 29.0 130,764 1

Hash Join (cost=12.38..18,135.15 rows=4,502 width=13) (actual time=18.030..456.581 rows=130,764 loops=1)

  • Hash Cond: (art.property_id = load_prop.property_id)
3. 108.891 346.275 ↓ 29.0 130,764 1

Nested Loop (cost=0.43..18,061.29 rows=4,502 width=17) (actual time=17.795..346.275 rows=130,764 loops=1)

4. 16.784 16.784 ↓ 245.1 8,824 1

Seq Scan on temp_lease_activity tla (cost=0.00..2,469.25 rows=36 width=8) (actual time=0.054..16.784 rows=8,824 loops=1)

  • Filter: (cid = 13,531)
5. 220.600 220.600 ↑ 8.3 15 8,824

Index Scan using idx_ar_transactions_lease_id on ar_transactions art (cost=0.43..431.86 rows=125 width=17) (actual time=0.004..0.025 rows=15 loops=8,824)

  • Index Cond: (lease_id = tla.lease_id)
  • Filter: ((post_date <= '2020-09-30'::date) AND (cid = 13,531))
  • Rows Removed by Filter: 2
6. 0.102 0.225 ↑ 1.0 220 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
7. 0.123 0.123 ↑ 1.0 220 1

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

Planning time : 0.697 ms