explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dI37 : Slow SDE ST_Intersects Query on Postgres9.2 table with GIST index on shape with enable_seqscan=false

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on victor quebec (cost=24,764.850..60,721.270 rows=329,794 width=4) (actual rows= loops=)

  • Recheck Cond: (kilo ^! 'five'::seven)
2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mike (cost=0.000..24,682.400 rows=329,794 width=0) (actual rows= loops=)

  • Index Cond: (kilo ^! 'five'::seven)