explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CX51

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

Limit (cost=0.00..28.89 rows=1 width=501) (actual time=0.144..0.144 rows=0 loops=1)

2. 0.143 0.143 ↓ 0.0 0 1

Seq Scan on flow_cache_areas (cost=0.00..28.89 rows=1 width=501) (actual time=0.143..0.143 rows=0 loops=1)

  • Filter: (active AND (outline ~ '0101000000894160E5D02201408B6CE7FBA9B14440'::geometry) AND (cached_at >= (now() - '00:03:00'::interval)) AND _st_contains(outline, '0101000000894160E5D02201408B6CE7FBA9B14440'::geometry))
  • Rows Removed by Filter: 7
Planning time : 185.084 ms
Execution time : 0.394 ms