explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ArGU

Settings
# exclusive inclusive rows x rows loops node
1. 3.582 1,843.067 ↓ 70.1 982 1

GroupAggregate (cost=15,688.60..15,689.02 rows=14 width=40) (actual time=1,838.012..1,843.067 rows=982 loops=1)

  • Group Key: art.cid, art.lease_id
2. 3.898 1,839.485 ↓ 270.1 3,781 1

Sort (cost=15,688.60..15,688.63 rows=14 width=18) (actual time=1,837.983..1,839.485 rows=3,781 loops=1)

  • Sort Key: art.lease_id
  • Sort Method: quicksort Memory: 392kB
3. 6.022 1,835.587 ↓ 270.1 3,781 1

Nested Loop (cost=2.53..15,688.33 rows=14 width=18) (actual time=1,183.054..1,835.587 rows=3,781 loops=1)

4. 283.017 1,797.895 ↓ 316.7 3,167 1

Nested Loop (cost=0.43..15,620.86 rows=10 width=17) (actual time=1,183.025..1,797.895 rows=3,167 loops=1)

  • Join Filter: (art.property_id = load_prop.property_id)
  • Rows Removed by Join Filter: 693,573
5. 0.178 0.178 ↑ 1.0 220 1

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

6. 257.575 1,514.700 ↓ 316.7 3,167 220

Materialize (cost=0.43..15,578.69 rows=10 width=21) (actual time=1.680..6.885 rows=3,167 loops=220)

7. 23.334 1,257.125 ↓ 316.7 3,167 1

Nested Loop (cost=0.43..15,578.64 rows=10 width=21) (actual time=369.466..1,257.125 rows=3,167 loops=1)

  • Join Filter: (art.ar_code_id = ac.id)
  • Rows Removed by Join Filter: 48,746
8. 9.469 1,214.789 ↓ 43.4 3,167 1

Nested Loop (cost=0.43..15,540.43 rows=73 width=25) (actual time=369.403..1,214.789 rows=3,167 loops=1)

9. 14.080 14.080 ↓ 284.6 8,824 1

Seq Scan on temp_lease_activity tla (cost=0.00..2,129.99 rows=31 width=8) (actual time=0.023..14.080 rows=8,824 loops=1)

  • Filter: (cid = 13,531)
10. 1,191.240 1,191.240 ↓ 0.0 0 8,824

Index Scan using idx_ar_transactions_lease_id on ar_transactions art (cost=0.43..432.57 rows=2 width=25) (actual time=0.129..0.135 rows=0 loops=8,824)

  • Index Cond: (lease_id = tla.lease_id)
  • Filter: ((post_date <= '2020-09-30'::date) AND (cid = 13,531) AND (ar_code_type_id = 7))
  • Rows Removed by Filter: 17
11. 18.959 19.002 ↑ 1.6 16 3,167

Materialize (cost=0.00..10.90 rows=25 width=8) (actual time=0.000..0.006 rows=16 loops=3,167)

12. 0.043 0.043 ↑ 1.0 24 1

Seq Scan on ar_codes ac (cost=0.00..10.78 rows=25 width=8) (actual time=0.007..0.043 rows=24 loops=1)

  • Filter: ((cid = 13,531) AND (gl_group_type_id = 2))
  • Rows Removed by Filter: 117
13. 9.501 31.670 ↑ 21.0 1 3,167

Bitmap Heap Scan on ar_allocations aa (cost=2.10..6.54 rows=21 width=17) (actual time=0.009..0.010 rows=1 loops=3,167)

  • Recheck Cond: ((art.id = charge_ar_transaction_id) OR (art.id = credit_ar_transaction_id))
  • Filter: ((NOT is_deleted) AND (cid = 13,531))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=3,913
14. 3.167 22.169 ↓ 0.0 0 3,167

BitmapOr (cost=2.10..2.10 rows=25 width=0) (actual time=0.007..0.007 rows=0 loops=3,167)

15. 9.501 9.501 ↑ 5.0 1 3,167

Bitmap Index Scan on idx_ar_allocations_charge_ar_transaction_id (cost=0.00..0.99 rows=5 width=0) (actual time=0.003..0.003 rows=1 loops=3,167)

  • Index Cond: (art.id = charge_ar_transaction_id)
16. 9.501 9.501 ↓ 0.0 0 3,167

Bitmap Index Scan on idx_ar_allocations_credit_ar_transaction_id (cost=0.00..1.10 rows=20 width=0) (actual time=0.003..0.003 rows=0 loops=3,167)

  • Index Cond: (art.id = credit_ar_transaction_id)
Planning time : 5.211 ms