explain.depesz.com

PostgreSQL's explain analyze made readable

Result: URKD

Settings
# exclusive inclusive rows x rows loops node
1. 15.997 1,072.680 ↓ 5,682.0 5,682 1

GroupAggregate (cost=167.03..167.41 rows=1 width=1,310) (actual time=1,056.046..1,072.680 rows=5,682 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.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. 57.063 1,056.683 ↓ 6,892.0 6,892 1

Sort (cost=167.03..167.04 rows=1 width=1,136) (actual time=1,056.010..1,056.683 rows=6,892 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.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: 2,038kB
3. 225.906 999.620 ↓ 6,892.0 6,892 1

Nested Loop (cost=0.54..167.02 rows=1 width=1,136) (actual time=44.533..999.620 rows=6,892 loops=1)

  • Join Filter: (load_prop.property_id = aac.property_id)
  • Rows Removed by Join Filter: 2,474,228
4. 0.647 27.794 ↓ 360.0 360 1

Nested Loop (cost=0.54..3.31 rows=1 width=34) (actual time=24.473..27.794 rows=360 loops=1)

5. 24.627 24.627 ↓ 360.0 360 1

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

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

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

  • Index Cond: (id = load_prop.property_id)
  • Filter: (cid = 235)
7. 745.920 745.920 ↓ 1,378.4 6,892 360

Seq Scan on ap_amount_temp aac (cost=0.00..163.40 rows=5 width=1,154) (actual time=0.004..2.072 rows=6,892 loops=360)

  • Filter: (cid = 235)