What the Query Log records#

The Query Log shows the statements a database is running. It answers two different questions, depending on the engine. It shows what queries Database Client itself is sending, and, for a server, what everyone connected to that server is doing.

To open it, right-click a connection in the sidebar and select Query Log.

What each engine gives you#

A SQLite file has no server and no other users. The Query Log is therefore a single live trace of the statements running through this connection. See capturing queries.

For PostgreSQL, MySQL, and SQL Server, the Query Log adds a set of sub-views, because there is a whole server to observe:

• Activity is the same live trace of your own statements.
• Server shows what every session on the server is doing right now. See server activity.
• Metrics charts the server's throughput and health over time. See server metrics.

The server sub-views only gather data while they are open, so they cost nothing when you are not looking at them.