Check if Trigram Indices are taken on searchfilter

[RudiThoeni]

Check if the queries are using the trigram indices

searching simple

explain analyze SELECT data FROM "smgpois" WHERE 
(data#>>'{Detail,de,Title}' LIKE '%rudi%')
LIMIT 10

with access role

explain analyze SELECT data FROM "smgpois" WHERE 
(data#>>'{Detail,de,Title}' LIKE '%rudi%')
AND 
(gen_access_role @> array['IDM']) 
LIMIT 10

searching trough each language

explain analyze SELECT data FROM "smgpois" WHERE 
(data#>>'{Detail,de,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,it,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,en,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,nl,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,cs,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,pl,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,fr,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,pl,Title}' ILIKE '%rudi%')
AND 
(gen_access_role @> array['IDM']) 
ORDER BY gen_shortname ASC LIMIT 10

with additional ID search

explain analyze SELECT data FROM "smgpois" WHERE 
(data#>>'{Detail,de,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,it,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,en,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,nl,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,cs,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,pl,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,fr,Title}' ILIKE '%rudi%' OR 
data#>>'{Detail,pl,Title}' ILIKE '%rudi%' OR 
data#>>'{Id}' ILIKE '%rudi%') AND 
(gen_access_role @> array['IDM']) ORDER BY 
gen_shortname ASC LIMIT 10