Hi! Interesting find.
Where do they come from?
If you click on one of them, the statement details should show you the “app name” (a setting specified by the client) that ran this query. That might give you a clue.
Are they actually some kind of statement like ‘SELECT 1’ where the 1 gets sanitized?
Yes, on this page constants are normalized to
_ so that related queries show up in the same row. It probably is a SELECT 1.
Are they all generated by something internal to cockroachdb? I never notices such statements from our app.
No, CockroachDB doesn’t make these queries. However, it is pretty common for frameworks or connection pools to make “healthcheck” queries like this. Are you using any tool like that?