Where is the history of database queries stored on the gateway?

[papincay]

Hi everyone.

I want to know where is stored the history of the longes recent queries in the gtw or someone default table in the database?.

Ty!

[PGriffith]

The set of 'expensive' queries is only tracked in memory; if you restart the gateway the list will be purged and have to start from scratch. There's no supported way to access the information in it programmatically.

[mdemaris]

If you are using MSSQL, then you could probably look into using the Query Store.