Table: steampipecloud_workspace_db_log

Database logs records the underlying queries executed when a user executes a query.

Examples

List db logs for an actor by handle

select
  id,
  workspace_id,
  workspace_handle,
  duration,
  query,
  log_timestamp
from
  steampipecloud_workspace_db_log
where
  actor_handle = 'siddharthaturbot';

List db logs for an actor by handle in a particular workspace

select
  id,
  workspace_id,
  workspace_handle,
  duration,
  query,
  log_timestamp
from
  steampipecloud_workspace_db_log
where
  actor_handle = 'siddharthaturbot'
  and workspace_handle = 'dev';

List queries that took more than 30 seconds to execute

select
  id,
  workspace_id,
  workspace_handle,
  duration,
  query,
  log_timestamp
from
  steampipecloud_workspace_db_log
where
  duration > 30000;

List all queries that ran in my workspace in the last hour

select
  id,
  workspace_id,
  workspace_handle,
  duration,
  query,
  log_timestamp
from
  steampipecloud_workspace_db_log
where
  workspace_handle = 'dev'
  and log_timestamp > now() - interval '1 hr';

Schema for steampipecloud_workspace_db_log

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
actor_avatar_url	text	The avatar of the user who executed the query.
actor_display_name	text	The display name of the user who executed the query.
actor_handle	text	The handle of the user who executed the query.
actor_id	text	The unique identifier for the user who executed the query.
created_at	text	The time when the db log record was generated.
duration	double precision	The duration of the query in milliseconds(ms).
id	text	The unique identifier for a db log.
log_timestamp	timestamp with time zone	The time when the log got captured in postgres.
query	text	The query that was executed in the workspace.
workspace_handle	text	The handle of the workspace on which the query was executed.
workspace_id	text	The unique identifier of the workspace on which the query was executed.