explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X1d

Settings
# exclusive inclusive rows x rows loops node
1. 201.835 853.077 ↓ 7,187.0 7,187 1

GroupAggregate (cost=13,848.81..13,849.38 rows=1 width=516) (actual time=643.555..853.077 rows=7,187 loops=1)

  • Output: ah.id, ah.cid, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, CASE WHEN (ah.lease_customer_id IS NULL) THEN ((((COALESCE(ap.company_name, ''::character varying))::text || ' '::text) || (COALESCE(apl.location_name, ''::character varying))::text))::character varying ELSE func_format_refund_customer_names(ah.header_memo, false) END, CASE WHEN (max(ad.property_id) <> min(ad.property_id)) THEN 'Multiple'::text ELSE max((p.property_name)::text) END, sum(COALESCE(ad.pre_approval_amount, '0'::numeric)), sum(COALESCE(ad.transaction_amount, '0'::numeric)), sum(COALESCE(ad.transaction_amount_due, '0'::numeric)), ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.header_memo, CASE WHEN (ah.header_memo IS NOT NULL) THEN func_format_refund_customer_names(ah.header_memo, false) ELSE NULL::character varying END, ah.is_temporary, (ah.is_posted)::integer, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on, ap.ap_payee_status_type_id, apa.account_number, ad.ap_export_batch_id, CASE WHEN (fa.ap_header_id IS NOT NULL) THEN 1 ELSE 0 END, apl.vendor_code, ap.company_name, apl.location_name, fa.ap_header_id
  • Group Key: ah.id, ah.cid, ap.ap_payee_status_type_id, apa.account_number, ap.company_name, apl.vendor_code, apl.location_name, ad.ap_export_batch_id, fa.ap_header_id
  • Buffers: shared hit=204083 read=4917, local hit=2
2. 31.036 651.242 ↓ 11,274.0 11,274 1

Sort (cost=13,848.81..13,848.82 rows=1 width=355) (actual time=643.520..651.242 rows=11,274 loops=1)

  • Output: ah.id, ah.cid, ap.ap_payee_status_type_id, apa.account_number, ad.ap_export_batch_id, apl.vendor_code, ap.company_name, apl.location_name, fa.ap_header_id, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, ah.header_memo, ad.property_id, p.property_name, ad.pre_approval_amount, ad.transaction_amount, ad.transaction_amount_due, ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.is_temporary, ah.is_posted, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on
  • Sort Key: ah.id DESC, ap.ap_payee_status_type_id, apa.account_number, ap.company_name, apl.vendor_code, apl.location_name, ad.ap_export_batch_id, fa.ap_header_id
  • Sort Method: quicksort Memory: 3827kB
  • Buffers: shared hit=204083 read=4917, local hit=2
3. 27.163 620.206 ↓ 11,274.0 11,274 1

Nested Loop Left Join (cost=1,460.12..13,848.80 rows=1 width=355) (actual time=9.350..620.206 rows=11,274 loops=1)

  • Output: ah.id, ah.cid, ap.ap_payee_status_type_id, apa.account_number, ad.ap_export_batch_id, apl.vendor_code, ap.company_name, apl.location_name, fa.ap_header_id, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, ah.header_memo, ad.property_id, p.property_name, ad.pre_approval_amount, ad.transaction_amount, ad.transaction_amount_due, ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.is_temporary, ah.is_posted, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on
  • Buffers: shared hit=204083 read=4917, local hit=2
4. 31.935 435.207 ↓ 11,274.0 11,274 1

Nested Loop (cost=1,457.45..13,846.11 rows=1 width=351) (actual time=9.276..435.207 rows=11,274 loops=1)

  • Output: ah.id, ah.cid, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, ah.header_memo, ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.is_temporary, ah.is_posted, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on, ap.company_name, ap.ap_payee_status_type_id, apl.location_name, apl.vendor_code, ad.property_id, ad.pre_approval_amount, ad.transaction_amount, ad.transaction_amount_due, ad.ap_export_batch_id, p.property_name, apa.account_number
  • Inner Unique: true
  • Buffers: shared hit=164726 read=3448, local hit=2
