explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aUlz

Settings
# exclusive inclusive rows x rows loops node
1. 621.990 3,990.042 ↑ 1.0 1 1

Aggregate (cost=937,183.93..937,183.94 rows=1 width=32) (actual time=3,990.042..3,990.042 rows=1 loops=1)

2. 17.268 3,368.052 ↓ 2,214.3 6,643 1

Nested Loop (cost=0.29..937,173.92 rows=3 width=2,542) (actual time=0.881..3,368.052 rows=6,643 loops=1)

3. 34.296 34.296 ↓ 1.0 29,092 1

Seq Scan on field f (cost=0.00..2,429.47 rows=28,978 width=24) (actual time=0.018..34.296 rows=29,092 loops=1)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 15055
4. 3,316.488 3,316.488 ↓ 0.0 0 29,092

Index Scan using geo_data_pkey on geo_data g (cost=0.29..32.26 rows=1 width=2,534) (actual time=0.114..0.114 rows=0 loops=29,092)

  • Index Cond: ((id = f.geo_data_id) AND (id IS NOT NULL))
  • Filter: ((geometry IS NOT NULL) AND (st_asmvtgeom(st_transform(geometry, 3857), 'BOX(-10644926.305625 5009377.085,-10018754.17 5635549.220625)'::box2d, 4096, 0, false) IS NOT NULL) AND st_intersects('0103000020110F0000010000000500000014AEC7C9B74D64C152B81E4E777F554114AEC7C9B74D64C1D7A37045F81B5341D7A37045F81B63C1D7A37045F81B5341D7A37045F81B63C152B81E4E777F554114AEC7C9B74D64C152B81E4E777F5541'::geometry, st_transform(geometry, 3857)))
  • Rows Removed by Filter: 1
Planning time : 0.320 ms
Execution time : 3,990.295 ms