explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6TqL

Settings
# exclusive inclusive rows x rows loops node
1. 9.819 321.443 ↓ 0.0 0 1

Gather (cost=2,944.71..37,621.98 rows=2 width=4) (actual time=321.351..321.443 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2.110 311.624 ↓ 0.0 0 3

Nested Loop (cost=1,944.71..36,621.78 rows=1 width=4) (actual time=311.624..311.624 rows=0 loops=3)

3. 58.445 309.511 ↓ 17.9 626 3

Hash Join (cost=1,944.28..36,600.12 rows=35 width=8) (actual time=118.342..309.511 rows=626 loops=3)

  • Hash Cond: (corrtrkg_t.rqst_uid = evrqst_t.ev_rqst_uid)
4. 234.386 246.146 ↓ 1.6 293,598 3

Parallel Seq Scan on corrtrkg_t (cost=1,236.42..35,204.86 rows=183,209 width=8) (actual time=11.788..246.146 rows=293,598 loops=3)

  • Filter: ((NOT (hashed SubPlan 1)) AND ((rqst_typ_cd)::text = 'MER'::text))
  • Rows Removed by Filter: 63172
5.          

SubPlan (for Parallel Seq Scan)

6. 10.903 11.760 ↓ 4.0 4 3

Nested Loop (cost=0.85..1,236.41 rows=1 width=4) (actual time=7.055..11.760 rows=4 loops=3)

7. 0.810 0.810 ↓ 8.0 233 3

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.023..0.810 rows=233 loops=3)

  • Index Cond: (asgnd_user_org_uid = 1532)
  • Filter: ((case_stus_cd)::text <> '4'::text)
  • Rows Removed by Filter: 182
8. 0.047 0.047 ↓ 0.0 0 699

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

  • 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: 32
9. 0.434 4.920 ↓ 11.0 1,881 3

Hash (cost=705.72..705.72 rows=171 width=8) (actual time=4.920..4.920 rows=1,881 loops=3)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 90kB
10. 3.666 4.486 ↓ 11.0 1,881 3

Nested Loop (cost=0.84..705.72 rows=171 width=8) (actual time=0.041..4.486 rows=1,881 loops=3)

11. 0.806 0.806 ↓ 8.0 233 3

Index Scan using ixf03_dcpscase_t_user_org on dcpscase_t (cost=0.42..369.33 rows=29 width=4) (actual time=0.027..0.806 rows=233 loops=3)

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

Index Scan using ix01_evrqst_t_dcps_case_uid on evrqst_t (cost=0.42..11.49 rows=11 width=8) (actual time=0.010..0.014 rows=8 loops=699)

  • Index Cond: (dcps_case_uid = dcpscase_t.dcps_case_uid)
  • Filter: (cncln_ts IS NULL)
13. 0.003 0.003 ↓ 0.0 0 1,877

Index Scan using ixn01_dmthdtrkg_t on dmthdtrkg_t (cost=0.43..0.61 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1,877)

  • 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
Planning time : 1.587 ms
Execution time : 321.580 ms