5. 25.580 369.450 ↓ 11,274.0 11,274 1

Nested Loop (cost=1,457.17..13,845.81 rows=1 width=334) (actual time=9.236..369.450 rows=11,274 loops=1)

  • Output: ah.id, ah.cid, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, ah.header_memo, ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.is_temporary, ah.is_posted, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on, ap.company_name, ap.ap_payee_status_type_id, apl.location_name, apl.vendor_code, ad.property_id, ad.pre_approval_amount, ad.transaction_amount, ad.transaction_amount_due, ad.ap_export_batch_id, ad.cid, apa.account_number
  • Buffers: shared hit=130930 read=3422, local hit=2
6. 17.901 157.008 ↓ 7,187.0 7,187 1

Nested Loop (cost=1,454.43..13,838.39 rows=1 width=312) (actual time=8.983..157.008 rows=7,187 loops=1)

  • Output: ah.id, ah.cid, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, ah.header_memo, ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.is_temporary, ah.is_posted, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on, ah.control_total, ap.company_name, ap.ap_payee_status_type_id, apl.location_name, apl.vendor_code, apa.account_number
  • Inner Unique: true
  • Buffers: shared hit=59202 read=608
7. 17.033 103.172 ↓ 552.8 7,187 1

Nested Loop (cost=1,454.01..13,828.84 rows=13 width=287) (actual time=8.935..103.172 rows=7,187 loops=1)

  • Output: ah.id, ah.cid, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, ah.header_memo, ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.is_temporary, ah.is_posted, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on, ah.control_total, apl.location_name, apl.vendor_code, apa.account_number
  • Inner Unique: true
  • Buffers: shared hit=30604 read=448
8. 13.693 50.204 ↓ 15.8 7,187 1

Hash Join (cost=1,453.59..13,497.85 rows=456 width=272) (actual time=8.899..50.204 rows=7,187 loops=1)

  • Output: ah.id, ah.cid, ah.ap_payee_id, ah.ap_header_sub_type_id, ah.ap_payee_term_id, ah.lease_customer_id, ah.ap_payment_id, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.refund_ar_transaction_id, ah.transaction_datetime, ah.bulk_is_confidential, ah.header_memo, ah.post_date, ah.due_date, ah.post_month, ah.header_number, ah.account_number, ah.is_temporary, ah.is_posted, ah.ap_financial_status_type_id, ah.is_initial_import, ah.created_on, ah.ap_payee_location_id, ah.control_total, apa.account_number
  • Inner Unique: true
  • Hash Cond: (ah.ap_payee_account_id = apa.id)
  • Buffers: shared hit=2000 read=288
9. 27.732 27.732 ↑ 1.9 7,187 1

