pgFouine: PostgreSQL log analysis report

Normalized reports are marked with a "(N)".

Generated on 2009-07-31 17:21
Parsed C:\BRX_TAFF\_racine\pgfouine\upload\postgresql_2009_07_31_160529.log (182,306 lines) in 54s
Log from 2009-07-31 16:05:30 to 2009-07-31 17:17:17

Overall statistics ^

Number of unique normalized queries: 149
Number of queries: 25,673
Total query duration: 4m55s
First query: 2009-07-31 16:05:30
Last query: 2009-07-31 17:17:17
Query peak: 718 queries/s at 2009-07-31 16:06:29

Queries by type ^

Type	Count	Percentage
SELECT	23,343	90.9
INSERT	600	2.3
UPDATE	115	0.4
DELETE	13	0.1

Queries that took up the most time (N) ^

Rank

Total duration

Times executed

Av. duration (s)

Query

2m43s

40.92

SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN (...) AND (NX_CONTAINS("fulltext"."fulltext", '')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> '') AND NX_ACCESS_ALLOWED("_nxhier"."id", '', '');

86.39s | SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Thread', 'Note', 'AdvancedSearch', 'Document', 'search_results', 'Picture', 'QueryNav', 'File', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Major & dolicho')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> '63d023ee-706c-41f8-9513-5c03a1cdb7f6') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{SimpleFLUsers1,AccesRacineArbo,SimpleFLUsers2,NeVoitPasEssais,FLUser1,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');

30.02s | SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Thread', 'Note', 'AdvancedSearch', 'Document', 'search_results', 'Picture', 'QueryNav', 'File', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Arctos & dermis & ventrus')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> '1d5929a4-3dd4-420c-98ab-703e0f11c266') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{SimpleFLUsers1,AccesRacineArbo,SimpleFLUsers2,NeVoitPasEssais,FLUser1,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');

29.94s | SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Thread', 'Note', 'AdvancedSearch', 'Document', 'search_results', 'Picture', 'QueryNav', 'File', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Major & dolicho')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> 'cfc11960-f51d-4f1a-8000-33472309ac74') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{SimpleFLUsers1,AccesRacineArbo,SimpleFLUsers2,NeVoitPasEssais,FLUser1,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');

2m5s

15.66

SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN (...) AND (NX_CONTAINS("fulltext"."fulltext", '')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> '') AND NX_ACCESS_ALLOWED("_nxhier"."id", '', '');

22.66s | SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');

21.19s | SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{AccesRacineArbo,SimpleFLUsers2,SimpleFLUsers3,NeVoitPasEssais,FLUser45,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');

17.52s | SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{AccesRacineArbo,SimpleFLUsers2,SimpleFLUsers3,NeVoitPasEssais,FLUser45,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');

0.8s

138

0.01

COMMIT PREPARED '';

0.6s

0.02

SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN '' THEN 0 WHEN '' THEN 0 WHEN '' THEN 0 WHEN '' THEN 0 WHEN '' THEN 0 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN '' THEN 0 WHEN '' THEN 0 WHEN '' THEN 0 WHEN '' THEN 0 WHEN '' THEN 0 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 0 WHEN con.condeferrable THEN 0 ELSE 0 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(0, 0) pos(n), pg_catalog.pg_depend dep, pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = '' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = '' AND dep.classid = ''::regclass::oid AND dep.refclassid = ''::regclass::oid AND fkn.nspname = '' AND fkc.relname = '' ORDER BY pkn.nspname,pkc.relname,pos.n;

0.13s | SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(1, 32) pos(n), pg_catalog.pg_depend dep, pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::regclass::oid AND dep.refclassid = 'pg_class'::regclass::oid AND fkn.nspname = 'public' AND fkc.relname = 'jbpm_log' ORDER BY pkn.nspname,pkc.relname,pos.n;

0.08s | SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(1, 32) pos(n), pg_catalog.pg_depend dep, pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::regclass::oid AND dep.refclassid = 'pg_class'::regclass::oid AND fkn.nspname = 'public' AND fkc.relname = 'nxp_webwidgets_widget_preferences' ORDER BY pkn.nspname,pkc.relname,pos.n;

0.05s | SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(1, 32) pos(n), pg_catalog.pg_depend dep, pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::regclass::oid AND dep.refclassid = 'pg_class'::regclass::oid AND fkn.nspname = 'public' AND fkc.relname = 'jbpm_event' ORDER BY pkn.nspname,pkc.relname,pos.n;

0.6s

250

0.00

SELECT "hierarchy"."id" FROM "hierarchy" LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "hierarchy"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN (...) AND ("hierarchy"."parentid" = '') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> '') AND NX_ACCESS_ALLOWED("hierarchy"."id", '', '') ORDER BY "dublincore"."modified" DESC;

0.05s | SELECT "hierarchy"."id" FROM "hierarchy" LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "hierarchy"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN ('Workspace', 'Forum', 'Section', 'MailFolder', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Domain', 'WebSite', 'TemplateRoot', 'WebPage', 'Folder', 'SectionRoot') AND ("hierarchy"."parentid" = '81282710-0cc2-4144-8baf-eb68066edee9') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("hierarchy"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}') ORDER BY "dublincore"."modified" DESC;

0.05s | SELECT "hierarchy"."id" FROM "hierarchy" LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "hierarchy"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN ('Workspace', 'Forum', 'Section', 'MailFolder', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Domain', 'WebSite', 'TemplateRoot', 'WebPage', 'Folder', 'SectionRoot') AND ("hierarchy"."parentid" = 'ae2e1a89-5576-44b9-a227-e6bf275d1353') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("hierarchy"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}') ORDER BY "dublincore"."modified" DESC;

0.03s | SELECT "hierarchy"."id" FROM "hierarchy" LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "hierarchy"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN ('Workspace', 'Forum', 'Section', 'MailFolder', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Domain', 'WebSite', 'TemplateRoot', 'WebPage', 'Folder', 'SectionRoot') AND ("hierarchy"."parentid" = '0ae77a8b-7b36-4970-ba6e-ef76ad001ba1') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("hierarchy"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}') ORDER BY "dublincore"."modified" DESC;

0.5s

0.09

INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR(''), NX_TO_TSVECTOR(NULL));

0.23s | INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('cabb1829-7b08-4ae2-9771-7e1114c89d0a', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR('Fuscus mauro rhiza FLUser1 /icons/folder.gif FLUser1 Unus delorum octa erythro sativus arvensis, maximus volans maculatus parvus. Saurus platy minor, mono chloreus hortensis vulgaris dolicho.'), NX_TO_TSVECTOR(NULL));

0.19s | INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('1d5929a4-3dd4-420c-98ab-703e0f11c266', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR('Nothos major oleum FLUser1 <ol><li>Trich argentatus hortensis</li><li>Arctos archaeos oleum octa</li></ol>Pteron striatus mono, ? albus pteron saurus argentatus. Palustris dodeca pteron argentatus dodeca lateralis ventrus. Tinctorius rostra ; cyanos viridis bradus tomentosus ? domesticus tris brachy dulcis caulos nothos maculatus argentatus lutea mauro. Cristatus fuscus volans dodeca fulvus punctatus sativus Lutea rhytis cauda tetra fuscus palustris rhiza rufus octa phyllo hortensis vulgaris bradus. Officinalis unus tris sativus cyanos bradus lateralis decaPalustris ortho vitis ennea, lutea punctatus trich cristatus. Novaehollandiae bradus cephalus maximus lutea cristatus campus cola folius, verrucosus officinalis cauda morphos familiaris sit familiaris dactylus tres trich. Cyanos volans platy brachy novaehollandiae tris unus arctos via Di gaster albus albus cyanos rufus stoma lipsem sativus phyllo argentatus. Fulvus fulvus mauro chloreus ortho biscortborealis dorsum variabilis albus, stoma phyton xanthos pelagius rubra brachy caulos. Variegatus zygos gaster domesticus indicus tris oeos variabilisLeucus striatus ? dolicho phyllo dactylus. Saurus palustris campus dulcis aquam orientalis ortho, pratensis pelagius obscurus, hortensis arctos dolicho chloreus. Mauro sativus novaehollandiae striatus erythro Niger pachys arvensis rostra mono fulvus rostra rhytis gaster penta cauda maculatus albus protos melanus. Indicus dodeca erythro domesticus ventrus, platy folius, variabilis archaeos arvensis diplo tetra. Xanthos echinus mauro, phyllo vitis cephalus. Albus parvus<ol><li>Cola cola</li><li>It cauda folius erythro it</li><li>Tres zygos dodeca sinensis pedis maximus</li></ol><ol><li>Hexa cyanos palustris</li><li>Octa phyton</li><li>Dodeca lipsem stoma unus</li></ol> FLUser1 /icons/note.gif Via melanus lineatus obscurus ad melanus, lutea sinensis campus australis rostra, niger penta aquam. Trich campus occidentalis penta mauro, dorsum obscurus pratensis archaeos archaeos verrucosus chilensis lipsem caulos tinctorius tris.'), NX_TO_TSVECTOR(NULL));

0.09s | INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('f3e282b2-ddd3-43ed-b605-816dc4cf7308', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR('Arctos dermis ventrus FLUser1 photo_23.JPG FLUser1 /icons/image.gif Occidentalis bradus lutea maximus argentatus trich unus mauro. Dermis ventrus ortho notos melanus penta parvus ennea leucus trich vitis xanthos lateralis fulvus rostra platy albus nona. Protos obscurus ! ! di folius oeos deca. photo_23.JPG image/jpeg'), NX_TO_TSVECTOR(NULL));

0.5s

138

0.00

PREPARE TRANSACTION '';

0.3s

0.30

CREATE OR REPLACE FUNCTION NX_IN_TREE(id varchar(36), baseid varchar(36)) RETURNS boolean AS $$ DECLARE curid varchar(36) := id; BEGIN IF baseid IS NULL OR id IS NULL OR baseid = id THEN RETURN false; END IF; LOOP SELECT parentid INTO curid FROM hierarchy WHERE hierarchy.id = curid; IF curid IS NULL THEN RETURN false; ELSEIF curid = baseid THEN RETURN true; END IF; END LOOP;END $$ LANGUAGE plpgsql STABLE;

0.2s

585

Day	Time	Count	Av. Duration
Jul 31	4pm	359	0.00
	5pm	226	0.00

0.00

COMMIT;

0.2s

274

Day	Time	Count	Av. Duration
Jul 31	4pm	159	0.00
	5pm	115	0.00

0.00

SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '' OR n.nspname = '' WHEN true THEN CASE WHEN n.nspname = '' OR n.nspname = '' THEN CASE c.relkind WHEN '' THEN '' WHEN '' THEN '' WHEN '' THEN '' ELSE NULL END WHEN n.nspname = '' THEN CASE c.relkind WHEN '' THEN '' WHEN '' THEN '' ELSE NULL END ELSE CASE c.relkind WHEN '' THEN '' WHEN '' THEN '' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN '' THEN '' WHEN '' THEN '' WHEN '' THEN '' WHEN '' THEN '' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='') WHERE c.relnamespace = n.oid AND c.relname LIKE '' AND (false OR ( c.relkind = '' AND n.nspname !~ '' AND n.nspname <> '' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME;

0.02s | SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'jena_%' AND (false OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME;

0.2s

0.00

SELECT DISTINCT "_nxhier"."id", "dublincore"."modified" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN (...) AND ("_nxhier"."parentid" = '') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> '') AND NX_ACCESS_ALLOWED("_nxhier"."id", '', '') ORDER BY "dublincore"."modified" DESC;

0.03s | SELECT DISTINCT "_nxhier"."id", "dublincore"."modified" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND ("_nxhier"."parentid" = 'dfbef5a3-1e4c-4487-8374-f750bbfeae9d') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}') ORDER BY "dublincore"."modified" DESC;

0.02s | SELECT DISTINCT "_nxhier"."id", "dublincore"."modified" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND ("_nxhier"."parentid" = 'b69b50b5-0992-4ff8-ad02-838b9c182b94') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}') ORDER BY "dublincore"."modified" DESC;

