explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yAmE : Optimization for: tt1; plan #tukU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2,546.241 24,393.177 ↓ 16.7 9,263 1

Subquery Scan on q (cost=17,269.92..21,427.92 rows=554 width=106) (actual time=13,310.871..24,393.177 rows=9,263 loops=1)

  • Filter: (q.rownum = 1)
  • Rows Removed by Filter: 250074
2. 5,650.938 21,846.936 ↓ 2.3 259,337 1

WindowAgg (cost=17,269.92..20,041.92 rows=110,880 width=114) (actual time=13,310.849..21,846.936 rows=259,337 loops=1)

3. 10,156.204 16,195.998 ↓ 2.3 259,337 1

Sort (cost=17,269.92..17,547.12 rows=110,880 width=106) (actual time=13,310.796..16,195.998 rows=259,337 loops=1)

  • Sort Key: current."ServiceStationName", current."Address", current."FuelCode", current."PriceUpdatedDate" DESC
  • Sort Method: external merge Disk: 31072kB
4. 6,039.794 6,039.794 ↓ 2.3 259,337 1

Index Scan using idx_d2 on current (cost=0.42..4,204.88 rows=110,880 width=106) (actual time=0.472..6,039.794 rows=259,337 loops=1)

  • Index Cond: ("PriceUpdatedDate" < $1)