explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1l4C : fatmap_maps_point

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 49.768 ↓ 0.0 0 1

Subquery Scan on _q (cost=9,111.21..9,120.44 rows=1 width=83) (actual time=49.768..49.768 rows=0 loops=1)

2. 0.006 49.767 ↓ 0.0 0 1

Hash Join (cost=9,111.21..9,120.43 rows=1 width=83) (actual time=49.767..49.767 rows=0 loops=1)

  • Hash Cond: (region_adventure_types.region_id = regions.id)
3.          

CTE region_adventure_types

4. 0.138 49.482 ↑ 388.0 1 1

GroupAggregate (cost=8,490.38..9,015.92 rows=388 width=36) (actual time=49.482..49.482 rows=1 loops=1)

  • Group Key: regions_1.id
5. 0.070 49.344 ↑ 147.1 157 1

Merge Join (cost=8,490.38..8,895.60 rows=23,093 width=10) (actual time=49.232..49.344 rows=157 loops=1)

  • Merge Cond: (regions_1.id = adventures_regions.region_id)
6. 0.019 0.019 ↑ 194.0 2 1

Index Only Scan using regions_pkey on regions regions_1 (cost=0.27..85.44 rows=388 width=4) (actual time=0.018..0.019 rows=2 loops=1)

  • Heap Fetches: 0
7. 8.551 49.255 ↑ 147.1 157 1

Sort (cost=8,490.10..8,547.84 rows=23,093 width=10) (actual time=49.209..49.255 rows=157 loops=1)

  • Sort Key: adventures_regions.region_id
  • Sort Method: quicksort Memory: 1768kB
8. 14.502 40.704 ↑ 1.1 21,313 1

Hash Join (cost=6,114.54..6,816.42 rows=23,093 width=10) (actual time=19.874..40.704 rows=21,313 loops=1)

  • Hash Cond: (adventures_regions.adventure_id = a.id)
9. 6.582 6.582 ↑ 1.0 25,772 1

Seq Scan on adventures_regions (cost=0.00..373.87 rows=25,887 width=8) (actual time=0.018..6.582 rows=25,772 loops=1)

10. 6.740 19.620 ↑ 1.0 18,510 1

Hash (cost=5,883.13..5,883.13 rows=18,513 width=10) (actual time=19.620..19.620 rows=18,510 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1065kB
11. 12.880 12.880 ↑ 1.0 18,510 1

Seq Scan on published_adventures a (cost=0.00..5,883.13 rows=18,513 width=10) (actual time=0.006..12.880 rows=18,510 loops=1)

12. 49.484 49.484 ↑ 388.0 1 1

CTE Scan on region_adventure_types (cost=0.00..7.76 rows=388 width=36) (actual time=49.484..49.484 rows=1 loops=1)

13. 0.000 0.277 ↓ 0.0 0 1

Hash (cost=95.28..95.28 rows=1 width=51) (actual time=0.277..0.277 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
14. 0.004 0.277 ↓ 0.0 0 1

Hash Join (cost=37.49..95.28 rows=1 width=51) (actual time=0.277..0.277 rows=0 loops=1)

  • Hash Cond: (regions.geo_polygon_id = geo_polygons.id)
15. 0.003 0.003 ↑ 241.0 1 1

Seq Scan on regions (cost=0.00..56.88 rows=241 width=23) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: visible
16. 0.001 0.270 ↓ 0.0 0 1

Hash (cost=37.48..37.48 rows=1 width=36) (actual time=0.270..0.270 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
17. 0.269 0.269 ↓ 0.0 0 1

Seq Scan on geo_polygons (cost=0.00..37.48 rows=1 width=36) (actual time=0.269..0.269 rows=0 loops=1)

  • Filter: (centroid_3857 && '0103000020110F00000100000005000000E8C038A44BDD5541B460334FBE455041E8C038A44BDD554130A62B6BD1455041640631C05EDD554130A62B6BD1455041640631C05EDD5541B460334FBE455041E8C038A44BDD5541B460334FBE455041'::geometry)