explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FuJy

Settings
# exclusive inclusive rows x rows loops node
1. 21,954.232 21,954.232 ↓ 204.3 1,226 1

Index Scan using xray on delta (cost=0.550..8.370 rows=6 width=349) (actual time=54.000..21,954.232 rows=1,226 loops=1)

  • Index Cond: (((november)::text ~~* 'whiskey'::text) AND ((november)::text ~~* 'alpha'::text))
  • Rows Removed by Index Recheck: 1
  • Buffers: shared hit=633283 read=117252