0.02s | SELECT DISTINCT "_nxhier"."id", "dublincore"."modified" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "dublincore" ON "hierarchy"."id" = "dublincore"."id" LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND ("_nxhier"."parentid" = 'f16e4f87-69dd-46cc-a542-7d99e72db036') AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}') ORDER BY "dublincore"."modified" DESC;

0.2s

0.00

SELECT "stylesheet_filename", "mime_type", "note" FROM "note" WHERE "id" = '';

0.1s

100

0.00

SELECT "uid" FROM "uid" WHERE "id" = '';

0.1s

9,718

Day	Time	Count	Av. Duration
Jul 31	4pm	6,837	0.00
	5pm	2,881	0.00

0.00

SELECT S.Subj, S.Prop, S.Obj FROM jena_sys_stmt S WHERE S.Subj = '' AND S.Prop = '' AND S.GraphID = 0;

0.1s

0.00

SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE '' AND c.relname LIKE '' AND a.attname LIKE '' ORDER BY nspname,relname,attnum;

0.03s | SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'uid_sequence' AND a.attname LIKE '%' ORDER BY nspname,relname,attnum;

0.02s | SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'localthemeconfig' AND a.attname LIKE '%' ORDER BY nspname,relname,attnum;

0.02s | SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE '%' AND c.relname LIKE 'country' AND a.attname LIKE '%' ORDER BY nspname,relname,attnum;

