explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pGMb : test

Settings
# exclusive inclusive rows x rows loops node
1. 533.610 845.396 ↑ 1.0 1,000,000 1

GroupAggregate (cost=0.42..49,317.43 rows=1,000,000 width=12) (actual time=0.079..845.396 rows=1,000,000 loops=1)

  • Group Key: c1
2. 311.786 311.786 ↑ 1.0 1,000,000 1

Index Only Scan using foo_c1_idx on foo (cost=0.42..34,317.43 rows=1,000,000 width=4) (actual time=0.066..311.786 rows=1,000,000 loops=1)

  • Heap Fetches: 1,000,000
Planning time : 0.597 ms
Execution time : 917.178 ms