explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JI8

Settings
# exclusive inclusive rows x rows loops node
1. 411.187 1,440.835 ↓ 231.3 98,775 1

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

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

CTE timerange

3. 0.013 0.013 ↑ 1.0 1 1

Result (cost=0.00..0.03 rows=1 width=32) (actual time=0.012..0.013 rows=1 loops=1)

4. 0.017 0.017 ↑ 1.0 1 1

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

5. 140.656 140.656 ↓ 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.019..140.656 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.382 ms