Metabase startup queries #158
Description
Metabase is a BI tools written in clojure
2025-09-11 14:24:55.685 UTC [70] LOG: execute <unnamed>: SET extra_float_digits = 2
2025-09-11 14:24:55.686 UTC [70] LOG: execute <unnamed>: SET application_name = 'Metabase v0.55.1 [f8f63fdf-d8f8-4573-86ea-4fe4a9548041]'
2025-09-11 14:24:55.687 UTC [70] LOG: execute <unnamed>: SELECT 1
2025-09-11 14:24:55.717 UTC [71] LOG: execute <unnamed>: SET extra_float_digits = 2
2025-09-11 14:24:55.717 UTC [72] LOG: execute <unnamed>: SET extra_float_digits = 2
2025-09-11 14:24:55.717 UTC [73] LOG: execute <unnamed>: SET extra_float_digits = 2
2025-09-11 14:24:55.717 UTC [71] LOG: execute <unnamed>: SET application_name = 'Metabase v0.55.1 [f8f63fdf-d8f8-4573-86ea-4fe4a9548041]'
2025-09-11 14:24:55.717 UTC [73] LOG: execute <unnamed>: SET application_name = 'Metabase v0.55.1 [f8f63fdf-d8f8-4573-86ea-4fe4a9548041]'
2025-09-11 14:24:55.717 UTC [72] LOG: execute <unnamed>: SET application_name = 'Metabase v0.55.1 [f8f63fdf-d8f8-4573-86ea-4fe4a9548041]'
2025-09-11 14:24:55.718 UTC [73] LOG: execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2025-09-11 14:24:55.718 UTC [72] LOG: execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2025-09-11 14:24:55.718 UTC [71] LOG: execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2025-09-11 14:24:55.722 UTC [71] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
2025-09-11 14:24:55.722 UTC [73] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
2025-09-11 14:24:55.724 UTC [71] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED
2025-09-11 14:24:55.726 UTC [72] LOG: execute <unnamed>: SELECT nspname AS "TABLE_SCHEM", current_database() AS "TABLE_CATALOG" FROM pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~ '^pg_temp_' OR nspname = (pg_catalog.current_schem
2025-09-11 14:24:55.732 UTC [73] LOG: execute <unnamed>: with table_privileges as (
select
NULL as role,
t.schemaname as schema,
t.objectname as table,
pg_catalog.has_any_column_privilege(current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'update') as update,
pg_catalog.has_any_column_privilege(current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'select') as select,
pg_catalog.has_any_column_privilege(current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'insert') as insert,
pg_catalog.has_table_privilege( current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'delete') as delete
from (
select schemaname, tablename as objectname from pg_catalog.pg_tables
union
select schemaname, viewname as objectname from pg_catalog.pg_views
union
select schemaname, matviewname as objectname from pg_catalog.pg_matviews
) t
where t.schemaname !~ '^pg_'
and t.schemaname <> 'information_schema'
and pg_catalog.has_schema_privilege(current_user, t.schemaname, 'usage')
)
select t.*
from table_privileges t
2025-09-11 14:24:55.745 UTC [72] LOG: execute <unnamed>: SELECT "n"."nspname" AS "schema", "c"."relname" AS "name", CASE "c"."relkind" WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'v' THEN 'VIEW' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END AS "type", "d"."description" AS "description", "stat"."n_live_tup" AS "estimated_row_count" FROM "pg_catalog"."pg_class" AS "c" INNER JOIN "pg_catalog"."pg_namespace" AS "n" ON "c"."relnamespace" = "n"."oid" LEFT JOIN "pg_catalog"."pg_description" AS "d" ON ("c"."oid" = "d"."objoid") AND ("d"."objsubid" = $1) AND ("d"."classoid" = 'pg_class'::regclass) LEFT JOIN "pg_stat_user_tables" AS "stat" ON ("n"."nspname" = "stat"."schemaname") AND ("c"."relname" = "stat"."relname") WHERE ("c"."relnamespace" = "n"."oid") AND ("n"."nspname" !~ $2) AND ("n"."nspname" <> $3) AND c.relkind in ('r', 'p', 'v', 'f', 'm') AND ("n"."nspname" IN ($4)) ORDER BY "type" ASC, "schema" ASC, "name" ASC
2025-09-11 14:24:55.745 UTC [72] DETAIL: Parameters: $1 = '0', $2 = '^pg_', $3 = 'information_schema', $4 = 'public'
2025-09-11 14:24:55.745 UTC [73] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED
2025-09-11 14:24:55.750 UTC [73] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
2025-09-11 14:24:55.750 UTC [73] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED
2025-09-11 14:24:55.769 UTC [73] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
2025-09-11 14:24:55.769 UTC [73] LOG: execute <unnamed>: show timezone
2025-09-11 14:24:55.769 UTC [73] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED
2025-09-11 14:29:42.757 UTC [63] LOG: checkpoint starting: time
2025-09-11 14:29:46.926 UTC [63] LOG: checkpoint complete: wrote 41 buffers (0.3%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=4.134 s, sync=0.013 s, total=4.169 s; sync files=11, longest=0.006 s, average=0.002 s; distance=317 kB, estimate=317 kB; lsn=0/17A6878, redo lsn=0/17A6820
2025-09-11 14:45:00.010 UTC [114] LOG: execute <unnamed>: SET extra_float_digits = 2
2025-09-11 14:45:00.011 UTC [114] LOG: execute <unnamed>: SET application_name = 'Metabase v0.55.1 [f8f63fdf-d8f8-4573-86ea-4fe4a9548041]'
2025-09-11 14:45:00.011 UTC [114] LOG: execute <unnamed>: SELECT 1
2025-09-11 14:45:00.013 UTC [73] LOG: execute <unnamed>: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
2025-09-11 14:45:00.016 UTC [115] LOG: execute <unnamed>: SET extra_float_digits = 2
2025-09-11 14:45:00.016 UTC [115] LOG: execute <unnamed>: SET application_name = 'Metabase v0.55.1 [f8f63fdf-d8f8-4573-86ea-4fe4a9548041]'
2025-09-11 14:45:00.016 UTC [115] LOG: execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2025-09-11 14:45:00.018 UTC [115] LOG: execute <unnamed>: SELECT nspname AS "TABLE_SCHEM", current_database() AS "TABLE_CATALOG" FROM pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~ '^pg_temp_' OR nspname = (pg_catalog.current_schemas(true))[1]) AND (nspname !~ '^pg_toast_temp_' OR nspname = replace((pg_catalog.current_schemas(true))[1], 'pg_temp_', 'pg_toast_temp_')) ORDER BY "TABLE_SCHEM"
2025-09-11 14:45:00.019 UTC [73] LOG: execute <unnamed>: with table_privileges as (
select
NULL as role,
t.schemaname as schema,
t.objectname as table,
pg_catalog.has_any_column_privilege(current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'update') as update,
pg_catalog.has_any_column_privilege(current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'select') as select,
pg_catalog.has_any_column_privilege(current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'insert') as insert,
pg_catalog.has_table_privilege( current_user, '"' || replace(t.schemaname, '"', '""') || '"' || '.' || '"' || replace(t.objectname, '"', '""') || '"', 'delete') as delete
from (
select schemaname, tablename as objectname from pg_catalog.pg_tables
union
select schemaname, viewname as objectname from pg_catalog.pg_views
union
select schemaname, matviewname as objectname from pg_catalog.pg_matviews
) t
where t.schemaname !~ '^pg_'
and t.schemaname <> 'information_schema'
and pg_catalog.has_schema_privilege(current_user, t.schemaname, 'usage')
)
select t.*
from table_privileges t
2025-09-11 14:45:00.022 UTC [115] LOG: execute <unnamed>: SELECT "n"."nspname" AS "schema", "c"."relname" AS "name", CASE "c"."relkind" WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'v' THEN 'VIEW' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END AS "type", "d"."description" AS "description", "stat"."n_live_tup" AS "estimated_row_count" FROM "pg_catalog"."pg_class" AS "c" INNER JOIN "pg_catalog"."pg_namespace" AS "n" ON "c"."relnamespace" = "n"."oid" LEFT JOIN "pg_catalog"."pg_description" AS "d" ON ("c"."oid" = "d"."objoid") AND ("d"."objsubid" = $1) AND ("d"."classoid" = 'pg_class'::regclass) LEFT JOIN "pg_stat_user_tables" AS "stat" ON ("n"."nspname" = "stat"."schemaname") AND ("c"."relname" = "stat"."relname") WHERE ("c"."relnamespace" = "n"."oid") AND ("n"."nspname" !~ $2) AND ("n"."nspname" <> $3) AND c.relkind in ('r', 'p', 'v', 'f', 'm') AND ("n"."nspname" IN ($4)) ORDER BY "type" ASC, "schema" ASC, "name" ASC
2025-09-11 14:45:00.022 UTC [115] DETAIL: Parameters: $1 = '0', $2 = '^pg_', $3 = 'information_schema', $4 = 'public'