sql: database name in crdb_internal.statement_statistics does not show up until flushed to disk #69363
Description
Reproduce in $ cockroach demo
select 1 from rides limit 1;
select metadata ->> 'db' from crdb_internal.statement_statistics where metadata ->> 'query' like 'SELECT _ FROM rides%';
-- database name is blank
set cluster setting sql.stats.flush.interval = '1s';
select metadata ->> 'db' from crdb_internal.statement_statistics where metadata ->> 'query' like 'SELECT _ FROM rides%';
-- database name shows up