0.1s

0.00

SELECT "id", "pos", "name", "primarytype", "ischeckedin", "baseversionid", "majorversion", "minorversion" FROM "hierarchy" WHERE "parentid" = '' AND "isproperty" = '';

0.1s

126

0.00

SELECT "encoding", "length", "data", "digest", "name", "mime-type" FROM "content" WHERE "id" = '';

0.1s

0.01

INSERT INTO "hierarchy" ("id", "parentid", "pos", "name", "isproperty", "primarytype", "ischeckedin", "baseversionid", "majorversion", "minorversion") VALUES ('', '', NULL, '', '', '', NULL, NULL, NULL, NULL);

0.1s

0.09

SELECT COUNT(*) FROM jena_g2t1_stmt WHERE (GraphID = 2);

0.1s

289

0.00

SELECT "icon", "icon-expanded", "size" FROM "common" WHERE "id" = '';

Slowest queries ^

Rank	Duration (s)	Query
1	86.39	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Thread', 'Note', 'AdvancedSearch', 'Document', 'search_results', 'Picture', 'QueryNav', 'File', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Major & dolicho')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> '63d023ee-706c-41f8-9513-5c03a1cdb7f6') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{SimpleFLUsers1,AccesRacineArbo,SimpleFLUsers2,NeVoitPasEssais,FLUser1,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
2	30.02	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Thread', 'Note', 'AdvancedSearch', 'Document', 'search_results', 'Picture', 'QueryNav', 'File', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Arctos & dermis & ventrus')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> '1d5929a4-3dd4-420c-98ab-703e0f11c266') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{SimpleFLUsers1,AccesRacineArbo,SimpleFLUsers2,NeVoitPasEssais,FLUser1,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
3	29.94	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Thread', 'Note', 'AdvancedSearch', 'Document', 'search_results', 'Picture', 'QueryNav', 'File', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Major & dolicho')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> 'cfc11960-f51d-4f1a-8000-33472309ac74') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{SimpleFLUsers1,AccesRacineArbo,SimpleFLUsers2,NeVoitPasEssais,FLUser1,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
4	22.66	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
5	21.19	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{AccesRacineArbo,SimpleFLUsers2,SimpleFLUsers3,NeVoitPasEssais,FLUser45,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
6	17.52	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{AccesRacineArbo,SimpleFLUsers2,SimpleFLUsers3,NeVoitPasEssais,FLUser45,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
7	17.34	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Thread', 'Note', 'AdvancedSearch', 'Document', 'search_results', 'Picture', 'QueryNav', 'File', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Arctos & dermis & ventrus')) AND ("versions"."id" IS NULL) AND ("_nxhier"."id" <> '1d5929a4-3dd4-420c-98ab-703e0f11c266') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{SimpleFLUsers1,AccesRacineArbo,SimpleFLUsers2,NeVoitPasEssais,FLUser1,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
8	16.41	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
9	15.74	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
10	13.86	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{administrators,giarmoleol,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
11	12.45	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{AccesRacineArbo,SimpleFLUsers2,SimpleFLUsers3,NeVoitPasEssais,FLUser45,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
12	5.50	SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN ('MailMessage', 'Workspace', 'Forum', 'Thread', 'Section', 'Note', 'MailFolder', 'AdvancedSearch', 'PictureBook', 'OrderedFolder', 'WorkspaceRoot', 'Document', 'search_results', 'Picture', 'Domain', 'WebSite', 'TemplateRoot', 'QueryNav', 'File', 'WebPage', 'Folder', 'SectionRoot', 'ContextualLink') AND (NX_CONTAINS("fulltext"."fulltext", 'Via & rufus & melanus & variegatus')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> 'deleted') AND NX_ACCESS_ALLOWED("_nxhier"."id", '{AccesRacineArbo,SimpleFLUsers2,SimpleFLUsers3,NeVoitPasEssais,FLUser45,Everyone}', '{Browse,Read,ReadProperties,ReadRemove,ReadWrite,Everything}');
13	0.30	CREATE OR REPLACE FUNCTION NX_IN_TREE(id varchar(36), baseid varchar(36)) RETURNS boolean AS $$ DECLARE curid varchar(36) := id; BEGIN IF baseid IS NULL OR id IS NULL OR baseid = id THEN RETURN false; END IF; LOOP SELECT parentid INTO curid FROM hierarchy WHERE hierarchy.id = curid; IF curid IS NULL THEN RETURN false; ELSEIF curid = baseid THEN RETURN true; END IF; END LOOP;END $$ LANGUAGE plpgsql STABLE;
14	0.23	INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('cabb1829-7b08-4ae2-9771-7e1114c89d0a', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR('Fuscus mauro rhiza FLUser1 /icons/folder.gif FLUser1 Unus delorum octa erythro sativus arvensis, maximus volans maculatus parvus. Saurus platy minor, mono chloreus hortensis vulgaris dolicho.'), NX_TO_TSVECTOR(NULL));
15	0.19	INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('1d5929a4-3dd4-420c-98ab-703e0f11c266', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR('Nothos major oleum FLUser1 <ol><li>Trich argentatus hortensis</li><li>Arctos archaeos oleum octa</li></ol><p>Pteron striatus mono, ? albus pteron saurus argentatus. Palustris dodeca pteron argentatus dodeca lateralis ventrus. Tinctorius rostra ; cyanos viridis bradus tomentosus ? domesticus tris brachy dulcis caulos nothos maculatus argentatus lutea mauro. <strong>Cristatus fuscus volans dodeca fulvus punctatus sativus</strong> Lutea rhytis cauda tetra fuscus palustris rhiza rufus octa phyllo hortensis vulgaris bradus. <em>Officinalis unus tris sativus cyanos bradus lateralis deca</em></p><p>Palustris ortho vitis ennea, lutea punctatus trich cristatus. Novaehollandiae bradus cephalus maximus lutea cristatus campus cola folius, verrucosus officinalis cauda morphos familiaris sit familiaris dactylus tres trich. <strong>Cyanos volans platy brachy novaehollandiae tris unus arctos via</strong> Di gaster albus albus cyanos rufus stoma lipsem sativus phyllo argentatus. Fulvus fulvus mauro chloreus ortho biscortborealis dorsum variabilis albus, stoma phyton xanthos pelagius rubra brachy caulos. <em>Variegatus zygos gaster domesticus indicus tris oeos variabilis</em></p><p>Leucus striatus ? dolicho phyllo dactylus. Saurus palustris campus dulcis aquam orientalis ortho, pratensis pelagius obscurus, hortensis arctos dolicho chloreus. <strong>Mauro sativus novaehollandiae striatus erythro</strong> Niger pachys arvensis rostra mono fulvus rostra rhytis gaster penta cauda maculatus albus protos melanus. Indicus dodeca erythro domesticus ventrus, platy folius, variabilis archaeos arvensis diplo tetra. Xanthos echinus mauro, phyllo vitis cephalus. <em>Albus parvus</em></p><ol><li>Cola cola</li><li>It cauda folius erythro it</li><li>Tres zygos dodeca sinensis pedis maximus</li></ol><ol><li>Hexa cyanos palustris</li><li>Octa phyton</li><li>Dodeca lipsem stoma unus</li></ol> FLUser1 /icons/note.gif Via melanus lineatus obscurus ad melanus, lutea sinensis campus australis rostra, niger penta aquam. Trich campus occidentalis penta mauro, dorsum obscurus pratensis archaeos archaeos verrucosus chilensis lipsem caulos tinctorius tris.'), NX_TO_TSVECTOR(NULL));
16	0.13	SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(1, 32) pos(n), pg_catalog.pg_depend dep, pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::regclass::oid AND dep.refclassid = 'pg_class'::regclass::oid AND fkn.nspname = 'public' AND fkc.relname = 'jbpm_log' ORDER BY pkn.nspname,pkc.relname,pos.n;
17	0.09	INSERT INTO "hierarchy" ("id", "parentid", "pos", "name", "isproperty", "primarytype", "ischeckedin", "baseversionid", "majorversion", "minorversion") VALUES ('cabb1829-7b08-4ae2-9771-7e1114c89d0a', 'bcc1c592-1149-43db-bf1b-d6adc91245bf', NULL, 'fuscus-mauro-rhiza', 'f', 'Folder', NULL, NULL, NULL, NULL);
18	0.09	INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('f3e282b2-ddd3-43ed-b605-816dc4cf7308', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR('Arctos dermis ventrus FLUser1 photo_23.JPG FLUser1 /icons/image.gif Occidentalis bradus lutea maximus argentatus trich unus mauro. Dermis ventrus ortho notos melanus penta parvus ennea leucus trich vitis xanthos lateralis fulvus rostra platy albus nona. Protos obscurus ! ! di folius oeos deca. photo_23.JPG image/jpeg'), NX_TO_TSVECTOR(NULL));
19	0.09	SELECT COUNT(*) FROM jena_g2t1_stmt WHERE (GraphID = 2);
20	0.08	SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(1, 32) pos(n), pg_catalog.pg_depend dep, pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::regclass::oid AND dep.refclassid = 'pg_class'::regclass::oid AND fkn.nspname = 'public' AND fkc.relname = 'nxp_webwidgets_widget_preferences' ORDER BY pkn.nspname,pkc.relname,pos.n;

Most frequent queries (N) ^

Rank

Times executed

Total duration

Av. duration (s)

Query

9,718

Day	Time	Count	Av. Duration
Jul 31	4pm	6,837	0.00
	5pm	2,881	0.00

0.1s

0.00

SELECT S.Subj, S.Prop, S.Obj FROM jena_sys_stmt S WHERE S.Subj = '' AND S.Prop = '' AND S.GraphID = 0;

1,356

Day	Time	Count	Av. Duration
Jul 31	4pm	954	0.00
	5pm	402	0.00

0.0s

0.00

SELECT S.Subj, S.Prop, S.Obj FROM jena_sys_stmt S WHERE S.Obj = '' AND S.Subj = '' AND S.Prop = '' AND S.GraphID = 0;

1,130

Day	Time	Count	Av. Duration
Jul 31	4pm	795	0.00
	5pm	335	0.00

0.1s

0.00

SELECT S.Subj, S.Prop, S.Obj FROM jena_sys_stmt S WHERE S.Prop = '' AND S.GraphID = 0;

1,061

Day	Time	Count	Av. Duration
Jul 31	4pm	960	0.00
	5pm	101	0.00

0.0s

0.00

select * from "groups" where "groupname" = '';

1,060

Day	Time	Count	Av. Duration
Jul 31	4pm	960	0.00
	5pm	100	0.00

0.1s

0.00

select "userId" from "user2group" where "groupId" = '';

1,060

Day	Time	Count	Av. Duration
Jul 31	4pm	960	0.00
	5pm	100	0.00

0.0s

0.00

select "childGroupId" from "group2group" where "parentGroupId" = '';

1,060

Day	Time	Count	Av. Duration
Jul 31	4pm	960	0.00
	5pm	100	0.00

0.0s

0.00

select "parentGroupId" from "group2group" where "childGroupId" = '';

904

Day	Time	Count	Av. Duration
Jul 31	4pm	636	0.00
	5pm	268	0.00

0.0s

0.00

SELECT S.Subj, S.Prop, S.Obj FROM jena_sys_stmt S WHERE S.Obj = '' AND S.Prop = '' AND S.GraphID = 0;

723

Day	Time	Count	Av. Duration
Jul 31	4pm	359	0.00
	5pm	364	0.00

0.0s

0.00

BEGIN;

615

Day	Time	Count	Av. Duration
Jul 31	4pm	370	0.00
	5pm	245	0.00

0.0s

0.00

select localtheme0_.id as id3_, localtheme0_.themode as themode3_, localtheme0_.engine as engine3_, localtheme0_.page as page3_, localtheme0_.docId as docId3_, localtheme0_.perspective as perspect6_3_, localtheme0_.theme as theme3_ from LocalThemeConfig localtheme0_ where localtheme0_.docId='';

585

Day	Time	Count	Av. Duration
Jul 31	4pm	359	0.00
	5pm	226	0.00

0.2s

0.00

COMMIT;

302

0.0s

0.00

SELECT "lifecyclepolicy", "lifecyclestate", "dirty", "wfinprogress", "wfincoption" FROM "misc" WHERE "id" = '';

302

0.0s

0.00

SELECT "valid", "issued", "coverage", "title", "modified", "creator", "rights", "language", "expired", "created", "source", "description", "format" FROM "dublincore" WHERE "id" = '';

297

0.1s

0.00

SELECT "pos", "item" FROM "dc_contributors" WHERE "id" = '' ORDER BY "pos";

289

0.1s

0.00

SELECT "icon", "icon-expanded", "size" FROM "common" WHERE "id" = '';

285

0.0s

0.00

SELECT "lock" FROM "locks" WHERE "id" = '';

281

0.1s

0.00

SELECT "parentid", "pos", "name", "isproperty", "primarytype", "ischeckedin", "baseversionid", "majorversion", "minorversion" FROM "hierarchy" WHERE "id" = '';

274

Day	Time	Count	Av. Duration
Jul 31	4pm	159	0.00
	5pm	115	0.00

0.2s

0.00

264

0.0s

0.00

SELECT "pos", "name", "grant", "permission", "user", "group" FROM "acls" WHERE "id" = '' ORDER BY "pos";

255

0.0s

0.00

SELECT "pos", "item" FROM "dc_subjects" WHERE "id" = '' ORDER BY "pos";

Slowest queries (N) ^

Rank

Av. duration (s)

Times executed

Total duration

Query

40.92

2m43s

15.66

2m5s

SELECT DISTINCT "_nxhier"."id" FROM "hierarchy" "_nxhier" LEFT JOIN "proxies" ON "proxies"."id" = "_nxhier"."id" JOIN "hierarchy" ON ("hierarchy"."id" = "_nxhier"."id" OR "hierarchy"."id" = "proxies"."targetid") LEFT JOIN "versions" ON "_nxhier"."id" = "versions"."id" LEFT JOIN "misc" ON "hierarchy"."id" = "misc"."id" LEFT JOIN "fulltext" ON "hierarchy"."id" = "fulltext"."id" WHERE "hierarchy"."primarytype" IN (...) AND (NX_CONTAINS("fulltext"."fulltext", '')) AND ("versions"."id" IS NULL) AND ("misc"."lifecyclestate" <> '') AND NX_ACCESS_ALLOWED("_nxhier"."id", '', '');

0.30

0.3s

0.09

0.1s

SELECT COUNT(*) FROM jena_g2t1_stmt WHERE (GraphID = 2);

0.09

0.5s

INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES ('', NX_TO_TSVECTOR(NULL), NX_TO_TSVECTOR(''), NX_TO_TSVECTOR(NULL));

0.05

0.0s

DROP TRIGGER IF EXISTS NX_TRIG_FT_UPDATE ON "fulltext";

0.05

0.0s

CREATE OR REPLACE FUNCTION NX_TO_TSVECTOR(string VARCHAR) RETURNS TSVECTOR AS $$ SELECT TO_TSVECTOR('english', $1) $$ LANGUAGE sql STABLE;

0.03

0.0s

select HIGHVALUES from HILOSEQUENCES where SEQUENCENAME='general';

0.02

0.6s

0.02

0.0s

insert into LocalThemeConfig (themode, engine, page, docId, perspective, theme, id) values (NULL, NULL, '', '', NULL, '', 0);

0.02

0.0s

CREATE OR REPLACE FUNCTION NX_ACCESS_ALLOWED(id varchar(36), users varchar[], permissions varchar[]) RETURNS boolean AS $$ DECLARE curid varchar(36) := id; newid varchar(36); r record; first boolean := true;BEGIN WHILE curid IS NOT NULL LOOP FOR r in SELECT acls.grant, acls.permission, acls.user FROM acls WHERE acls.id = curid ORDER BY acls.pos LOOP IF r.permission = ANY(permissions) AND r.user = ANY(users) THEN RETURN r.grant; END IF; END LOOP; SELECT parentid INTO newid FROM hierarchy WHERE hierarchy.id = curid; IF first AND newid IS NULL THEN SELECT versionableid INTO newid FROM versions WHERE versions.id = curid; END IF; first := false; curid := newid; END LOOP; RETURN false; END $$ LANGUAGE plpgsql STABLE;

0.02

0.0s

CREATE OR REPLACE FUNCTION NX_CONTAINS(ft TSVECTOR, query VARCHAR) RETURNS boolean AS $$ SELECT $1 @@ TO_TSQUERY('english', $2) $$ LANGUAGE sql STABLE;

0.02

0.0s

CREATE TRIGGER NX_TRIG_FT_UPDATE BEFORE INSERT OR UPDATE ON "fulltext" FOR EACH ROW EXECUTE PROCEDURE NX_UPDATE_FULLTEXT();

0.01

0.0s

INSERT INTO "file" ("id", "filename") VALUES ('', '');

0.01

0.1s

UPDATE "fulltext" SET "simpletext" = NX_TO_TSVECTOR('') WHERE "id" = '';

0.03s | UPDATE "fulltext" SET "simpletext" = NX_TO_TSVECTOR(' Diplo vulgaris mauro (copied) FLUser1 <ul><li>Zygos arctos</li><li>Notos echinus cephalus pteron</li><li>Rhytis rostra hexa</li></ul>Palustris familiaris so melanus, dodeca aquam sativus. Penta tomentosus chilensis major phyllo archaeos, palustris novaeseelandiae rufus dactylus phyton octa delorum dermis fulvus. Variegatus penta zygos caulos campus protos xanthos petra Hortensis tinctorius folius mono albus punctatus penta orientalis zygos leucus noveboracensis cristatus, australis nona nona maximus. Pachys variegatus biscortborealis penta brachy dorsum major petra volans rostra. Niger obscurus sativus silvestris cephalus flora. Caulos glycis cephalus cephalus tinctoriusDorsum sinensis parvus campus xanthos occidentalis<a href="http://10.1.4.12:8080/nuxeo/nxdoc/default/f3e282b2-ddd3-43ed-b605-816dc4cf7308/view_documents?tabId=&conversationId=0NXMAIN">Arctos dermis ventrus</a>Archaeos dolicho biscortborealis silvestris cephalusVia aquam ? phyton arvensis zygos, viridis folius melanus. Nothos phyllo ventrus punctatus via zygos Xanthos sativus verrucosus lutea nothos glycis petra leucus archaeos echinus ennea dermis niger. Lipsem biscortborealis dodeca tomentosus<img src="http://10.1.4.12:8080/nuxeo/nxfile/default/1d5929a4-3dd4-420c-98ab-703e0f11c266/files:files/0/file/photo_28.JPG" alt="" /><ol><li>Viridis morphos dermis parvus octa</li><li>Nothos viridis</li><li>Hexa minimus saurus</li><li>Montanus palustris maximus</li></ol><ol><li>Unus cauda rostra domesticus novaeseelandiae</li><li>Chloreus hortensis nona ad familiaris ortho</li><li>Punctatus thrix argentatus stoma</li><li>Brachy australis</li></ol> FLUser1 /icons/note.gif Pedis echinus fuscus pelagius ! familiaris variegatus gaster phyton maculatus diplo rhiza it rubra brevis maculatus. Variabilis palustris trich di nona, bradus sit mauro dodeca pachys delorum maculatus occidentalis, ennea novaeseelandiae hortensis chloreus. photo_28.JPG photo_28.JPG image/jpeg') WHERE "id" = '1d5929a4-3dd4-420c-98ab-703e0f11c266';

0.02s | UPDATE "fulltext" SET "simpletext" = NX_TO_TSVECTOR('Nothos major oleum FLUser1 <ol><li>Trich argentatus hortensis</li><li>Arctos archaeos oleum octa</li></ol>Pteron striatus mono, ? albus pteron saurus argentatus. Palustris dodeca pteron argentatus dodeca lateralis ventrus. Tinctorius rostra ; cyanos viridis bradus tomentosus ? domesticus tris brachy dulcis caulos nothos maculatus argentatus lutea mauro. Cristatus fuscus volans dodeca fulvus punctatus sativus Lutea rhytis cauda tetra fuscus palustris rhiza rufus octa phyllo hortensis vulgaris bradus. Officinalis unus tris sativus cyanos bradus lateralis decaPalustris ortho vitis ennea, lutea punctatus trich cristatus. Novaehollandiae bradus cephalus maximus lutea cristatus campus cola folius, verrucosus officinalis cauda morphos familiaris sit familiaris dactylus tres trich. Cyanos volans platy brachy novaehollandiae tris unus arctos via Di gaster albus albus cyanos rufus stoma lipsem sativus phyllo argentatus. Fulvus fulvus mauro chloreus ortho biscortborealis dorsum variabilis albus, stoma phyton xanthos pelagius rubra brachy caulos. Variegatus zygos gaster domesticus indicus tris oeos variabilisLeucus striatus ? dolicho phyllo dactylus. Saurus palustris campus dulcis aquam orientalis ortho, pratensis pelagius obscurus, hortensis arctos dolicho chloreus. Mauro sativus novaehollandiae striatus erythro Niger pachys arvensis rostra mono fulvus rostra rhytis gaster penta cauda maculatus albus protos melanus. Indicus dodeca erythro domesticus ventrus, platy folius, variabilis archaeos arvensis diplo tetra. Xanthos echinus mauro, phyllo vitis cephalus. Albus parvus<ol><li>Cola cola</li><li>It cauda folius erythro it</li><li>Tres zygos dodeca sinensis pedis maximus</li></ol><ol><li>Hexa cyanos palustris</li><li>Octa phyton</li><li>Dodeca lipsem stoma unus</li></ol> FLUser1 /icons/note.gif Via melanus lineatus obscurus ad melanus, lutea sinensis campus australis rostra, niger penta aquam. Trich campus occidentalis penta mauro, dorsum obscurus pratensis archaeos archaeos verrucosus chilensis lipsem caulos tinctorius tris. photo_28.JPG photo_28.JPG image/jpeg') WHERE "id" = '1d5929a4-3dd4-420c-98ab-703e0f11c266';

0.02s | UPDATE "fulltext" SET "simpletext" = NX_TO_TSVECTOR(' Di echinus FLUser1 Major minimus maximus bradus biscortborealis novaehollandiae folius australis saurus it. Oeos zygos minimus phyton lutea it montanus tinctorius, viridis cyanos cephalus ad dermis mono. Xanthos dermis dorsum vulgaris saurus sativus caulos mauro xanthos noveboracensis echinus dorsum thrix pedis ? lutea striatus delorum variegatus pedis. Di niger familiaris fuscus penta protos phyton pteron Cristatus sativus major echinus montanus cola, maculatus pratensis rufus indicus ennea dulcis australis noveboracensis hexa major dulcis variegatus dolicho. Familiaris dorsum oeos<ol><li>Lateralis</li><li>Tris dorsum oleum variabilis fuscus rubra</li><li>Rubra petra diplo lutea sit</li><li>Sativus pratensis tres</li><li>Gaster tetra folius dodeca caulos</li><li>Rubra aquam novaehollandiae trich</li></ol>Cauda ennea variabilis chloreus<a href="http://10.1.4.12:8080/nuxeo/nxdoc/default/d246ce00-9e97-4969-8f58-0a028ad25516/view_documents?tabId=&conversationId=0NXMAIN">Major dolicho</a>Cauda ennea<ol><li>Campus variabilis stoma pelagius notos</li><li>Rhytis leucus</li><li>Rhytis diplo</li><li>Major aquam biscortborealis indicus variabilis</li><li>Tetra dermis</li></ol><img src="http://10.1.4.12:8080/nuxeo/nxfile/default/63d023ee-706c-41f8-9513-5c03a1cdb7f6/files:files/0/file/photo_6.JPG" alt="" /><ul><li>Tetra caulos familiaris it chilensis fuscus</li><li>Platy</li><li>Platy hortensis cola rhiza</li><li>Brevis fulvus pelagius glycis occidentalis cola</li></ul> FLUser1 /icons/note.gif Platy tres noveboracensis rufus pratensis archaeos phyton novaeseelandiae tinctorius lateralis leucus punctatus, rubra diplo albus tris flora. Erythro tris penta chloreus tomentosus novaeseelandiae obscurus echinus dorsum fulvus fuscus brevis silvestris argentatus. Cristatus oleum trich, striatus erythro tris sinensis sinensis ortho viridis sativus lateralis stoma obscurus it trich hortensis erythro flora. photo_6.JPG photo_6.JPG image/jpeg') WHERE "id" = '63d023ee-706c-41f8-9513-5c03a1cdb7f6';

0.01

0.1s

0.01

0.0s

SELECT "pos", "item" FROM "content_roots" WHERE "id" = '' ORDER BY "pos";

0.01

Day	Time	Count	Av. Duration
Jul 31	4pm	1	0.00
	5pm	1	0.02

0.0s

INSERT INTO jena_long_lit (ID, Head, ChkSum, Tail) VALUES (0, '', 0, '');

0.01

0.0s

0.02s | SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'timers' ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME;

0.00s | SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'hilosequences' ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME;

0.01

Day	Time	Count	Av. Duration
Jul 31	4pm	2	0.00
	5pm	2	0.02

0.0s

SELECT ID FROM jena_long_lit WHERE Head = '' and ChkSum = 0;