explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sfsd

Settings
# exclusive inclusive rows x rows loops node
1. 10.268 27,132.574 ↓ 4,633.0 4,633 1

GroupAggregate (cost=3,422.81..3,422.84 rows=1 width=44) (actual time=27,117.411..27,132.574 rows=4,633 loops=1)

  • Group Key: scl.cid, scl.lease_id, scl.lease_interval_id
2. 16.388 27,122.306 ↓ 13,167.0 13,167 1

Sort (cost=3,422.81..3,422.81 rows=1 width=16) (actual time=27,117.395..27,122.306 rows=13,167 loops=1)

  • Sort Key: scl.lease_id, scl.lease_interval_id
  • Sort Method: quicksort Memory: 1,413kB
3. 1,180.462 27,105.918 ↓ 13,167.0 13,167 1

Nested Loop (cost=0.86..3,422.80 rows=1 width=16) (actual time=19.955..27,105.918 rows=13,167 loops=1)

  • Join Filter: (scl.property_id = load_prop.property_id)
  • Rows Removed by Join Filter: 2,883,573
4. 1,341.720 24,753.593 ↓ 13,167.0 13,167 1

Nested Loop (cost=0.86..3,410.85 rows=1 width=20) (actual time=19.935..24,753.593 rows=13,167 loops=1)

  • Join Filter: (ac.id = scl.ar_code_id)
  • Rows Removed by Join Filter: 2,422,728
5. 746.772 1,656.058 ↓ 945,905.0 945,905 1

Nested Loop (cost=0.43..3,404.67 rows=1 width=32) (actual time=2.020..1,656.058 rows=945,905 loops=1)

6. 10.632 454.229 ↓ 5,113.0 5,113 1

Nested Loop (cost=0.43..3,392.51 rows=1 width=24) (actual time=2.014..454.229 rows=5,113 loops=1)

7. 20.045 20.045 ↓ 200.5 8,824 1

Seq Scan on temp_lease_activity tla (cost=0.00..3,020.16 rows=44 width=12) (actual time=0.040..20.045 rows=8,824 loops=1)

  • Filter: (cid = 13,531)
8. 423.552 423.552 ↑ 1.0 1 8,824

Index Scan using idx_lease_intervals on lease_intervals li (cost=0.43..8.45 rows=1 width=12) (actual time=0.048..0.048 rows=1 loops=8,824)

  • Index Cond: (id = tla.lease_interval_id)
  • Filter: ((lease_status_type_id <> 2) AND (cid = 13,531) AND (tla.lease_id = lease_id))
9. 455.057 455.057 ↑ 1.0 185 5,113

Seq Scan on ar_codes ac (cost=0.00..10.31 rows=185 width=8) (actual time=0.001..0.089 rows=185 loops=5,113)

  • Filter: (cid = 13,531)
10. 21,755.815 21,755.815 ↓ 3.0 3 945,905

Index Scan using idx_scheduled_charge_logs_lease_interval_id on scheduled_charge_logs scl (cost=0.43..6.16 rows=1 width=24) (actual time=0.017..0.023 rows=3 loops=945,905)

  • Index Cond: (lease_interval_id = li.id)
  • Filter: ((NOT is_post_date_ignored) AND (NOT is_deleted) AND (NOT is_unselected_quote) AND (charge_start_date <= '2020-09-30'::date) AND ((charge_end_date IS NULL) OR (charge_end_date >= '2020-09-01'::date)) AND (cid = 13,531) AND (li.lease_id = lease_id) AND (LEAST(charge_end_date, '2020-09-30'::date) >= reporting_post_date) AND (LEAST(charge_end_date, '2020-09-30'::date) <= apply_through_post_date) AND (ar_trigger_id = ANY ('{301,302,303,304,305,306,307,308,309,310}'::integer[])))
  • Rows Removed by Filter: 24
11. 1,171.863 1,171.863 ↑ 1.0 220 13,167

Seq Scan on load_prop (cost=0.00..9.20 rows=220 width=4) (actual time=0.001..0.089 rows=220 loops=13,167)

Planning time : 2.428 ms