explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wTHn

Settings
# exclusive inclusive rows x rows loops node
1. 0.216 9.374 ↓ 63.0 63 1

GroupAggregate (cost=14.08..14.20 rows=1 width=730) (actual time=9.176..9.374 rows=63 loops=1)

  • Group Key: p.property_name, aac.vendor, aac.invoice_number, aac.post_month, aac.payment_type, aac.account_name, 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. 0.437 9.158 ↓ 99.0 99 1

Sort (cost=14.08..14.09 rows=1 width=556) (actual time=9.151..9.158 rows=99 loops=1)

  • Sort Key: p.property_name, aac.vendor, aac.invoice_number, aac.post_month, aac.payment_type, aac.account_name, 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: 50kB
3. 0.036 8.721 ↓ 99.0 99 1

Nested Loop (cost=0.54..14.07 rows=1 width=556) (actual time=8.651..8.721 rows=99 loops=1)

  • Join Filter: (load_prop.property_id = aac.property_id)
4. 0.004 8.636 ↑ 1.0 1 1

Nested Loop (cost=0.54..3.31 rows=1 width=34) (actual time=8.635..8.636 rows=1 loops=1)

5. 8.625 8.625 ↑ 1.0 1 1

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

  • Filter: ((is_disabled = 0) AND (is_test = 0))
6. 0.007 0.007 ↑ 1.0 1 1

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=1)

  • Index Cond: (id = load_prop.property_id)
  • Filter: (cid = 235)
7. 0.049 0.049 ↓ 99.0 99 1

Seq Scan on ap_amount_temp aac (cost=0.00..10.75 rows=1 width=542) (actual time=0.013..0.049 rows=99 loops=1)

  • Filter: (cid = 235)