explain.depesz.com

A tool for finding a real cause for slow queries.

Result: kY5k

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..8795.49 rows=1 width=12) (actual time=.. rows= loops=)

  • Join Filter: ((com.com_use_fed_contracts = 1) OR ((com.com_use_fed_contracts > 1) AND ((SubPlan 5) > 0)))
2. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=0.00..8767.09 rows=1 width=28) (actual time=.. rows= loops=)

  • Join Filter: (i9.i9_key = get_primaryi9key(emp.emp_key))
  • Filter: CASE WHEN (i9.i9_key IS NOT NULL) THEN (i9.i9_emp_start_date < '1986-11-07'::date) ELSE (emp.emp_date_started < '1986-11-07'::date) END
3. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=0.00..14.59 rows=1 width=24) (actual time=.. rows= loops=)

  • Join Filter: (bpt.bpt_emp_key = emp.emp_key)
  • Filter: (bpt.bpt_key IS NULL)
4. 0.000 0.000 ↓ 0.0
→

Index Scan using pkey_emp on emp (cost=0.00..7.31 rows=1 width=24) (actual time=.. rows= loops=)

  • Index Cond: (emp_key = 156232)
  • Filter: ((emp_has_hspd12 IS FALSE) AND (emp_has_topsecret IS FALSE) AND (emp_provides_support_only IS FALSE) AND (emp_on_leave IS FALSE))
5. 0.000 0.000 ↓ 0.0
→

Index Scan using idx_bpt_emp_key on bpt (cost=0.00..7.27 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: (bpt.bpt_emp_key = 156232)
  • Filter: ((bpt.bpt_final_option)::text = ANY ('{EAUTH,EELIG}'::text[]))
6. 0.000 0.000 ↓ 0.0
→

Seq Scan on i9 (cost=0.00..2802.23 rows=22244 width=8) (actual time=.. rows= loops=)

  • Filter: ((i9.i9_version IS NOT NULL) AND ((i9.i9_version)::date <> '1987-05-07'::date))
7. 0.000 0.000 ↓ 0.0
→

Index Scan using pkey_com on com (cost=0.00..7.27 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: (com.com_key = emp.emp_com_key)
8.          

SubPlan (forNested Loop)
9. 0.000 0.000 ↓ 0.0
→

Aggregate (cost=21.10..21.11 rows=1 width=0) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0
→

Seq Scan on cnt (cost=5.85..21.10 rows=1 width=0) (actual time=.. rows= loops=)

  • Filter: ((cnt_scope > 0) AND (cnt_level = 1) AND ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (hashed SubPlan 3) OR (hashed SubPlan 4)))
11.          

SubPlan (forSeq Scan)
12. 0.000 0.000 ↓ 0.0
→

Seq Scan on empcnt (cost=0.00..2.09 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: (empcnt_emp_key = $0)
13. 0.000 0.000 ↓ 0.0
→

Seq Scan on occcnt (cost=0.00..1.34 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: (occcnt_occ_key = $2)
14. 0.000 0.000 ↓ 0.0
→

Seq Scan on loccnt (cost=0.00..1.34 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: (loccnt_loc_key = $4)
15. 0.000 0.000 ↓ 0.0
→

Seq Scan on buncnt (cost=0.00..1.07 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: (buncnt_bun_key = $6)