Queries

truncate "pageTree" restart identity

SELECT COALESCE(SUM(pg_stat_get_live_tuples(c.oid)), $1) AS n_live_tup, COALESCE(SUM(pg_stat_get_dead_tuples(c.oid)), $2) AS n_dead_tup, current_timestamp FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = ANY (ARRAY[$3::"char", $4::"char", $5::"char", $6::"char"]) AND n.nspname <> ALL (ARRAY[$7::name, $8::name, $9::name])

SELECT
    COALESCE(sum(psat.n_tup_upd), $1) AS total_update_count,
    COALESCE(sum(psat.n_tup_hot_upd), $2) AS hot_update_count,
    (SELECT psd.stats_reset AS stats_reset_time FROM pg_catalog.pg_stat_database psd WHERE psd.datname = current_database()) AS stats_reset_time FROM
    pg_catalog.pg_stat_all_tables psat

SELECT COALESCE(SUM(pg_stat_get_live_tuples(c.oid)), $1) AS n_live_tup, COALESCE(SUM(pg_stat_get_dead_tuples(c.oid)), $2) AS n_dead_tup, current_timestamp FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = ANY (ARRAY[$3::"char", $4::"char", $5::"char", $6::"char"]) AND n.nspname = $7::name

update "locales" set "code" = $1, "strings" = $2, "isRTL" = $3, "name" = $4, "nativeName" = $5, "availability" = $6, "updatedAt" = $7 where "code" = $8

SELECT
    sum(psat.autovacuum_count) AS total_autovacuum_count,
    sum(psat.autoanalyze_count) AS total_autoanalyze_count,
    (SELECT psd.stats_reset FROM pg_stat_database psd WHERE psd.datname = current_database()) AS stats_reset_time
FROM
    pg_catalog.pg_stat_all_tables psat

update "analytics" set "config" = $1 where "key" = $2

update "renderers" set "config" = $1 where "key" = $2

select "locales".* from "locales" where "code" = $1

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176), ($177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187), ($188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209), ($210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220), ($221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231), ($232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242), ($243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253), ($254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264), ($265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275), ($276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286), ($287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297), ($298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308)

update "editors" set "config" = $1 where "key" = $2

update "loggers" set "config" = $1 where "key" = $2

SELECT extname, current_timestamp FROM pg_catalog.pg_extension UNION SELECT plugin, current_timestamp FROM pg_catalog.pg_replication_slots WHERE slot_type = $1 AND database = current_database()

SELECT COALESCE(SUM(pg_stat_get_live_tuples(c.oid)),$1) AS n_live_tup, COALESCE(SUM(pg_stat_get_dead_tuples(c.oid)),$2) AS n_dead_tup, current_timestamp FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = ANY (ARRAY[$3::"char", $4::"char", $5::"char", $6::"char"]) AND (n.nspname <> ALL (ARRAY[$7::name, $8::name])) AND n.nspname !~ $9::text

update "storage" set "config" = $1 where "key" = $2

update "migrations_lock" set "is_locked" = $1 where "is_locked" = $2

update "searchEngines" set "config" = $1 where "key" = $2

select * from information_schema.tables where table_name = $1 and table_schema = current_schema()

set application_name = 'Wiki.js'

update "commentProviders" set "config" = $1 where "key" = $2

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99)

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176), ($177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187), ($188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209), ($210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220), ($221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231), ($232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242), ($243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253)

select "settings".* from "settings"

select "id", "path", "localeCode", "title", "isPrivate", "privateNS" from "pages" order by "localeCode" asc, "path" asc

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176), ($177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187), ($188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209), ($210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220), ($221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231), ($232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242), ($243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253), ($254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264), ($265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275), ($276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286)

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110)

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176), ($177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187), ($188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209), ($210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220), ($221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231)

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176), ($177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187), ($188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209), ($210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220)

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176), ($177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187), ($188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209), ($210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220), ($221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231), ($232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242), ($243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253), ($254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264)

select "authentication".* from "authentication" order by "order" asc

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77)

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176)

select "name" from "migrations" order by "id" asc

select "storage".* from "storage" where "isEnabled" = $1 order by "key" asc

select * from information_schema.columns where table_name = $1 and table_catalog = $2 and table_schema = current_schema()

SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
  t.typname IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40)

select * from "migrations_lock"

