Request and download logs

Aura allows you to request and download security and query logs.

You can access logs from an Aura instance via the Logs tab.

To access the Logs tab:

Query logs

A query log provides a log of queries executed on an instance within a specified time range.

Queries that complete successfully within 50 ms are not logged.

To request a query log from the Logs tab:

Requested logs will appear for up to 7 days, at which point they will expire and be removed.

You can select from the following time ranges when requesting a query log:

We recommend shorter time ranges for busy, read/write heavy instances to reduce request time.

Aura will generate a query log for your selected time range, available to download once the Status shows Completed.

You can download query logs by selecting the download icon on the right-hand side of the log entry.

Downloaded query logs take the form of a zipped JSON file that, when extracted, contains the following information:

Table 1. Query log entries
Name	Description
`allocatedBytes`	The number of bytes allocated by the query.
`annotationData`	The metadata attached to the transaction.
`authenticatedUser`	The name of the user who executed the query (whose credentials were used to log in).
`database`	The name of the database the query was executed on.
`dbid`	The ID of the instance the query was executed on.
`elapsedTimeMs`	The time the query took to complete in milliseconds.
`event`	The query event: `start` - The query was successfully parsed, awaiting execution. `fail` - The query failed to either parse or execute. `success` - The query executed successfully or was canceled.
`executingUser`	The name of the user who executed the query either through authentication (`authenticatedUser`) or through impersonation.
`id`	The ID of the query.
`message`	The log message: a truncated version of `query`.
`pageFaults`	The number of page faults resulting from the query.
`pageHits`	The number of page hits resulting from the query.
`query`	The full query text.
`runtime`	The Cypher runtime used to execute the query.
`type`	The type of log message.
`time`	The timestamp of the log message.

AuraDB Virtual Dedicated Cloud AuraDS Enterprise

A security log provides a log of all the security events that have occurred on an instance within a specified time range.

Security events include:

To request a security log from the Logs tab:

Requested logs will appear for up to 7 days, at which point they will expire and be removed.

You can select from the following time ranges when requesting a security log:

Aura will generate a security log for your selected time range, available to download once the Status shows Completed.

You can download security logs by selecting the download icon on the right-hand side of the log entry.

Downloaded security logs take the form of a zipped JSON file that, when extracted, contains the following information:

Table 2. Security log entries
Name	Description
`authenticatedUser`	The name of the user who executed the security event (whose credentials were used to log in).
`dbid`	The ID of the instance the security event occurred on.
`executingUser`	The name of the user who executed the security event either through authentication (`authenticatedUser`) or through impersonation.
`message`	The log message.
`type`	The type of log message.
`time`	The timestamp of the log message.