explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CZD

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

Index Scan using i_hopmoti on hopmoti (cost=0.28..8.30 rows=1 width=357) (actual rows= loops=)

  • Index Cond: ((motif)::text = '.....CONG'::text)
  • Filter: ("substring"((motif)::text, 1, 5) = ANY ('{.....,04...,04133}'::text[]))