explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qsWE

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 4.262 ↑ 1.0 5 1

Limit (cost=0.42..442.31 rows=5 width=36) (actual time=0.818..4.262 rows=5 loops=1)

2. 2.165 4.257 ↑ 194.0 5 1

GroupAggregate (cost=0.42..85,725.15 rows=970 width=36) (actual time=0.817..4.257 rows=5 loops=1)

  • Group Key: datekey
3. 2.092 2.092 ↑ 199.7 5,180 1

Index Scan Backward using date_pnl on pnl (cost=0.42..80,540.52 rows=1,034,500 width=10) (actual time=0.019..2.092 rows=5,180 loops=1)

Planning time : 0.110 ms