explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OlTe

Settings
# exclusive inclusive rows x rows loops node
1. 1,299.317 2,945.957 ↓ 3.0 91,480 1

Index Scan using dim_assignments_stipends_idx on dim_assignments a (cost=0.42..1,056,314.53 rows=30,723 width=278) (actual time=0.895..2,945.957 rows=91,480 loops=1)

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

SubPlan (for Index Scan)

3. 823.320 823.320 ↑ 1.0 1 91,480

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

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

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

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

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,480)

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

Index Scan using part_data_billing_weeks_201944_contract_id_idx on part_data_billing_weeks_201944 (cost=0.28..8.29 rows=1 width=7) (actual time=0.001..0.001 rows=0 loops=91,480)

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