Index Scan using idx_ap_headers_ap_payment_id on public.ap_headers ah (cost=0.43..12,009.34 rows=13,468 width=266) (actual time=0.099..27.732 rows=7,187 loops=1)

  • Output: ah.id, ah.cid, ah.ap_header_type_id, ah.ap_header_sub_type_id, ah.ap_header_mode_id, ah.ap_physical_status_type_id, ah.ap_financial_status_type_id, ah.ap_payee_id, ah.order_header_id, ah.ap_payee_location_id, ah.ap_payee_account_id, ah.ap_remittance_id, ah.ap_payee_term_id, ah.inter_co_ap_payee_id, ah.inter_co_ap_payee_location_id, ah.inter_co_ap_payee_account_id, ah.inter_co_ap_remittance_id, ah.gl_transaction_type_id, ah.job_phase_id, ah.ap_contract_id, ah.bulk_job_phase_id, ah.bulk_ap_contract_id, ah.bulk_bank_account_id, ah.bulk_property_id, ah.bulk_ap_formula_id, ah.bulk_ap_code_id, ah.bulk_unit_number_id, ah.bulk_company_department_id, ah.bulk_gl_dimension_id, ah.bulk_property_building_id, ah.bulk_budget_ap_header_id, ah.ap_contract_ap_header_ids, ah.po_ap_header_ids, ah.reversal_ap_header_id, ah.payment_ap_header_id, ah.scheduled_ap_header_id, ah.template_ap_header_id, ah.reimbursement_ap_header_id, ah.frequency_id, ah.lease_customer_id, ah.refund_ar_transaction_id, ah.ap_batch_id, ah.ap_header_export_batch_id, ah.ap_payment_id, ah.compliance_job_id, ah.ap_routing_tag_id, ah.budget_change_order_id, ah.remote_primary_key, ah.template_name, ah.transaction_datetime, ah.post_date, ah.due_date, ah.post_month, ah.scheduled_payment_date, ah.start_date, ah.end_date, ah.frequency_interval, ah.day_of_week, ah.days_of_month, ah.number_of_occurrences, ah.last_posted_date, ah.next_post_date, ah.header_number, ah.external_url, ah.account_number, ah.header_memo, ah.control_total, ah.pre_approval_amount, ah.transaction_amount, ah.transaction_amount_due, ah.tax_amount, ah.discount_amount, ah.auto_create_po, ah.shipping_amount, ah.bulk_retention_percent, ah.bulk_is_confidential, ah.bulk_is_1099, ah.auto_approve_po, ah.auto_create_invoice, ah.auto_approve_invoice, ah.auto_post_invoice, ah.pay_with_single_check, ah.is_deleted, ah.is_reversed, ah.is_primary, ah.is_on_hold, ah.is_template, ah.is_disabled, ah.is_reimbursement, ah.is_batching, ah.is_temporary, ah.is_posted, ah.is_initial_import, ah.is_sync_to_va, ah.posted_on, ah.imported_on, ah.retention_released_by, ah.retention_released_on, ah.approved_by, ah.approved_on, ah.deleted_by, ah.deleted_on, ah.updated_by, ah.updated_on, ah.created_by, ah.created_on
  • Index Cond: ((ah.cid = 15573) AND (ah.ap_payment_id IS NULL))
  • Filter: ((NOT ah.is_batching) AND (ah.reversal_ap_header_id IS NULL) AND (ah.is_posted OR ((NOT ah.is_posted) AND ((ah.ap_financial_status_type_id IS NULL) OR (ah.ap_financial_status_type_id <> 6)))) AND (ah.ap_header_type_id = 5) AND (ah.ap_header_sub_type_id = ANY ('{5,6,7,8,17,12}'::integer[])))
  • Rows Removed by Filter: 4412
  • Buffers: shared hit=1647 read=131
10. 3.005 8.779 ↑ 1.1 4,127 1

Hash (cost=1,397.97..1,397.97 rows=4,415 width=18) (actual time=8.779..8.779 rows=4,127 loops=1)

  • Output: apa.account_number, apa.cid, apa.id
  • Buckets: 8192 Batches: 1 Memory Usage: 226kB
  • Buffers: shared hit=353 read=157
11. 5.774 5.774 ↑ 1.1 4,127 1

Index Scan using pk_ap_payee_accounts on public.ap_payee_accounts apa (cost=0.42..1,397.97 rows=4,415 width=18) (actual time=0.049..5.774 rows=4,127 loops=1)

  • Output: apa.account_number, apa.cid, apa.id
  • Index Cond: (apa.cid = 15573)
  • Buffers: shared hit=353 read=157
12. 35.935 35.935 ↑ 1.0 1 7,187

