explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yxi6

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

GroupAggregate (cost=2,687,680.02..2,758,246.17 rows=82,548 width=45) (actual rows= loops=)

  • Group Key: apng.ans_endorsedt, apng.ans_st_cd, apng.ans_rto_cd, 501, apng.ans_accd
2. 0.000 0.000 ↓ 0.0

Sort (cost=2,687,680.02..2,691,782.41 rows=1,640,957 width=36) (actual rows= loops=)

  • Sort Key: apng.ans_endorsedt, apng.ans_st_cd, apng.ans_rto_cd, apng.ans_accd
3. 0.000 0.000 ↓ 0.0

Gather (cost=624,720.92..2,518,283.16 rows=1,640,957 width=36) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=623,720.92..2,353,187.46 rows=683,732 width=36) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on applnextstg apng (cost=623,720.35..775,731.81 rows=34,972 width=25) (actual rows= loops=)

  • Recheck Cond: (((ans_st_cd)::text = ANY ('{GJ,HR,MH,JH}'::text[])) AND (ans_trcd = ANY ('{509,501}'::numeric[])) AND (ans_accd = ANY ('{105,101,115,103,102,134,132,123,135}'::numeric[]
6. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=623,720.35..623,720.35 rows=83,934 width=0) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on indx_applnextstg_ans_st_cd (cost=0.00..181,394.76 rows=3,277,667 width=0) (actual rows= loops=)

  • Index Cond: ((ans_st_cd)::text = ANY ('{GJ,HR,MH,JH}'::text[]))
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_applnextstg_ans_trcd (cost=0.00..216,642.39 rows=3,248,968 width=0) (actual rows= loops=)

  • Index Cond: (ans_trcd = ANY ('{509,501}'::numeric[]))
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_applnextstg_ans_accd (cost=0.00..225,619.76 rows=4,045,961 width=0) (actual rows= loops=)

  • Index Cond: (ans_accd = ANY ('{105,101,115,103,102,134,132,123,135}'::numeric[]))
10. 0.000 0.000 ↓ 0.0

Index Scan using pk_wflows on wflows f (cost=0.57..44.82 rows=29 width=15) (actual rows= loops=)

  • Index Cond: (wf_applno = apng.ans_applno)
  • Filter: (wf_accd <> '210'::numeric)