Page Comparison

Update on option 2 (Apr 10th, 2023):

• Gin indexes are already present in the table creation script
• Queries that are generated by PostgresClient do not hit the indexes. The library auto-generated SQL Query example is:

SELECT id, jsonb
    FROM %schema%_mod_audit.circulation_logs 
where ((circulation_logs.jsonb->>'items') @@ ('BATTLE10')) LIMIT 100 OFFSET 0;

•  To enable the index in the search the query should be rewritten in this form:

select id, jsonb 
	from %schema%_mod_audit.circulation_logs 
where %schema%_mod_audit.get_tsvector(%schema%_mod_audit.f_unaccent(jsonb ->> 'items'::text))@@ plainto_tsquery('%BATTLE10%') LIMIT 100 OFFSET 0;

• Below are screenshots of query execution plan for both queries:
• Image ModifiedImage Modified