select "groups".* from "groups"

select "analytics".* from "analytics"

select * from "assetData" where "id" = $1 limit $2

delete from "sessions" where expired < CAST($1 as timestamp with time zone)

SELECT n.nspname AS table_schema, c.relname AS table, attname AS column, format_type(a.atttypid, a.atttypmod) AS column_type, pg_get_expr(d.adbin, d.adrelid) AS default_value FROM pg_catalog.pg_attribute a INNER JOIN pg_catalog.pg_class c ON c.oid = a.attrelid INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace INNER JOIN pg_catalog.pg_attrdef d ON (a.attrelid, a.attnum) = (d.adrelid, d.adnum) WHERE NOT a.attisdropped AND a.attnum > $1 AND pg_get_expr(d.adbin, d.adrelid) LIKE $2 AND n.nspname NOT LIKE $3 /*pghero*/

update "migrations_lock" set "is_locked" = $1

select version()

select "commentProviders".* from "commentProviders" where "isEnabled" = $1

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132)

select "pages"."id", "pages"."path", "pages"."hash", "pages"."title", "pages"."description", "pages"."isPrivate", "pages"."isPublished", "pages"."privateNS", "pages"."publishStartDate", "pages"."publishEndDate", "pages"."content", "pages"."render", "pages"."toc", "pages"."contentType", "pages"."createdAt", "pages"."updatedAt", "pages"."editorKey", "pages"."localeCode", "pages"."authorId", "pages"."creatorId", "pages"."extra", "author"."name" as "authorName", "author"."email" as "authorEmail", "creator"."name" as "creatorName", "creator"."email" as "creatorEmail", "tags"."tag" as "tags:tag", "tags"."title" as "tags:title", "tags"."id" as "tags:id" from "pages" inner join "users" as "author" on "author"."id" = "pages"."authorId" inner join "users" as "creator" on "creator"."id" = "pages"."creatorId" left join "pageTags" as "tags_join" on "tags_join"."pageId" = "pages"."id" left join (select "tag", "title", "tags"."id" from "tags") as "tags" on "tags_join"."tagId" = "tags"."id" where "pages"."path" = $1 and "pages"."localeCode" = $2

select * from "authentication"

select * from "migrations"

select "renderers".* from "renderers"

select "loggers".* from "loggers"

select "storage".* from "storage"

WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, ((total_plan_time + total_exec_time) / $2 / $3) AS total_minutes, ((total_plan_time + total_exec_time) / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /*pghero*/

select "editors".* from "editors"

SELECT t.oid, t.typname
FROM pg_type as t
WHERE t.typname IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)

select "users"."id" as "id", "users"."email" as "email", "users"."name" as "name", "users"."providerId" as "providerId", "users"."password" as "password", "users"."tfaIsActive" as "tfaIsActive", "users"."tfaSecret" as "tfaSecret", "users"."jobTitle" as "jobTitle", "users"."location" as "location", "users"."pictureUrl" as "pictureUrl", "users"."timezone" as "timezone", "users"."isSystem" as "isSystem", "users"."isActive" as "isActive", "users"."isVerified" as "isVerified", "users"."mustChangePwd" as "mustChangePwd", "users"."createdAt" as "createdAt", "users"."updatedAt" as "updatedAt", "users"."providerKey" as "providerKey", "users"."localeCode" as "localeCode", "users"."defaultEditor" as "defaultEditor", "users"."lastLoginAt" as "lastLoginAt", "users"."dateFormat" as "dateFormat", "users"."appearance" as "appearance", "groups"."id" as "groups:id", "groups"."permissions" as "groups:permissions" from "users" left join "userGroups" as "groups_join" on "groups_join"."userId" = "users"."id" left join (select "groups"."id", "permissions" from "groups") as "groups" on "groups_join"."groupId" = "groups"."id" where "users"."id" = $1

select "searchEngines".* from "searchEngines" where "isEnabled" = $1

select "searchEngines".* from "searchEngines"

SELECT extname, current_timestamp FROM pg_catalog.pg_extension

SELECT $1 + $2

select max("batch") as "max_batch" from "migrations"

select "commentProviders".* from "commentProviders"

SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/

