explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Ppr

Settings
# exclusive inclusive rows x rows loops node
1. 49.571 51.231 ↓ 0.0 0 1

Subquery Scan on f (cost=8.47..23.96 rows=1 width=111) (actual time=51.231..51.231 rows=0 loops=1)

  • Filter: (((NOT f.re) OR (NOT f.ad)) AND (f.geometry_index && '0101000020E6100000FE7854A1268F104075D88EF3484D4940'::geometry) AND (f.feature_type = ANY ('{1668,4435,1931,3280,2803,1929,11444,10350,1669,3697}'::integer[])) AND _st_intersects(f.geometry_index, '0101000020E6100000FE7854A1268F104075D88EF3484D4940'::geometry) AND (SubPlan 1))
  • Rows Removed by Filter: 4
2. 0.100 1.660 ↓ 4.0 4 1

WindowAgg (cost=8.47..8.55 rows=1 width=11,545) (actual time=1.601..1.660 rows=4 loops=1)

3. 0.015 1.560 ↓ 4.0 4 1

Sort (cost=8.47..8.47 rows=1 width=11,511) (actual time=1.558..1.560 rows=4 loops=1)

  • Sort Key: f_1.id
  • Sort Method: quicksort Memory: 25kB
4. 1.545 1.545 ↓ 4.0 4 1

Index Scan using idxs_feature_geometry on feature f_1 (cost=0.42..8.46 rows=1 width=11,511) (actual time=0.697..1.545 rows=4 loops=1)

  • Index Cond: (geometry_index && '0101000020E6100000FE7854A1268F104075D88EF3484D4940'::geometry)
  • Filter: ((version > '421022838'::bigint) AND (version <= '423208098'::bigint) AND (branch = '233b38a4-f0bf-4289-bfdc-7f2a04fc4ab3'::uuid) AND (feature_type = ANY ('{1668,4435,1931,3280,2803,1929,11444,10350,1669,3697}'::integer[])))
  • Rows Removed by Filter: 615
5.          

SubPlan (for Subquery Scan)

6. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.57..12.63 rows=1 width=24) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Only Scan Backward using feature_pkey on feature f1 (cost=0.57..12.63 rows=1 width=24) (never executed)

  • Index Cond: ((id = f.id) AND (branch = '233b38a4-f0bf-4289-bfdc-7f2a04fc4ab3'::uuid))
  • Filter: (((version + 0) > '421022838'::bigint) AND ((version + 0) <= '423208098'::bigint))
  • Heap Fetches: 0
Planning time : 1.576 ms
Execution time : 51.295 ms