SQLize Online / PHPize Online  /  SQLtest Online

CREATE EXTENSION IF NOT EXISTS pg_trgm; CREATE TABLE queries ( query TEXT ); CREATE INDEX trgm_idx ON queries using gist(query gist_trgm_ops); INSERT INTO queries VALUES('SELECT search_bpa.aggcounter(to_jsonb(row)) FROM ( SELECT di.baseid AS bpa, di.attrs->''regions'' AS region, di.doctype AS type, di.docstate AS state, di.attrs->''organs'' AS organ FROM search_bpa.document_resinfo di WHERE ((extract(year FROM di.odate) BETWEEN 1992 AND 2022)) AND ((di.attrs @> ''{"regions": ["Белгородская область"]}'')) AND (di.baseid IN (''r013100'', ''cd00000'')) AND NOT EXISTS ( SELECT * FROM search_bpa.document_property dp WHERE dp.docid = di.docid AND (dp.hidden = ''t'') AND (dp.baseid IS NULL OR dp.baseid IN (''r013130'', ''cd00000'')) ) ) AS row'); INSERT INTO queries VALUES('SELECT search_bpa.aggcounter(to_jsonb(row)) FROM ( SELECT di.baseid AS bpa, di.attrs->''regions'' AS region, di.doctype AS type, di.docstate AS state, di.attrs->''organs'' AS organ FROM search_bpa.document_resinfo di WHERE ((extract(year FROM di.odate) BETWEEN 1992 AND 2022)) AND ((di.attrs @> ''{"regions": ["Белгородская область"]}'')) AND (di.baseid IN (''r013100'', ''cd00000'')) AND NOT EXISTS ( SELECT * FROM search_bpa.document_property dp WHERE dp.docid = di.docid AND (dp.hidden = ''t'') AND (dp.baseid IS NULL OR dp.baseid IN (''r013100'', ''cd00000'')) ) ) AS row'); INSERT INTO queries VALUES('SELECT search_bpa.aggcounter(to_jsonb(row)) FROM ( SELECT di.baseid AS bpa, di.attrs->''regions'' AS region, di.doctype AS type, di.docstate AS state, di.attrs->''organs'' AS organ FROM search_bpa.document_resinfo di WHERE ((extract(year FROM di.odate) BETWEEN 1992 AND 2022)) AND ((di.attrs @> ''{"regions": ["Белгородская область"]}'')) AND (di.baseid IN (''r013100'', ''cd00000'')) AND NOT EXISTS ( SELECT * FROM search_bpa.document_property dp WHERE dp.docid = di.docid AND (dp.hidden = ''t'') AND (dp.baseid IS NULL OR dp.baseid IN (''r013120'', ''cd00000'')) ) ) AS row'); INSERT INTO queries VALUES('SELECT search_bpa.aggcounter(to_jsonb(row)) FROM ( SELECT di) AND (dp.baseid IS NULL OR dp.baseid IN (''r013100'', ''cd00000'')) ) ) AS row'); INSERT INTO queries VALUES('SELECT search_bpa.aggcounter(to_jsonb(row)) FROM ( SELECT di) AND (dp.baseid IN (''r013100'', ''cd00000'')) ) ) AS row'); SELECT query <-> 'SELECT search_bpa.aggcounter(to_jsonb(row)) FROM ( SELECT di.baseid AS bpa, di.attrs->''regions'' AS region, di.doctype AS type, di.docstate AS state, di.attrs->''organs'' AS organ FROM search_bpa.document_resinfo di WHERE ((extract(year FROM di.odate) BETWEEN 1992 AND 2022)) AND ((di.attrs @> ''{"regions": ["Белгородская область"]}'')) AND (di.baseid IN (''r013100'', ''cd00000'')) AND NOT EXISTS ( SELECT * FROM search_bpa.document_property dp WHERE dp.docid = di.docid AND (dp.hidden = ''t'') AND (dp.baseid IS NULL OR dp.baseid IN (''r013130'', ''cd00000'')) ) ) AS row' AS dist FROM queries;