How to set Query timeout in V19.2

HI,

How to set the query timeout in v19.2 CRDB.
How to set a long-running query for a specific folder (logs ) v19.2.

Thanks
Raj

See statement_timeout SET (session variable) | CockroachDB Docs.

1 Like

Thanks for the reply @ajwerner .

Statement_timeout for database-level right! , how to set cluster level?

please guide me for the same.

How to set a long-running query for a specific folder ( logs ) v19.2.

Thanks,
Raj

Hi @nathastilwell

Could you please guide me for the query timeout in v19.2

Thanks
Raj

Hey @Raj. Based on the docs that @ajwerner linked, I think you can use statement_timeout. So maybe something like …

SET statement_timeout = "15s";

to set a query statement timeout of 15 seconds.

1 Like

@nathastilwell @ajwerner Thanks for the help .