explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZCg : Optimization for: Optimization for: plan #4Jl6; plan #V9Hj

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 898.143 1,345.911 ↓ 158.1 1,613,738 1

Gather (cost=1,000.00..47,660.65 rows=10,205 width=806) (actual time=0.328..1,345.911 rows=1,613,738 loops=1)

  • Output: row_id, customer_number, customer_status, debt_date, debt_amount, landing_page_id, landing_page, "Gender", external_payment_reference, credit_status, sales_person_id, sales_person_name, region, amount_sent_to_debt_agency, date_sent_to_debt_agency, amount_from_debt_agency, date_received_from_debt_agency, latest_account_balance
  • Workers Planned: 2
  • Workers Launched: 2
2. 447.768 447.768 ↓ 126.5 537,913 3

Parallel Seq Scan on public.ek_sprst_mv_debt_customer_details (cost=0.00..45,640.15 rows=4,252 width=806) (actual time=0.032..447.768 rows=537,913 loops=3)

  • Output: row_id, customer_number, customer_status, debt_date, debt_amount, landing_page_id, landing_page, "Gender", external_payment_reference, credit_status, sales_person_id, sales_person_name, region, amount_sent_to_debt_agency, date_sent_to_debt_agency, amount_from_debt_agency, date_received_from_debt_agency, latest_account_balance
  • Filter: (ek_sprst_mv_debt_customer_details.landing_page_id = 0)
  • Rows Removed by Filter: 142417
  • Worker 0: actual time=0.033..636.623 rows=760056 loops=1
  • Worker 1: actual time=0.029..688.628 rows=850253 loops=1