explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5zSb : fatmap_pistes

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

Nested Loop (cost=51,890.39..51,898.49 rows=1 width=55) (actual time=361.866..361.866 rows=0 loops=1)

2. 0.002 361.865 ↓ 0.0 0 1

Nested Loop (cost=51,890.24..51,898.30 rows=1 width=319) (actual time=361.865..361.865 rows=0 loops=1)

3. 361.863 361.863 ↓ 0.0 0 1

CTE Scan on zoom_line z (cost=51,889.95..51,889.97 rows=1 width=40) (actual time=361.863..361.863 rows=0 loops=1)

  • Filter: (rank = 1)
4.          

CTE zoom_line

5. 0.002 361.861 ↓ 0.0 0 1

WindowAgg (cost=51,889.93..51,889.95 rows=1 width=49,995) (actual time=361.861..361.861 rows=0 loops=1)

6. 0.011 361.859 ↓ 0.0 0 1

Sort (cost=51,889.93..51,889.93 rows=1 width=49,987) (actual time=361.859..361.859 rows=0 loops=1)

  • Sort Key: zoom_level_lines.id, zoom_level_lines.zoom_level DESC
  • Sort Method: quicksort Memory: 25kB
7. 361.848 361.848 ↓ 0.0 0 1

Seq Scan on zoom_level_lines (cost=0.00..51,889.92 rows=1 width=49,987) (actual time=361.848..361.848 rows=0 loops=1)

  • Filter: ((zoom_level <= 19) AND (geometry && '0103000020110F00000100000005000000E8C038A44BDD5541B460334FBE455041E8C038A44BDD554130A62B6BD1455041640631C05EDD554130A62B6BD1455041640631C05EDD5541B460334FBE455041E8C038A44BDD5541B460334FBE455041'::geometry) AND (line_type = 'Adventure'::zoom_level_line_type))
  • Rows Removed by Filter: 315020
8. 0.000 0.000 ↓ 0.0 0

Index Scan using adventures_pkey on adventures lyr (cost=0.29..8.30 rows=1 width=287) (never executed)

  • Index Cond: (id = z.id)
  • Filter: visible
9. 0.000 0.000 ↓ 0.0 0

Index Scan using adventure_types_pkey on adventure_types activity (cost=0.15..0.17 rows=1 width=4) (never executed)

  • Index Cond: (id = lyr.adventure_type_id)
  • Filter: (name = ANY ('{PISTE,RESORT_SKI_TOURING}'::text[]))