explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wf0P

Settings
# exclusive inclusive rows x rows loops node
1. 860.568 2,319.992 ↓ 2.7 91,214 1

Index Scan using dim_assignments_stipends_idx on dim_assignments a (cost=0.42..1,144,029.26 rows=33,291 width=278) (actual time=0.223..2,319.992 rows=91,214 loops=1)

  • Filter: (((job_type)::text = 'Hourly'::text) AND (tsrange((to_date('201939'::text, 'IYYYIW'::text))::timestamp without time zone, ((to_date('201939'::text, 'IYYYIW'::text) + '7 days'::interval) - '00:00:00.000001'::interval), '[]'::text) && active_range))
  • Rows Removed by Filter: 27732
2.          

SubPlan (forIndex Scan)

3. 729.712 729.712 ↑ 1.0 1 91,214

Index Scan using dim_developers_pkey on dim_developers d (cost=0.56..8.59 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=91,214)

  • Index Cond: (id = a.developer_id)
4. 456.070 456.070 ↑ 1.0 1 91,214

Index Scan using dim_companies_pkey on dim_companies c (cost=0.43..8.46 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=91,214)

  • Index Cond: (id = a.company_id)
5. 182.428 182.428 ↑ 1.0 1 91,214

Index Scan using dim_companies_pkey on dim_companies c_1 (cost=0.43..8.45 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=91,214)

  • Index Cond: (id = a.company_id)
6. 91.214 91.214 ↓ 0.0 0 91,214

Index Scan using part_data_billing_weeks_201939_contract_id_idx on part_data_billing_weeks_201939 (cost=0.28..8.29 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=91,214)

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