explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b4lB

Settings
# exclusive inclusive rows x rows loops node
1. 11,796.684 59,457.764 ↓ 3.0 91,480 1

Index Scan using dim_assignments_stipends_idx on dim_assignments a (cost=0.42..1,035,482.75 rows=30,102 width=277) (actual time=0.185..59,457.764 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. 32,018.000 32,018.000 ↑ 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.349..0.350 rows=1 loops=91,480)

  • Index Cond: (id = a.developer_id)
4. 15,185.680 15,185.680 ↑ 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.166..0.166 rows=1 loops=91,480)

  • Index Cond: (id = a.company_id)
5. 274.440 274.440 ↑ 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.003..0.003 rows=1 loops=91,480)

  • Index Cond: (id = a.company_id)
6. 182.960 182.960 ↓ 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.002..0.002 rows=0 loops=91,480)

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