explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xPiC

Settings
# exclusive inclusive rows x rows loops node
1. 406.642 1,439.015 ↓ 231.3 98,775 1

Nested Loop (cost=0.44..31,809.72 rows=427 width=279) (actual time=0.256..1,439.015 rows=98,775 loops=1)

  • Join Filter: (timerange.trange && a.active_range)
  • Rows Removed by Join Filter: 27030
2.          

CTE timerange

3. 0.078 0.078 ↑ 1.0 1 1

Result (cost=0.00..0.03 rows=1 width=32) (actual time=0.076..0.078 rows=1 loops=1)

4. 0.080 0.080 ↑ 1.0 1 1

CTE Scan on timerange (cost=0.00..0.02 rows=1 width=32) (actual time=0.078..0.080 rows=1 loops=1)

5. 143.318 143.318 ↓ 1.5 125,805 1

Index Scan using dim_assignments_stipends_idx on dim_assignments a (cost=0.42..16,305.26 rows=85,403 width=161) (actual time=0.011..143.318 rows=125,805 loops=1)

  • Filter: ((job_type)::text = 'Hourly'::text)
  • Rows Removed by Filter: 2076
6.          

SubPlan (for Nested Loop)

7. 296.325 296.325 ↑ 1.0 1 98,775

Index Scan using dim_developers_pkey on dim_developers d (cost=0.56..8.59 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=98,775)

  • Index Cond: (id = a.developer_id)
8. 296.325 296.325 ↑ 1.0 1 98,775

Index Scan using dim_companies_pkey on dim_companies c (cost=0.43..8.46 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=98,775)

  • Index Cond: (id = a.company_id)
9. 197.550 197.550 ↑ 1.0 1 98,775

Index Scan using dim_companies_pkey on dim_companies c_1 (cost=0.43..8.45 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=98,775)

  • Index Cond: (id = a.company_id)
10. 98.775 98.775 ↓ 0.0 0 98,775

Index Scan using part_data_billing_weeks_201944_contract_id_idx on part_data_billing_weeks_201944 (cost=0.28..8.30 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=98,775)

  • Index Cond: (contract_id = a.id)
Planning time : 0.361 ms