explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hvuo

Settings
# exclusive inclusive rows x rows loops node
1. 354.778 19,104.933 ↑ 88.8 1,086 1

Unique (cost=6,569,264.32..6,570,250.21 rows=96,400 width=41) (actual time=18,588.304..19,104.933 rows=1,086 loops=1)

2. 1,239.527 18,750.155 ↓ 41.6 4,103,287 1

Sort (cost=6,569,264.32..6,569,510.79 rows=98,589 width=41) (actual time=18,588.302..18,750.155 rows=4,103,287 loops=1)

  • Sort Key: t2.model_name, t2.model_ver_build_number, t2.deployed_date
  • Sort Method: quicksort Memory: 484379kB
3. 338.969 17,510.628 ↓ 41.6 4,103,287 1

Subquery Scan on t2 (cost=5,821,672.18..6,561,086.79 rows=98,589 width=41) (actual time=13,924.389..17,510.628 rows=4,103,287 loops=1)

  • Filter: (t2.rank = 1)
  • Rows Removed by Filter: 77409
4. 2,298.124 17,171.659 ↑ 4.7 4,180,696 1

WindowAgg (cost=5,821,672.18..6,314,615.25 rows=19,717,723 width=49) (actual time=13,924.386..17,171.659 rows=4,180,696 loops=1)

5. 10,983.066 14,873.535 ↑ 4.7 4,180,696 1

Sort (cost=5,821,672.18..5,870,966.48 rows=19,717,723 width=41) (actual time=13,922.071..14,873.535 rows=4,180,696 loops=1)

  • Sort Key: scm_ild_prod_bld_1.model_name, scm_ild_prod_bld_1.model_ver_build_number, (GREATEST(scm_ild_prod_bld_1.repoversion_date_time, scm_ild_prod_bld_1.model_version_date_time)) DESC
  • Sort Method: quicksort Memory: 491039kB
6. 3,238.438 3,890.469 ↑ 4.7 4,180,696 1

Bitmap Heap Scan on scm_ild_prod_bld_1 (cost=325,398.52..3,432,575.29 rows=19,717,723 width=41) (actual time=787.260..3,890.469 rows=4,180,696 loops=1)

  • Recheck Cond: (GREATEST(repoversion_date_time, model_version_date_time) > (CURRENT_DATE - '10 days'::interval day))
  • Heap Blocks: exact=587867
7. 652.031 652.031 ↑ 4.7 4,180,699 1

Bitmap Index Scan on sipb1_g_idx (cost=0.00..320,469.09 rows=19,717,723 width=0) (actual time=652.031..652.031 rows=4,180,699 loops=1)

  • Index Cond: (GREATEST(repoversion_date_time, model_version_date_time) > (CURRENT_DATE - '10 days'::interval day))
Planning time : 0.131 ms
Execution time : 19,178.385 ms