explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D4E1

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 14.177 ↓ 0.0 0 1

Nested Loop Anti Join (cost=2.55..2,139.56 rows=4 width=4) (actual time=14.177..14.177 rows=0 loops=1)

  • Join Filter: (casedoc_t.evid_trkg_uid = corrtrkg_t.crsp_trkg_uid)
  • Rows Removed by Join Filter: 6
2. 0.000 10.118 ↑ 1.0 4 1

Nested Loop (cost=1.70..903.09 rows=4 width=8) (actual time=5.795..10.118 rows=4 loops=1)

3. 0.406 6.391 ↓ 11.0 1,881 1

Nested Loop (cost=1.27..811.05 rows=171 width=8) (actual time=0.031..6.391 rows=1,881 loops=1)

4. 0.232 2.223 ↓ 11.0 1,881 1

Nested Loop (cost=0.84..705.72 rows=171 width=8) (actual time=0.025..2.223 rows=1,881 loops=1)

5. 0.593 0.593 ↓ 8.0 233 1

Index Scan using ixf03_dcpscase_t_user_org on dcpscase_t (cost=0.42..369.33 rows=29 width=4) (actual time=0.018..0.593 rows=233 loops=1)

  • Index Cond: (asgnd_user_org_uid = 1532)
  • Filter: ((case_stus_cd)::text <> '4'::text)
  • Rows Removed by Filter: 182
6. 1.398 1.398 ↑ 1.4 8 233

Index Scan using ix01_evrqst_t_dcps_case_uid on evrqst_t (cost=0.42..11.49 rows=11 width=8) (actual time=0.003..0.006 rows=8 loops=233)

  • Index Cond: (dcps_case_uid = dcpscase_t.dcps_case_uid)
  • Filter: (cncln_ts IS NULL)
7. 3.762 3.762 ↑ 1.0 1 1,881

Index Scan using ixf03_rqstuid on corrtrkg_t (cost=0.43..0.61 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,881)

  • Index Cond: (rqst_uid = evrqst_t.ev_rqst_uid)
  • Filter: ((rqst_typ_cd)::text = 'MER'::text)
8. 3.762 3.762 ↓ 0.0 0 1,881

Index Scan using ixn01_dmthdtrkg_t on dmthdtrkg_t (cost=0.43..0.53 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,881)

  • Index Cond: (crsp_trkg_uid = corrtrkg_t.crsp_trkg_uid)
  • Filter: ((rqst_sent_ts IS NOT NULL) AND ((dmthd_cd)::text = 'HIT'::text))
  • Rows Removed by Filter: 1
9. 0.004 4.056 ↓ 2.0 2 4

Materialize (cost=0.85..1,236.42 rows=1 width=4) (actual time=0.774..1.014 rows=2 loops=4)

10. 0.077 4.052 ↓ 4.0 4 1

Nested Loop (cost=0.85..1,236.41 rows=1 width=4) (actual time=3.093..4.052 rows=4 loops=1)

11. 0.455 0.455 ↓ 6.1 176 1

Index Scan using ixf03_dcpscase_t_user_org on dcpscase_t dcpscase_t_1 (cost=0.42..369.33 rows=29 width=4) (actual time=0.015..0.455 rows=176 loops=1)

  • Index Cond: (asgnd_user_org_uid = 1532)
  • Filter: ((case_stus_cd)::text <> '4'::text)
  • Rows Removed by Filter: 181
12. 3.520 3.520 ↓ 0.0 0 176

Index Scan using ixf02_casedoc on casedoc_t (cost=0.43..29.89 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=176)

  • Index Cond: (dcps_case_uid = dcpscase_t_1.dcps_case_uid)
  • Filter: ((evid_trkg_uid IS NOT NULL) AND ((docu_cd)::text = ANY ('{0016,0017,0018,0023,0069}'::text[])))
  • Rows Removed by Filter: 30
Planning time : 1.586 ms
Execution time : 14.250 ms