explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a55R

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 882.661 ↑ 1.0 1 1

Aggregate (cost=45,940.51..45,940.52 rows=1 width=40) (actual time=882.661..882.661 rows=1 loops=1)

2. 5.914 882.720 ↓ 0.0 0 1

Gather (cost=1,002.30..45,814.60 rows=5 width=13) (actual time=882.657..882.720 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.824 876.806 ↓ 0.0 0 3 / 3

Nested Loop (cost=2.30..44,814.10 rows=2 width=13) (actual time=876.806..876.806 rows=0 loops=3)

4. 1.489 217.821 ↑ 7.3 1,011 3 / 3

Hash Join (cost=1.88..18,637.43 rows=7,377 width=21) (actual time=65.158..217.821 rows=1,011 loops=3)

  • Hash Cond: ((refrqst_t.refl_rqst_cd)::text = (refrqstcd_t.refl_rqst_cd)::text)
5. 216.297 216.297 ↑ 1.2 7,476 3 / 3

Parallel Seq Scan on refrqst_t (cost=0.00..18,608.55 rows=9,280 width=25) (actual time=14.767..216.297 rows=7,476 loops=3)

  • Filter: ((refl_stus_cd)::text <> ALL ('{RTCT,CMPD}'::text[]))
  • Rows Removed by Filter: 176,411
6. 0.013 0.035 ↑ 1.0 31 3 / 3

Hash (cost=1.49..1.49 rows=31 width=4) (actual time=0.035..0.035 rows=31 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
7. 0.022 0.022 ↑ 1.0 31 3 / 3

Seq Scan on refrqstcd_t (cost=0.00..1.49 rows=31 width=4) (actual time=0.013..0.022 rows=31 loops=3)

  • Filter: ((use_typ)::text = 'GENL'::text)
  • Rows Removed by Filter: 8
8. 658.161 658.161 ↓ 0.0 0 3,033 / 3

Index Scan using ixpk_dcpscase_t on dcpscase_t (cost=0.42..3.54 rows=1 width=8) (actual time=0.651..0.651 rows=0 loops=3,033)

  • Index Cond: (dcps_case_uid = refrqst_t.dcps_case_uid)
  • Filter: (((case_stus_cd)::text <> '4'::text) AND ((refrqst_t.rqstd_by_user_org_uid = 650) OR (asgnd_user_org_uid = 650)))
  • Rows Removed by Filter: 1
9.          

SubPlan (for Aggregate)

10. 0.000 0.000 ↓ 0.0 0

Limit (cost=25.15..25.16 rows=1 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=25.15..25.16 rows=1 width=8) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..25.14 rows=1 width=0) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..16.97 rows=1 width=4) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using ixn02_prccomm_t on prccomm_t (cost=0.42..8.45 rows=1 width=4) (never executed)

  • Index Cond: (prnt_prc_id = refrqst_t.refl_rqst_uid)
  • Filter: ((prc_typ_cd)::text = 'REFL'::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using ixf01_commrcpnt_t on commrcpnt_t (cost=0.43..8.52 rows=1 width=8) (never executed)

  • Index Cond: (prc_comm_uid = prccomm_t.prc_comm_uid)
  • Filter: ((rcpnt_user_org_uid = 650) AND ((comm_rcv_sw)::text = 'Y'::text))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using ixf01_comrcpatvt_t on comrcpatvt_t (cost=0.43..8.15 rows=2 width=4) (never executed)

  • Index Cond: (comm_rcpnt_uid = commrcpnt_t.comm_rcpnt_uid)
  • Filter: ((comm_read_sw)::text = 'N'::text)
Planning time : 81.020 ms
Execution time : 882.923 ms