explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xIVu

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 56,930.426 ↑ 1.0 1 1

Limit (cost=1,227,079.86..1,227,080.19 rows=1 width=109) (actual time=56,930.426..56,930.426 rows=1 loops=1)

2. 0.046 56,930.425 ↑ 151,460.0 1 1

GroupAggregate (cost=1,227,079.86..1,276,594.24 rows=151,460 width=109) (actual time=56,930.425..56,930.425 rows=1 loops=1)

  • Group Key: narh.key_num, narh.yr, narh.poli, narh.nav_cmsnarrh_zid, narh.addemp, narh.supseq, narh.supnam, narh.z_date_added
3. 48,749.727 56,930.379 ↑ 65,684.3 29 1

Sort (cost=1,227,079.86..1,231,841.98 rows=1,904,845 width=109) (actual time=56,930.374..56,930.379 rows=29 loops=1)

  • Sort Key: narh.key_num, narh.yr, narh.poli, narh.nav_cmsnarrh_zid, narh.addemp, narh.supseq, narh.supnam, narh.z_date_added
  • Sort Method: external sort Disk: 666,944kB
4. 2,841.536 8,180.652 ↓ 2.8 5,339,255 1

Merge Join (cost=0.98..807,024.70 rows=1,904,845 width=109) (actual time=11.014..8,180.652 rows=5,339,255 loops=1)

  • Merge Cond: ((narh.key_num = nard.key_num) AND (narh.yr = nard.yr) AND (narh.poli = nard.poli) AND (narh.supseq = nard.supseq))
5. 3,047.727 3,047.727 ↓ 1.0 151,671 1

Index Scan using nav_cmsnarrh_key_num_yr_poli_narcod_supseq on nav_cmsnarrh narh (cost=0.42..48,305.76 rows=151,460 width=61) (actual time=10.935..3,047.727 rows=151,671 loops=1)

  • Index Cond: (narcod = '1'::numeric)
  • Filter: (pword IS NULL)
  • Rows Removed by Filter: 3
6. 2,291.389 2,291.389 ↓ 1.0 5,339,382 1

Index Scan using nav_cmsnarrd_key_num_yr_poli_narcod_supseq on nav_cmsnarrd nard (cost=0.56..685,071.86 rows=5,308,403 width=76) (actual time=0.074..2,291.389 rows=5,339,382 loops=1)

  • Index Cond: (narcod = '1'::numeric)
Planning time : 1.221 ms
Execution time : 57,031.198 ms