explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x2ed

Settings
# exclusive inclusive rows x rows loops node
1. 842.254 587,224.456 ↓ 1.6 131,647 1

GroupAggregate (cost=2,687,725.20..2,758,294.11 rows=82,548 width=45) (actual time=586,137.743..587,224.456 rows=131,647 loops=1)

  • Group Key: apng.ans_endorsedt, apng.ans_st_cd, apng.ans_rto_cd, 501, apng.ans_accd
2. 2,633.938 586,382.202 ↓ 1.0 1,656,280 1

Sort (cost=2,687,725.20..2,691,827.75 rows=1,641,022 width=36) (actual time=586,137.650..586,382.202 rows=1,656,280 loops=1)

  • Sort Key: apng.ans_endorsedt, apng.ans_st_cd, apng.ans_rto_cd, apng.ans_accd
  • Sort Method: quicksort Memory: 178549kB
3. 143.622 583,748.264 ↓ 1.0 1,656,280 1

Gather (cost=624,738.69..2,518,321.16 rows=1,641,022 width=36) (actual time=5,860.752..583,748.264 rows=1,656,280 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
4. 78,534.783 583,604.642 ↓ 2.4 1,656,280 1

Nested Loop (cost=623,738.69..2,353,218.96 rows=683,759 width=36) (actual time=5,860.413..583,604.642 rows=1,656,280 loops=1)

5. 499,289.100 505,069.758 ↓ 22.1 773,915 1

Parallel Bitmap Heap Scan on applnextstg apng (cost=623,738.12..775,749.58 rows=34,972 width=25) (actual time=5,860.349..505,069.758 rows=773,915 loops=1)

  • 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[]
  • Heap Blocks: exact=248497
6. 27.277 5,780.658 ↓ 0.0 0 1

BitmapAnd (cost=623,738.12..623,738.12 rows=83,934 width=0) (actual time=5,780.657..5,780.658 rows=0 loops=1)

7. 1,373.032 1,373.032 ↓ 1.1 3,579,511 1

Bitmap Index Scan on indx_applnextstg_ans_st_cd (cost=0.00..181,402.67 rows=3,277,657 width=0) (actual time=1,373.032..1,373.032 rows=3,579,511 loops=1)

  • Index Cond: ((ans_st_cd)::text = ANY ('{GJ,HR,MH,JH}'::text[]))
8. 2,225.727 2,225.727 ↓ 1.1 3,640,334 1

Bitmap Index Scan on idx_applnextstg_ans_trcd (cost=0.00..216,650.31 rows=3,248,959 width=0) (actual time=2,225.727..2,225.727 rows=3,640,334 loops=1)

  • Index Cond: (ans_trcd = ANY ('{509,501}'::numeric[]))
9. 2,154.622 2,154.622 ↓ 1.2 4,726,247 1

Bitmap Index Scan on idx_applnextstg_ans_accd (cost=0.00..225,621.69 rows=4,045,949 width=0) (actual time=2,154.622..2,154.622 rows=4,726,247 loops=1)

  • Index Cond: (ans_accd = ANY ('{105,101,115,103,102,134,132,123,135}'::numeric[]))
10. 0.101 0.101 ↑ 14.5 2 773,915

Index Scan using pk_wflows on wflows f (cost=0.57..44.82 rows=29 width=15) (actual time=0.050..0.101 rows=2 loops=773,915)

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