Index Scan using idx_ap_payee_locations_id on public.ap_payee_locations apl (cost=0.42..0.73 rows=1 width=27) (actual time=0.005..0.005 rows=1 loops=7,187)

  • Output: apl.id, apl.cid, apl.ap_payee_id, apl.default_ap_routing_tag_id, apl.ap_legal_entity_id, apl.store_id, apl.payee_name, apl.vendor_code, apl.location_name, apl.location_datetime, apl.phone_number, apl.street_line1, apl.street_line2, apl.street_line3, apl.city, apl.state_code, apl.fax_number, apl.mobile_number, apl.email_address, apl.province, apl.postal_code, apl.country_code, apl.notes, apl.duns_number, apl.is_primary, apl.disabled_by, apl.disabled_on, apl.deleted_by, apl.deleted_on, apl.updated_by, apl.updated_on, apl.created_by, apl.created_on
  • Index Cond: (apl.id = ah.ap_payee_location_id)
  • Filter: (apl.cid = 15573)
  • Buffers: shared hit=28604 read=160
13. 35.935 35.935 ↑ 1.0 1 7,187

Index Scan using pk_ap_payees on public.ap_payees ap (cost=0.42..0.73 rows=1 width=33) (actual time=0.005..0.005 rows=1 loops=7,187)

  • Output: ap.id, ap.cid, ap.integration_database_id, ap.ap_payee_term_id, ap.default_ap_remittance_id, ap.gl_account_id, ap.vendor_id, ap.ap_payee_type_id, ap.ap_payee_status_type_id, ap.categorization_type_id, ap.confidentiality_allowance_type_id, ap.cam_allowance_type_id, ap.vendor_category_type_id, ap.compliance_rulset_id, ap.reference_id, ap.customer_id, ap.secondary_number, ap.remote_primary_key, ap.system_code, ap.company_name, ap.username, ap.website_url, ap.notes, ap.sales_tax_description, ap.shipping_description, ap.discount_description, ap.require_po_for_invoice, ap.is_categorization_queued, ap.is_consolidated, ap.is_system, ap.is_on_site, ap.is_utilities, ap.is_capture_invoice_total_only, ap.updated_by, ap.updated_on, ap.created_by, ap.created_on
  • Index Cond: ((ap.cid = 15573) AND (ap.id = ah.ap_payee_id))
  • Buffers: shared hit=28598 read=160
14. 108.707 186.862 ↓ 2.0 2 7,187

Index Scan using idx_ap_details_cid_apheaderid on public.ap_details ad (cost=2.75..7.41 rows=1 width=29) (actual time=0.018..0.026 rows=2 loops=7,187)

  • Output: ad.id, ad.cid, ad.ap_header_id, ad.order_detail_id, ad.ap_physical_status_type_id, ad.gl_transaction_type_id, ad.ap_transaction_type_id, ad.ap_post_type_id, ad.bank_account_id, ad.property_id, ad.inter_co_property_id, ad.property_unit_id, ad.ap_formula_id, ad.company_department_id, ad.gl_dimension_id, ad.job_phase_id, ad.ap_contract_id, ad.budget_ap_header_id, ad.ap_contract_ap_detail_id, ad.po_ap_detail_id, ad.reversal_ap_detail_id, ad.scheduled_ap_detail_id, ad.template_ap_detail_id, ad.reimbursement_ap_detail_id, ad.unit_of_measure_id, ad.ap_catalog_item_id, ad.ap_code_id, ad.ap_payee_sub_account_id, ad.job_ap_code_id, ad.gl_account_id, ad.ap_gl_account_id, ad.wip_gl_account_id, ad.purchases_clearing_gl_account_id, ad.pending_reimbursements_gl_account_id, ad.inter_co_ap_gl_account_id, ad.inter_co_bank_account_id, ad.bank_gl_account_id, ad.retention_payable_gl_account_id, ad.accrual_debit_gl_account_id, ad.accrual_credit_gl_account_id, ad.cash_debit_gl_account_id, ad.cash_credit_gl_account_id, ad.inter_co_ar_transaction_id, ad.refund_ar_transaction_id, ad.ap_export_batch_id, ad.fee_id, ad.period_id, ad.property_building_id, ad.unclaimed_ap_payment_id, ad.property_cam_pool_id, ad.post_month, ad.remote_primary_key, ad.transaction_datetime, ad.quantity_ordered, ad.quantity_received, ad.rate, ad.subtotal_amount, ad.tax_amount, ad.discount_amount, ad.shipping_amount, ad.pre_approval_amount, ad.transaction_amount, ad.transaction_amount_due, ad.initial_amount_due, ad.drawn_amount, ad.retention_amount, ad.description, ad.details, ad.is_reimbursement, ad.is_disbursement, ad.is_confidential, ad.is_1099, ad.is_approved_for_payment, ad.is_deleted, ad.is_reversed, ad.is_cross_allocation, ad.payment_approved_by, ad.payment_approved_on, ad.exported_by, ad.exported_on, ad.approved_by, ad.approved_on, ad.deleted_by, ad.deleted_on, ad.updated_by, ad.updated_on, ad.created_by, ad.created_on, ad.old_po_detail_id, ad.unit_type_id, ad.maintenance_location_id
  • Index Cond: ((ad.cid = 15573) AND (ad.ap_header_id = ah.id))
  • Filter: ((ad.deleted_by IS NULL) AND (ad.deleted_on IS NULL) AND CASE WHEN (ah.control_total = '0'::numeric) THEN CASE WHEN (ah.lease_customer_id IS NOT NULL) THEN (hashed SubPlan 1) ELSE (SubPlan 3) END ELSE ((ah.id = ah.id) AND (ah.cid = ah.cid)) END)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=71728 read=2814, local hit=2
