explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AP30

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 791.184 ↑ 76.0 1 1

Subquery Scan on __cdb_aggregation_src (cost=307.47..312.22 rows=76 width=44) (actual time=791.183..791.184 rows=1 loops=1)

2. 100.345 791.182 ↑ 76.0 1 1

GroupAggregate (cost=307.47..311.46 rows=76 width=60) (actual time=791.182..791.182 rows=1 loops=1)

  • Group Key: (floor((((st_x(benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293.the_geom_webmercator)) - __cdb_src_params_1.cdb_xmin) / __cdb_src_params_1.res))), (floor((((st_y(benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293.the_geom_webmercator)
3.          

CTE __cdb_src_params

4. 0.038 0.038 ↑ 1.0 1 1

Result (cost=0.00..0.28 rows=1 width=64) (actual time=0.037..0.038 rows=1 loops=1)

5. 166.692 690.837 ↓ 8,997.2 683,788 1

Sort (cost=307.19..307.38 rows=76 width=36) (actual time=663.735..690.837 rows=683,788 loops=1)

  • Sort Key: (floor((((st_x(benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293.the_geom_webmercator)) - __cdb_src_params_1.cdb_xmin) / __cdb_src_params_1.res))), (floor((((st_y(benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293.the_geom_webmerc
  • Sort Method: quicksort Memory: 77997kB
6. 142.288 524.145 ↓ 8,997.2 683,788 1

Nested Loop (cost=4.81..304.82 rows=76 width=36) (actual time=86.779..524.145 rows=683,788 loops=1)

  • Join Filter: ((floor((((st_x(benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293.the_geom_webmercator)) - __cdb_src_params_1.cdb_xmin) / __cdb_src_params_1.res)) < (__cdb_src_params.cdb_limit_x)::double precision) AND (floor((((st_y(benchmark_7773a7
7. 0.005 0.050 ↑ 1.0 1 1

Nested Loop (cost=0.00..0.05 rows=1 width=32) (actual time=0.048..0.050 rows=1 loops=1)

8. 0.043 0.043 ↑ 1.0 1 1

CTE Scan on __cdb_src_params __cdb_src_params_1 (cost=0.00..0.02 rows=1 width=24) (actual time=0.043..0.043 rows=1 loops=1)

9. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on __cdb_src_params (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=1)

10. 185.553 381.807 ↓ 999.7 683,788 1

Nested Loop (cost=4.81..272.85 rows=684 width=52) (actual time=86.726..381.807 rows=683,788 loops=1)

11. 0.003 0.003 ↑ 1.0 1 1

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

12. 115.385 196.251 ↓ 10,055.7 683,788 1

Bitmap Heap Scan on benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293 (cost=4.81..268.73 rows=68 width=36) (actual time=86.713..196.251 rows=683,788 loops=1)

  • Recheck Cond: (the_geom_webmercator && __cdb_src_params_2.cdb_point_bbox)
  • Heap Blocks: exact=35464
13. 80.866 80.866 ↓ 10,055.7 683,788 1

Bitmap Index Scan on table_2015streettreescensus_trees_6_the_geom_webmercator_idx_sp (cost=0.00..4.79 rows=68 width=0) (actual time=80.866..80.866 rows=683,788 loops=1)

  • Index Cond: (the_geom_webmercator && __cdb_src_params_2.cdb_point_bbox)
Planning time : 2.195 ms
Execution time : 799.560 ms