select "pages"."id", "tags"."tag" as "tags:tag", "tags"."id" as "tags:id" from "pages" left join "pageTags" as "tags_join" on "tags_join"."pageId" = "pages"."id" left join (select "tag", "tags"."id" from "tags") as "tags" on "tags_join"."tagId" = "tags"."id" where "localeCode" = $1 and "path" = $2

insert into "pageHistory" ("action", "authorId", "content", "contentType", "createdAt", "description", "editorKey", "hash", "isPrivate", "isPublished", "localeCode", "pageId", "path", "publishEndDate", "publishStartDate", "title", "versionDate") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) returning "id"

update "users" set "lastLoginAt" = $1 where "id" = $2

select "id" from "apiKeys" where "isRevoked" = $1 and "expiration" > $2

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55), ($56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77), ($78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88), ($89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99), ($100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110), ($111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121), ($122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154), ($155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165), ($166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176), ($177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187), ($188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209), ($210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220), ($221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231), ($232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242), ($243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253), ($254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264), ($265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275), ($276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286), ($287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297), ($298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308), ($309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319), ($320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330), ($331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341), ($342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352), ($353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363), ($364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374), ($375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385), ($386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396), ($397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407), ($408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418), ($419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429), ($430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440), ($441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451)

SELECT last_value FROM "public"."migrations_id_seq" UNION ALL SELECT last_value FROM "public"."migrations_lock_index_seq" UNION ALL SELECT last_value FROM "public"."assets_id_seq" UNION ALL SELECT last_value FROM "public"."assetFolders_id_seq" UNION ALL SELECT last_value FROM "public"."comments_id_seq" UNION ALL SELECT last_value FROM "public"."groups_id_seq" UNION ALL SELECT last_value FROM "public"."pageHistory_id_seq" UNION ALL SELECT last_value FROM "public"."pageLinks_id_seq" UNION ALL SELECT last_value FROM "public"."pages_id_seq" UNION ALL SELECT last_value FROM "public"."tags_id_seq" UNION ALL SELECT last_value FROM "public"."userKeys_id_seq" UNION ALL SELECT last_value FROM "public"."users_id_seq" UNION ALL SELECT last_value FROM "public"."pageHistoryTags_id_seq" UNION ALL SELECT last_value FROM "public"."pageTags_id_seq" UNION ALL SELECT last_value FROM "public"."userGroups_id_seq" UNION ALL SELECT last_value FROM "public"."apiKeys_id_seq" /*pghero*/

select "userGroups"."userId" as "objectiontmpjoin0", "groups"."id", "permissions" from "groups" inner join "userGroups" on "groups"."id" = "userGroups"."groupId" where "userGroups"."userId" in ($1)

select * from "pageTree" where ("localeCode" = $1 and "parent" is null) order by "isFolder" desc, "title" asc

SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
  t.typtype IN ($1, $2, $3)

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44)

SELECT * FROM pg_stat_statements LIMIT $1 /*pghero*/

insert into "assetData" ("data", "id") values ($1, $2)

select "users".* from "users" where "users"."id" = $1

select "analytics".* from "analytics" where "isEnabled" = $1

update "pages" set "authorId" = $1, "content" = $2, "description" = $3, "isPublished" = $4, "publishEndDate" = $5, "publishStartDate" = $6, "title" = $7, "extra" = $8, "updatedAt" = $9 where "id" = $10

update "pages" set "render" = $1, "toc" = $2, "updatedAt" = $3 where "id" = $4

select "path", "localeCode", "updatedAt" from "pages" where "pages"."id" = $1

BEGIN

SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
  t.typelem IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48)

insert into "pages" ("authorId", "content", "contentType", "createdAt", "creatorId", "description", "editorKey", "extra", "hash", "isPrivate", "isPublished", "localeCode", "path", "publishEndDate", "publishStartDate", "title", "toc", "updatedAt") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18) returning "id"

COMMIT

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)

SELECT nsp.nspname AS schema, rel.relname AS table, con.conname AS name, fnsp.nspname AS referenced_schema, frel.relname AS referenced_table FROM pg_catalog.pg_constraint con INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid LEFT JOIN pg_catalog.pg_class frel ON frel.oid = con.confrelid LEFT JOIN pg_catalog.pg_namespace nsp ON nsp.oid = con.connamespace LEFT JOIN pg_catalog.pg_namespace fnsp ON fnsp.oid = frel.relnamespace WHERE con.convalidated = $1 /*pghero*/

