explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1vrb

Settings
# exclusive inclusive rows x rows loops node
1. 8,941.698 19,621.228 ↑ 1.0 11,078,297 1

Sort (cost=2,681,416.65..2,709,112.45 rows=11,078,320 width=56) (actual time=17,263.645..19,621.228 rows=11,078,297 loops=1)

  • Sort Key: block_code, x_min, x_max, y_min, y_max
  • Sort Method: external merge Disk: 801992kB
2. 4,008.593 10,679.530 ↑ 1.0 11,078,297 1

GroupAggregate (cost=0.56..1,006,530.26 rows=11,078,320 width=56) (actual time=0.020..10,679.530 rows=11,078,297 loops=1)

  • Group Key: block_code
3. 6,670.937 6,670.937 ↑ 1.0 11,078,297 1

Index Scan using block_dwh_pkey on block_dwh (cost=0.56..840,355.46 rows=11,078,320 width=48) (actual time=0.012..6,670.937 rows=11,078,297 loops=1)

Planning time : 0.099 ms
Execution time : 20,353.375 ms