explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E3WH : ncal

Settings
# exclusive inclusive rows x rows loops node
1. 513.269 1,482.129 ↓ 2.9 96,886 1

Index Scan using dim_assignments_stipends_idx on dim_assignments a (cost=0.42..1,143,728.62 rows=33,277 width=279) (actual time=0.168..1,482.129 rows=96,886 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: 28828
2.          

SubPlan (for Index Scan)

3. 387.544 387.544 ↑ 1.0 1 96,886

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=96,886)

  • Index Cond: (id = a.developer_id)
4. 290.658 290.658 ↑ 1.0 1 96,886

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=96,886)

  • Index Cond: (id = a.company_id)
5. 193.772 193.772 ↑ 1.0 1 96,886

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=96,886)

  • Index Cond: (id = a.company_id)
6. 96.886 96.886 ↓ 0.0 0 96,886

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=3) (actual time=0.001..0.001 rows=0 loops=96,886)

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