explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gHUP

Settings
# exclusive inclusive rows x rows loops node
1. 7.198 660.340 ↓ 2,436.0 2,436 1

GroupAggregate (cost=80.55..80.67 rows=1 width=612) (actual time=652.854..660.340 rows=2,436 loops=1)

  • Group Key: p.property_name, aac.vendor, aac.post_month, aac.invoice_number, aac.payment_type, p.lookup_code, aac.invoice_note, aac.vendors_id, aac.vendor_code, aac.ap_header_id, aac.invoice_date, aac.due_date, aac.on_hold, aac.invoice_on_hold
2. 23.128 653.142 ↓ 3,511.0 3,511 1

Sort (cost=80.55..80.56 rows=1 width=438) (actual time=652.822..653.142 rows=3,511 loops=1)

  • Sort Key: p.property_name, aac.vendor, aac.post_month, aac.invoice_number, aac.payment_type, p.lookup_code, aac.invoice_note, aac.vendors_id, aac.vendor_code, aac.ap_header_id, aac.invoice_date, aac.due_date, aac.on_hold, aac.invoice_on_hold
  • Sort Method: quicksort Memory: 943kB
3. 140.683 630.014 ↓ 3,511.0 3,511 1

Nested Loop (cost=0.54..80.54 rows=1 width=438) (actual time=43.995..630.014 rows=3,511 loops=1)

  • Join Filter: (load_prop.property_id = aac.property_id)
  • Rows Removed by Join Filter: 1,249,916
4. 0.934 47.008 ↓ 357.0 357 1

Nested Loop (cost=0.54..3.31 rows=1 width=34) (actual time=43.368..47.008 rows=357 loops=1)

5. 43.575 43.575 ↓ 357.0 357 1

Function Scan on load_properties load_prop (cost=0.25..1.00 rows=1 width=4) (actual time=43.346..43.575 rows=357 loops=1)

  • Filter: ((is_disabled = 0) AND (is_test = 0))
  • Rows Removed by Filter: 8
6. 2.499 2.499 ↑ 1.0 1 357

Index Scan using idx_properties_id on properties p (cost=0.29..2.31 rows=1 width=30) (actual time=0.007..0.007 rows=1 loops=357)

  • Index Cond: (id = load_prop.property_id)
  • Filter: (cid = 235)
7. 442.323 442.323 ↓ 1,755.5 3,511 357

Seq Scan on ap_amount_temp aac (cost=0.00..77.21 rows=2 width=424) (actual time=0.003..1.239 rows=3,511 loops=357)

  • Filter: (cid = 235)