explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZGJb

Settings
# exclusive inclusive rows x rows loops node
1. 1,203.966 6,898.791 ↓ 1.1 1,134,901 1

GroupAggregate (cost=0.44..442,897.25 rows=1,074,208 width=12) (actual time=0.096..6,898.791 rows=1,134,901 loops=1)

  • Group Key: roadworkrequestid
2. 5,694.825 5,694.825 ↑ 1.0 11,199,560 1

Index Scan using ix_roadworkrequesthistory_roadworkrequestid on roadworkrequesthistory (cost=0.44..376,157.37 rows=11,199,560 width=12) (actual time=0.051..5,694.825 rows=11,199,560 loops=1)

Planning time : 2.029 ms