explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sd9s

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 806.278 ↑ 1.0 1 1

Result (cost=469.26..469.27 rows=1 width=32) (actual time=806.278..806.278 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.036 806.274 ↑ 1.0 1 1

Aggregate (cost=469.25..469.26 rows=1 width=32) (actual time=806.274..806.274 rows=1 loops=1)

4. 343.090 806.238 ↑ 9.1 22 1

HashAggregate (cost=434.75..466.25 rows=200 width=60) (actual time=806.221..806.238 rows=22 loops=1)

  • Group Key: round((st_x(yellow_1m.the_geom_webmercator) / _cdb_params.res)), round((st_y(yellow_1m.the_geom_webmercator) / _cdb_params.res))
  • Filter: (st_setsrid(st_makepoint(avg(st_x(yellow_1m.the_geom_webmercator)), avg(st_y(yellow_1m.the_geom_webmercator))), 3857) && '0103000020110F00000100000005000000A48CC13D142F73C193107C45F81BF3C0A48CC13D142F73C1A48CC13D142F734193107C45F81BF340A48CC13D142F734193107
5.          

CTE _cdb_res

6. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=1)

7.          

CTE _cdb_params

8. 0.023 0.023 ↑ 1.0 1 1

CTE Scan on _cdb_res (cost=0.00..0.21 rows=1 width=88) (actual time=0.023..0.023 rows=1 loops=1)

9. 259.554 463.148 ↓ 985.8 985,785 1

Nested Loop (cost=5.06..404.53 rows=1,000 width=52) (actual time=98.544..463.148 rows=985,785 loops=1)

10. 0.003 0.032 ↑ 1.0 1 1

Nested Loop (cost=0.00..0.05 rows=1 width=40) (actual time=0.029..0.032 rows=1 loops=1)

11. 0.026 0.026 ↑ 1.0 1 1

CTE Scan on _cdb_params (cost=0.00..0.02 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=1)

12. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on _cdb_params _cdb_params_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.003 rows=1 loops=1)

13. 109.521 203.562 ↓ 9,857.9 985,785 1

Bitmap Heap Scan on yellow_1m (cost=5.06..388.48 rows=100 width=36) (actual time=98.503..203.562 rows=985,785 loops=1)

  • Recheck Cond: (the_geom_webmercator && _cdb_params_1.tr_bbox)
  • Heap Blocks: exact=28177
14. 94.041 94.041 ↓ 9,857.9 985,785 1

Bitmap Index Scan on yellow_1m_the_geom_webmercator_idx (cost=0.00..5.04 rows=100 width=0) (actual time=94.041..94.041 rows=985,785 loops=1)

  • Index Cond: (the_geom_webmercator && _cdb_params_1.tr_bbox