User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
Log

Log Panel

The Log page shows the 500 most recent system log messages generated by your Looker instance. To view the Log page, from the Server section of the Admin menu, select Log.

  1. To limit the information shown in the Log window, you can enter text in the Filter field, and the Log window will show only those messages that include the text you entered.
  2. Click Refresh Log to update the log and show the most recent 500 messages.
  3. You can adjust the severity level of log messages that will be shown for various Looker services. This is explained in more detail below.

The Log window is not the best way to look at usage or user history. Instead, if you have enabled the System Activity Labs feature, see the Creating Looker Usage Reports with System Activity Explores documentation page. Otherwise, check out our Creating Looker Usage and Metadata Reports with i__looker documentation page.

Log Levels

The Log Levels section lets you set the minimum severity level required for a message to show up in the log, for several different Looker services. This allows you to hide log information that does not interest you.

The default severity level for the db:* and db:looker services is set to info, which means SQL statements containing or filtering on personal information (for example, a customer name) are logged by Looker. This is true for severity settings of info, verbose, or debug. To turn off logging of SQL statements, set the severity level of the db:* and db:looker services to warn, error, or fatal.

Looker logs SQL statements both to our internal database (where we store metadata for Looker objects created by users) and to our external databases (where we store customer data and metadata).

Severity Descriptions

Log message severity levels are listed below, from least severe to most severe:

Service Descriptions

The Master Level drop-down sets the minimum severity level for all the Looker services. You can also set severity levels individually for each Looker service, but you won’t see messages that have a lower severity than the Master Level setting.

For example, if you have set the Master Level to warn, and set the db service to info, you will only see messages with a severity of warn or higher, since that is the setting of Master Level. But, if Master Level is set to warn and you set the db service to error, you will only see messages sent by the db service that have a severity of error or higher.

You can set the log level of messages generated by the following services:

After you have modified the log level for a service, click Set Levels to save your changes.

Setting the Log Format on Customer-Hosted Instances

By default, system messages are displayed in text using the following format:

2019-09-25 15:14:12.301 -0700 [INFO|007d0|main] :: Starting Looker : Version 6.21.0-localdev-ea88a4
...
2019-10-01 14:37:53.424 -0700 [INFO|0002a|http] :: Request from 0:0:0:0:0:0:0:1  GET /folders/1, {}
...
2019-10-01 14:37:53.425 -0700 [INFO|0002a|db:looker] :: (0.000180s) SELECT count(*) AS "COUNT" FROM "USER" LIMIT 1

Some system messages, such as exceptions and SQL queries, are generated as multiple-line output. This can cause problems for log processors that require single-line entries for pattern matching.

If your Looker instance is customer hosted and you require single-line output, you can use the --log-format=json startup option to format log entries into single-line JSON structures. The example below shows the same events as above, but in the JSON format:

{"t":"2019-09-25 15:14:56.513 -0700","s":"INFO","rid":"007d0","c":"main","msg":"Starting Looker : Version 6.21.0-localdev-ea88a4"}
...
{"t":"2019-10-01T14:35:37.577 -07:00","s":"INFO","rid":"0002c","c":"http","ip":"0:0:0:0:0:0:0:1","verb":"GET","path":"/folders/1","params":{}}
...
{"t":"2019-10-01T14:35:37.581 -07:00","s":"INFO","rid":"0002c","c":"db:looker","duration":"0.000344","sql":"SELECT count(*) AS \"COUNT\" FROM \"USER\" LIMIT 1"}

Top