explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CP44

Settings
# exclusive inclusive rows x rows loops node
1. 49.666 52.121 ↓ 0.0 0 1

Subquery Scan on f (cost=8.47..23.96 rows=1 width=111) (actual time=52.120..52.121 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.114 2.455 ↓ 4.0 4 1

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

3. 0.026 2.341 ↓ 4.0 4 1

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

  • Sort Key: f_1.id
  • Sort Method: quicksort Memory: 25kB
4. 2.315 2.315 ↓ 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.962..2.315 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.597 ms
Execution time : 52.218 ms