Nombre de requêtes : 9
Temps SQL : 0.017694234848022 secondes
x fermer
0
SELECT version();
0.37 [7.668]
1
BEGIN TRANSACTION
1.003 [0.078]
2
SELECT
a.attnum,
n.nspname,
c.relname,
a.attname AS colname,
t.typname AS type,
a.atttypmod,
FORMAT_TYPE(a.atttypid, a.atttypmod) AS complete_type,
pg_get_expr(d.adbin, d.adrelid) AS default_value,
a.attnotnull AS notnull,
a.attlen AS length,
co.contype,
ARRAY_TO_STRING(co.conkey, ',') AS conkey
FROM pg_attribute AS a
JOIN pg_class AS c ON a.attrelid = c.oid
JOIN pg_namespace AS n ON c.relnamespace = n.oid
JOIN pg_type AS t ON a.atttypid = t.oid
LEFT OUTER JOIN pg_constraint AS co ON (co.conrelid = c.oid
AND a.attnum = ANY(co.conkey) AND co.contype = 'p')
LEFT OUTER JOIN pg_attrdef AS d ON d.adrelid = c.oid AND d.adnum = a.attnum
WHERE a.attnum > 0 AND c.relname = 'dbversion' AND n.nspname = 'intranetabi' ORDER BY a.attnum
9.073 [0.038]
3
SELECT language.*
FROM intranetabi.language WHERE "isdefaultlanguage" IS TRUE
1.733 [0.686]
4
SELECT *
FROM intranetabi.language WHERE id = '1' LIMIT 1
0.814 [0.072]
5
SELECT language.*
FROM intranetabi.language WHERE "isdefaultlanguage" IS TRUE
0.557 [3.171]
6
SELECT language.*
FROM intranetabi.language WHERE (code ILIKE 'fr')
0.999 [0.154]
7
SELECT systemuser.*
FROM intranetabi.systemuser WHERE TRUE
2.166 [5.599]
8
SELECT systemsetting.*
FROM intranetabi.systemsetting WHERE (key = 'msgraph_credential_sso')
