explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zred

Settings
# exclusive inclusive rows x rows loops node
1. 352.271 38,686.979 ↑ 79.4 1,086 1

Unique (cost=6,558,600.89..6,559,483.03 rows=86,255 width=41) (actual time=38,186.136..38,686.979 rows=1,086 loops=1)

2. 1,236.599 38,334.708 ↓ 46.3 4,086,303 1

Sort (cost=6,558,600.89..6,558,821.43 rows=88,214 width=41) (actual time=38,186.135..38,334.708 rows=4,086,303 loops=1)

  • Sort Key: t2.model_name, t2.model_ver_build_number, t2.deployed_date
  • Sort Method: quicksort Memory: 482765kB
3. 337.809 37,098.109 ↓ 46.3 4,086,303 1

Subquery Scan on t2 (cost=5,889,748.29..6,551,354.68 rows=88,214 width=41) (actual time=33,809.346..37,098.109 rows=4,086,303 loops=1)

  • Filter: (t2.rank = 1)
  • Rows Removed by Filter: 77409
4. 2,204.202 36,760.300 ↑ 4.2 4,163,712 1

WindowAgg (cost=5,889,748.29..6,330,819.22 rows=17,642,837 width=49) (actual time=33,809.340..36,760.300 rows=4,163,712 loops=1)

5. 9,267.304 34,556.098 ↑ 4.2 4,163,712 1

Sort (cost=5,889,748.29..5,933,855.38 rows=17,642,837 width=41) (actual time=33,807.676..34,556.098 rows=4,163,712 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: 489425kB
6. 25,288.794 25,288.794 ↑ 4.2 4,163,712 1

Seq Scan on scm_ild_prod_bld_1 (cost=0.00..3,766,205.33 rows=17,642,837 width=41) (actual time=0.011..25,288.794 rows=4,163,712 loops=1)

  • Filter: (GREATEST(repoversion_date_time, model_version_date_time) > (CURRENT_DATE - '10 days'::interval day))
  • Rows Removed by Filter: 54965948
Planning time : 0.419 ms
Execution time : 38,762.070 ms