Skip to content

Jetbrains datagrip startup queries #165

@sunng87

Description

@sunng87
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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions