Jetbrains datagrip startup queries #165
Description
2025-09-14 11:23:18.048 UTC [70] FATAL: role "sunng" does not exist
2025-09-14 11:23:26.328 UTC [71] FATAL: role "sunng" does not exist
2025-09-14 11:24:01.803 UTC [73] LOG: execute <unnamed>: SET extra_float_digits = 3
2025-09-14 11:24:01.810 UTC [73] LOG: execute <unnamed>: SET application_name = ''
2025-09-14 11:24:01.853 UTC [73] LOG: execute <unnamed>: select version()
2025-09-14 11:24:01.887 UTC [73] LOG: execute <unnamed>: SET application_name = 'DataGrip 2025.2.3'
2025-09-14 11:24:01.965 UTC [73] LOG: execute <unnamed>: select current_database() as a, current_schemas(false) as b
2025-09-14 11:24:02.019 UTC [73] LOG: execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2025-09-14 11:24:02.084 UTC [74] LOG: execute <unnamed>: SET extra_float_digits = 3
2025-09-14 11:24:02.089 UTC [74] LOG: execute <unnamed>: SET application_name = ''
2025-09-14 11:24:02.095 UTC [74] LOG: execute <unnamed>: select version()
2025-09-14 11:24:02.107 UTC [74] LOG: execute <unnamed>: SET application_name = 'DataGrip 2025.2.3'
2025-09-14 11:24:02.137 UTC [74] LOG: execute <unnamed>: select current_database() as a, current_schemas(false) as b
2025-09-14 11:24:02.163 UTC [74] LOG: execute <unnamed>: select current_database(), current_schema(), current_user
2025-09-14 11:24:02.206 UTC [74] LOG: execute <unnamed>: select round(extract(epoch from pg_postmaster_start_time() at time zone 'UTC')) as startup_time
2025-09-14 11:24:02.273 UTC [74] LOG: execute <unnamed>: select L.transactionid::varchar::bigint as transaction_id
from pg_catalog.pg_locks L
where L.transactionid is not null
order by pg_catalog.age(L.transactionid) desc
limit 1
2025-09-14 11:24:02.293 UTC [74] LOG: execute <unnamed>: select case
when pg_catalog.pg_is_in_recovery()
then null
else
(pg_catalog.txid_current() % 4294967296)::varchar::bigint
end as current_txid
2025-09-14 11:24:02.313 UTC [74] LOG: execute <unnamed>: select N.oid::bigint as id,
datname as name,
D.description,
datistemplate as is_template,
datallowconn as allow_connections,
pg_catalog.pg_get_userbyid(N.datdba) as "owner"
from pg_catalog.pg_database N
left join pg_catalog.pg_shdescription D on N.oid = D.objoid
order by case when datname = pg_catalog.current_database() then -1::bigint else N.oid::bigint end
2025-09-14 11:24:02.358 UTC [74] LOG: execute <unnamed>: select N.oid::bigint as id,
N.xmin as state_number,
nspname as name,
D.description,
pg_catalog.pg_get_userbyid(N.nspowner) as "owner"
from pg_catalog.pg_namespace N
left join pg_catalog.pg_description D on N.oid = D.objoid
order by case when nspname = pg_catalog.current_schema() then -1::bigint else N.oid::bigint end
2025-09-14 11:24:02.372 UTC [74] LOG: execute <unnamed>: SELECT typinput='pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (sel
2025-09-14 11:24:02.372 UTC [74] DETAIL: Parameters: $1 = '28'
2025-09-14 11:24:02.429 UTC [74] LOG: execute <unnamed>: show DateStyle
2025-09-14 11:24:02.449 UTC [74] LOG: execute <unnamed>: select name, is_dst from pg_catalog.pg_timezone_names
union distinct
select abbrev as name, is_dst from pg_catalog.pg_timezone_abbrevs
2025-09-14 11:24:02.658 UTC [74] LOG: execute <unnamed>: select R.oid::bigint as role_id, rolname as role_name,
rolsuper is_super, rolinherit is_inherit,
rolcreaterole can_createrole, rolcreatedb can_createdb,
rolcanlogin can_login, rolreplication /* false */ is_replication,
rolconnlimit conn_limit, rolvaliduntil valid_until,
rolbypassrls /* false */ bypass_rls, rolconfig config,
D.description
from pg_catalog.pg_roles R
left join pg_catalog.pg_shdescription D on D.objoid = R.oid
2025-09-14 11:24:02.687 UTC [74] LOG: execute <unnamed>: select member id, roleid role_id, admin_option
from pg_catalog.pg_auth_members order by id, roleid::text
2025-09-14 11:24:02.710 UTC [74] LOG: execute <unnamed>: select T.oid::bigint as id, T.spcname as name,
T.xmin as state_number, pg_catalog.pg_get_userbyid(T.spcowner) as owner,
pg_catalog.pg_tablespace_location(T.oid) /* null */ as location,
T.spcoptions /* null */ as options,
D.description as comment
from pg_catalog.pg_tablespace T
left join pg_catalog.pg_shdescription D on D.objoid = T.oid
-- where pg_catalog.age(T.xmin) <= #TXAGE
2025-09-14 11:24:02.735 UTC [74] LOG: execute <unnamed>: select T.oid as object_id,
T.spcacl as acl
from pg_catalog.pg_tablespace T
union all
select T.oid as object_id,
T.datacl as acl
from pg_catalog.pg_database T
2025-09-14 11:24:02.745 UTC [74] LOG: execute <unnamed>: SELECT typinput='pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC
2025-09-14 11:24:02.745 UTC [74] DETAIL: Parameters: $1 = '1034'
2025-09-14 11:24:02.751 UTC [74] LOG: execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
2025-09-14 11:24:02.751 UTC [74] DETAIL: Parameters: $1 = '1034'
2025-09-14 11:24:02.757 UTC [74] LOG: execute <unnamed>: SELECT e.oid, n.nspname = ANY(current_schemas(true)), n.nspname, e.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_type e ON t.typelem = e.oid JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1
2025-09-14 11:24:02.757 UTC [74] DETAIL: Parameters: $1 = '1034'
2025-09-14 11:24:02.762 UTC [74] LOG: execute <unnamed>: SELECT typinput='pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC
2025-09-14 11:24:02.762 UTC [74] DETAIL: Parameters: $1 = '1033'
2025-09-14 11:24:02.799 UTC [74] LOG: execute <unnamed>: select N.oid::bigint as id,
N.xmin as state_number,
nspname as name,
D.description,
pg_catalog.pg_get_userbyid(N.nspowner) as "owner"
from pg_catalog.pg_namespace N
left join pg_catalog.pg_description D on N.oid = D.objoid
order by case when nspname = pg_catalog.current_schema() then -1::bigint else N.oid::bigint end
2025-09-14 11:24:02.820 UTC [74] LOG: execute <unnamed>: select N.oid::bigint as id,
N.xmin as state_number,
nspname as name,
D.description,
pg_catalog.pg_get_userbyid(N.nspowner) as "owner"
from pg_catalog.pg_namespace N
left join pg_catalog.pg_description D on N.oid = D.objoid
order by case when nspname = pg_catalog.current_schema() then -1::bigint else N.oid::bigint end