explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lo5n

Settings
# exclusive inclusive rows x rows loops node
1. 530.342 1,518.092 ↓ 3.0 98,775 1

Index Scan using dim_assignments_stipends_idx on dim_assignments a (cost=0.42..1,129,609.92 rows=32,860 width=279) (actual time=0.119..1,518.092 rows=98,775 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: 29106
2.          

SubPlan (for Index Scan)

3. 395.100 395.100 ↑ 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.004 rows=1 loops=98,775)

  • Index Cond: (id = a.developer_id)
4. 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)
5. 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)
6. 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.386 ms