explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xqCx

Settings
# exclusive inclusive rows x rows loops node
1. 0.212 8.025 ↓ 61.0 61 1

GroupAggregate (cost=7.73..8.11 rows=1 width=548) (actual time=7.819..8.025 rows=61 loops=1)

  • Group Key: p.property_name, aac.vendor, aac.post_month, aac.invoice_number, aac.payment_type, aac.account_name, p.lookup_code, aac.gl_account, aac.description, aac.invoice_note, aac.vendors_id, aac.vendor_code, aac.ap_header_id, aac.invoice_date, (COALESCE(func_format_unit_number((aac.unit_number)::character varying, NULL::character varying, (aac.building_name)::character varying, NULL::character varying), (aac.unit_number)::character varying, (aac.building_name)::character varying)), aac.due_date, aac.on_hold, aac.invoice_on_hold
2. 0.179 7.813 ↓ 61.0 61 1

Sort (cost=7.73..7.74 rows=1 width=301) (actual time=7.803..7.813 rows=61 loops=1)

  • Sort Key: p.property_name, aac.vendor, aac.post_month, aac.invoice_number, aac.payment_type, aac.account_name, p.lookup_code, aac.gl_account, aac.description, aac.invoice_note, aac.vendors_id, aac.vendor_code, aac.ap_header_id, aac.invoice_date, (COALESCE(func_format_unit_number((aac.unit_number)::character varying, NULL::character varying, (aac.building_name)::character varying, NULL::character varying), (aac.unit_number)::character varying, (aac.building_name)::character varying)), aac.due_date, aac.on_hold, aac.invoice_on_hold
  • Sort Method: quicksort Memory: 41kB
3. 0.349 7.634 ↓ 61.0 61 1

Nested Loop (cost=1.29..7.72 rows=1 width=301) (actual time=7.056..7.634 rows=61 loops=1)

  • Join Filter: (load_prop.property_id = p.id)
4. 0.062 7.102 ↓ 61.0 61 1

Hash Join (cost=1.01..4.01 rows=1 width=320) (actual time=7.011..7.102 rows=61 loops=1)

  • Hash Cond: (aac.property_id = load_prop.property_id)
5. 0.047 0.047 ↑ 1.0 61 1

Seq Scan on ap_amount_temp aac (cost=0.00..2.76 rows=61 width=316) (actual time=0.009..0.047 rows=61 loops=1)

  • Filter: (cid = 224)
6. 0.011 6.993 ↓ 29.0 29 1

Hash (cost=1.00..1.00 rows=1 width=4) (actual time=6.993..6.993 rows=29 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
7. 6.982 6.982 ↓ 29.0 29 1

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

  • Filter: ((is_disabled = 0) AND (is_test = 0))
8. 0.183 0.183 ↑ 1.0 1 61

Index Scan using idx_properties_id on properties p (cost=0.28..3.45 rows=1 width=33) (actual time=0.003..0.003 rows=1 loops=61)

  • Index Cond: (id = aac.property_id)
  • Filter: (cid = 224)
Planning time : 1.207 ms