15.          

SubPlan (forIndex Scan)

16. 0.063 0.063 ↑ 1.0 105 1

Seq Scan on pg_temp_39.load_properties_info (cost=0.00..2.05 rows=105 width=4) (actual time=0.009..0.063 rows=105 loops=1)

  • Output: load_properties_info.property_id
  • Buffers: local hit=1
17. 22.223 78.092 ↑ 1.0 1 11,156

Result (cost=0.43..2.65 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=11,156)

  • One-Time Filter: (hashed SubPlan 2)
  • Buffers: shared hit=44668, local hit=1
18. 55.780 55.780 ↑ 1.0 1 11,156

Index Scan using idx_ap_details_cid_apheaderid on public.ap_details (cost=0.43..2.65 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=11,156)

  • Output: ap_details.id, ap_details.cid, ap_details.ap_header_id, ap_details.order_detail_id, ap_details.ap_physical_status_type_id, ap_details.gl_transaction_type_id, ap_details.ap_transaction_type_id, ap_details.ap_post_type_id, ap_details.bank_account_id, ap_details.property_id, ap_details.inter_co_property_id, ap_details.property_unit_id, ap_details.ap_formula_id, ap_details.company_department_id, ap_details.gl_dimension_id, ap_details.job_phase_id, ap_details.ap_contract_id, ap_details.budget_ap_header_id, ap_details.ap_contract_ap_detail_id, ap_details.po_ap_detail_id, ap_details.reversal_ap_detail_id, ap_details.scheduled_ap_detail_id, ap_details.template_ap_detail_id, ap_details.reimbursement_ap_detail_id, ap_details.unit_of_measure_id, ap_details.ap_catalog_item_id, ap_details.ap_code_id, ap_details.ap_payee_sub_account_id, ap_details.job_ap_code_id, ap_details.gl_account_id, ap_details.ap_gl_account_id, ap_details.wip_gl_account_id, ap_details.purchases_clearing_gl_account_id, ap_details.pending_reimbursements_gl_account_id, ap_details.inter_co_ap_gl_account_id, ap_details.inter_co_bank_account_id, ap_details.bank_gl_account_id, ap_details.retention_payable_gl_account_id, ap_details.accrual_debit_gl_account_id, ap_details.accrual_credit_gl_account_id, ap_details.cash_debit_gl_account_id, ap_details.cash_credit_gl_account_id, ap_details.inter_co_ar_transaction_id, ap_details.refund_ar_transaction_id, ap_details.ap_export_batch_id, ap_details.fee_id, ap_details.period_id, ap_details.property_building_id, ap_details.unclaimed_ap_payment_id, ap_details.property_cam_pool_id, ap_details.post_month, ap_details.remote_primary_key, ap_details.transaction_datetime, ap_details.quantity_ordered, ap_details.quantity_received, ap_details.rate, ap_details.subtotal_amount, ap_details.tax_amount, ap_details.discount_amount, ap_details.shipping_amount, ap_details.pre_approval_amount, ap_details.transaction_amount, ap_details.transaction_amount_due, ap_details.initial_amount_due, ap_details.drawn_amount, ap_details.retention_amount, ap_details.description, ap_details.details, ap_details.is_reimbursement, ap_details.is_disbursement, ap_details.is_confidential, ap_details.is_1099, ap_details.is_approved_for_payment, ap_details.is_deleted, ap_details.is_reversed, ap_details.is_cross_allocation, ap_details.payment_approved_by, ap_details.payment_approved_on, ap_details.exported_by, ap_details.exported_on, ap_details.approved_by, ap_details.approved_on, ap_details.deleted_by, ap_details.deleted_on, ap_details.updated_by, ap_details.updated_on, ap_details.created_by, ap_details.created_on, ap_details.old_po_detail_id, ap_details.unit_type_id, ap_details.maintenance_location_id
  • Index Cond: ((ap_details.cid = 15573) AND (ah.id = ap_details.ap_header_id))
  • Filter: ((ap_details.deleted_by IS NULL) AND (ap_details.deleted_on IS NULL))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=44668