SELECT pid, state, application_name AS source, age(NOW(), COALESCE(query_start, xact_start)) AS duration, (wait_event IS NOT NULL) AS waiting, query, COALESCE(query_start, xact_start) AS started_at, EXTRACT($1 FROM NOW() - COALESCE(query_start, xact_start)) * $2 AS duration_ms, usename AS user, backend_type FROM pg_stat_activity WHERE state <> $3 AND pid <> pg_backend_pid() AND datname = current_database() AND NOW() - COALESCE(query_start, xact_start) > interval $4 AND query <> $5 ORDER BY COALESCE(query_start, xact_start) DESC /*pghero*/

update "users" set "email" = $1, "name" = $2, "pictureUrl" = $3, "updatedAt" = $4 where "users"."id" = $5

insert into "users" ("createdAt", "email", "isActive", "isSystem", "isVerified", "localeCode", "name", "pictureUrl", "providerId", "providerKey", "tfaIsActive", "updatedAt") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) returning "id"

select "parent", "ancestors" from "pageTree" where "path" = $1 and "localeCode" = $2 limit $3

select * from "pageTree" where ("localeCode" = $1 and "parent" = $2 or "id" in ($3)) order by "isFolder" desc, "title" asc

SELECT n.nspname AS schema, c.relname AS table, $1 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid)) AS transactions_left FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_class t ON c.reltoastrelid = t.oid WHERE c.relkind = $2 AND ($3 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid))) < $4 ORDER BY 3, 1, 2 /*pghero*/

select "navigation".* from "navigation" where "key" = $1

select "pages"."id", "pages"."path", "pages"."hash", "pages"."title", "pages"."description", "pages"."isPrivate", "pages"."isPublished", "pages"."privateNS", "pages"."publishStartDate", "pages"."publishEndDate", "pages"."content", "pages"."render", "pages"."toc", "pages"."contentType", "pages"."createdAt", "pages"."updatedAt", "pages"."editorKey", "pages"."localeCode", "pages"."authorId", "pages"."creatorId", "pages"."extra", "author"."name" as "authorName", "author"."email" as "authorEmail", "creator"."name" as "creatorName", "creator"."email" as "creatorEmail", "tags"."tag" as "tags:tag", "tags"."title" as "tags:title", "tags"."id" as "tags:id" from "pages" inner join "users" as "author" on "author"."id" = "pages"."authorId" inner join "users" as "creator" on "creator"."id" = "pages"."creatorId" left join "pageTags" as "tags_join" on "tags_join"."pageId" = "pages"."id" left join (select "tag", "title", "tags"."id" from "tags") as "tags" on "tags_join"."tagId" = "tags"."id" where "pages"."id" = $1

select "path", "localeCode" as "locale", "pages"."id" as "id", "tags"."tag" as "tags:tag", "tags"."id" as "tags:id" from "pages" left join "pageTags" as "tags_join" on "tags_join"."pageId" = "pages"."id" left join (select "tag", "tags"."id" from "tags") as "tags" on "tags_join"."tagId" = "tags"."id" where ("tags"."tag" ilike $1)

select "comments".* from "comments" where "pageId" = $1 order by "createdAt" asc

SELECT state, COUNT(*) AS connections FROM pg_stat_activity GROUP BY 1 ORDER BY 2 DESC, 1 /*pghero*/

select "pages"."id", "title", "description", "path", "localeCode" as "locale", "tags"."tag" as "tags:tag", "tags"."id" as "tags:id" from "pages" left join "pageTags" as "tags_join" on "tags_join"."pageId" = "pages"."id" left join (select "tag", "tags"."id" from "tags") as "tags" on "tags_join"."tagId" = "tags"."id" where ("isPublished" = $1 and ("title" ilike $2 or "description" ilike $3 or "path" ilike $4)) limit $5

insert into "pageTree" ("ancestors", "depth", "id", "isFolder", "isPrivate", "localeCode", "pageId", "parent", "path", "privateNS", "title") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11), ($12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22), ($23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33), ($34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44), ($45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55)

SELECT n.nspname AS schema, c.relname AS sequence, has_sequence_privilege(c.oid, $1) AS readable FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = $2 AND n.nspname NOT IN ($3, $4) /*pghero*/