explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cs5Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.622 ↓ 0.0 0 1

Nested Loop Anti Join (cost=197.55..1,246.61 rows=1 width=26) (actual time=0.622..0.622 rows=0 loops=1)

  • Join Filter: (((bp.contract_transaction_id = ct.contract_transaction_id) OR (bp.contract_transaction_id IS NULL)) AND ((bp.rule_id = r.rule_id) OR (bp.rule_id IS NULL)))
2. 0.000 0.621 ↓ 0.0 0 1

Nested Loop (cost=197.55..1,245.98 rows=1 width=34) (actual time=0.621..0.621 rows=0 loops=1)

  • Join Filter: ((m.agent_id = (-1)) OR (m.agent_id = ct.contract_agent_id))
3. 0.000 0.621 ↓ 0.0 0 1

Nested Loop (cost=197.55..1,245.65 rows=1 width=30) (actual time=0.621..0.621 rows=0 loops=1)

4. 0.000 0.621 ↓ 0.0 0 1

Nested Loop (cost=197.55..1,245.33 rows=1 width=28) (actual time=0.621..0.621 rows=0 loops=1)

5. 0.022 0.621 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,043.45 rows=1 width=54) (actual time=0.621..0.621 rows=0 loops=1)

6. 0.037 0.374 ↓ 25.0 25 1

Nested Loop (cost=0.00..1,039.11 rows=1 width=52) (actual time=0.076..0.374 rows=25 loops=1)

  • Join Filter: (((r.applicable_record_type)::text ~~ (('%'::text || (ct.record_type_id)::text) || '%'::text)) OR (r.applicable_record_type IS NULL))
7. 0.021 0.287 ↓ 6.2 25 1

Nested Loop (cost=0.00..1,037.77 rows=4 width=50) (actual time=0.058..0.287 rows=25 loops=1)

8. 0.016 0.016 ↑ 35.2 25 1

Seq Scan on tmp_transaction_validation r_trans (cost=0.00..36.40 rows=880 width=20) (actual time=0.009..0.016 rows=25 loops=1)

9. 0.250 0.250 ↑ 1.0 1 25

Index Scan using ix_contract_transaction_contract_seq on contract_transaction ct (cost=0.00..1.10 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=25)

  • Index Cond: ((contract_number = r_trans.contract_number) AND (transaction_sequence = r_trans.contract_sequence))
10. 0.050 0.050 ↑ 1.0 1 25

Index Scan using pk_validation_rule on validation_rule r (cost=0.00..0.29 rows=1 width=6) (actual time=0.001..0.002 rows=1 loops=25)

  • Index Cond: (rule_id = 1002)
11. 0.225 0.225 ↓ 0.0 0 25

Index Scan using eval_sg_con_d4_pkey on sg_con_d4 d4 (cost=0.00..4.30 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=25)

  • Index Cond: ((sg_con4_contract = r_trans.contract_number) AND (sg_con4_seq = r_trans.contract_sequence))
  • Filter: ((COALESCE(sg_con4_reserve, 0::numeric) <= 0::numeric) AND ((sg_con4_carrier)::text <> 'NONE'::text))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using eval_sg_con_m1_pkey on sg_con_m1 m1 (cost=197.55..201.85 rows=1 width=21) (never executed)

  • Index Cond: (sg_con_contract = r_trans.contract_number)
  • Filter: ((NOT (hashed SubPlan 1)) AND ((sg_con_cover)::text <> 'HYCO-FRE'::text) AND ((sg_con_plc)::text <> ALL ('{LOJK,FRAL,SGCC,ALRT}'::text[])))
13.          

SubPlan (for Index Scan)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using sg_cov_d3_pkey on sg_cov_d3 (cost=0.00..196.77 rows=313 width=9) (never executed)

  • Index Cond: (sg_cov3_rstype = 'R'::bpchar)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using sg_plc_m1_pkey on sg_plc_m1 plc (cost=0.00..0.29 rows=1 width=7) (never executed)

  • Index Cond: (sg_plc_plc = (m1.sg_con_plc)::bpchar)
  • Filter: ((sg_plc_rstype)::text <> ALL ('{M,E}'::text[]))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using ixfk_validation_rule_agent_mapping_validation_rule on validation_rule_agent_mapping m (cost=0.00..0.29 rows=1 width=12) (never executed)

  • Index Cond: (rule_id = 1002)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using ixfk_error_queue_bypass_agent on error_queue_bypass bp (cost=0.00..0.29 rows=1 width=16) (never executed)

  • Index Cond: (contract_agent_id = ct.contract_agent_id)
  • Filter: bypass_flag
Total runtime : 1.003 ms