19.          

SubPlan (forResult)

20. 0.089 0.089 ↑ 1.0 105 1

Seq Scan on pg_temp_39.load_properties_info load_properties_info_1 (cost=0.00..2.05 rows=105 width=4) (actual time=0.034..0.089 rows=105 loops=1)

  • Output: load_properties_info_1.property_id
  • Buffers: local hit=1
21. 33.822 33.822 ↑ 1.0 1 11,274

Index Scan using idx_properties_id on public.properties p (cost=0.28..0.31 rows=1 width=29) (actual time=0.003..0.003 rows=1 loops=11,274)

  • Output: p.id, p.cid, p.property_id, p.property_type_id, p.company_region_id, p.time_zone_id, p.owner_id, p.account_id, p.occupancy_type_ids, p.remote_primary_key, p.property_name, p.lookup_code, p.country_code, p.vaultware_number, p.min_rent, p.max_rent, p.min_square_feet, p.max_square_feet, p.min_bedrooms, p.max_bedrooms, p.min_bathrooms, p.max_bathrooms, p.number_of_units, p.year_built, p.year_remodeled, p.short_description, p.full_description, p.driving_directions, p.termination_reason, p.termination_date, p.details, p.allows_cats, p.allows_dogs, p.has_availability, p.is_disabled, p.is_test, p.is_managerial, p.order_num, p.imported_on, p.disabled_on, p.updated_by, p.updated_on, p.created_by, p.created_on, p.locale_code
  • Index Cond: (p.id = ad.property_id)
  • Filter: (p.cid = 15573)
  • Buffers: shared hit=33796 read=26
22. 33.822 157.836 ↑ 1.0 1 11,274

Limit (cost=2.66..2.67 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=11,274)

  • Output: fa.id, fa.ap_header_id
  • Buffers: shared hit=39357 read=1469
23. 45.096 124.014 ↑ 1.0 1 11,274

Sort (cost=2.66..2.67 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=11,274)

  • Output: fa.id, fa.ap_header_id
  • Sort Key: fa.id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=39357 read=1469
24. 78.918 78.918 ↑ 1.0 1 11,274

Index Scan using idx_file_associations_cid_ap_header_id on public.file_associations fa (cost=0.43..2.65 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=11,274)

  • Output: fa.id, fa.ap_header_id
  • Index Cond: ((ah.cid = fa.cid) AND (ah.id = fa.ap_header_id))
  • Filter: (fa.deleted_by IS NULL)
  • Buffers: shared hit=39357 read=1469