steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_database_maintenance

List maintenance of databases.

You must specify app_name and addon_id in a where clause in order to use this table.

Examples

List maintenance of a database

select
  type,
  status,
  started_at
from
  scalingo_database_maintenance
where
  app_name = 'caresteouvert-api'
  and addon_id = 'ad-0c33a92f-000-000-000-0000000';

List scheduled maintenance of a database

select
  type,
  status,
  started_at
from
  scalingo_database_maintenance
where
  app_name = 'caresteouvert-api'
  and addon_id = 'ad-0c33a92f-000-000-000-0000000'
  and status = 'scheduled';

Get one maintenance

select
  type,
  status,
  started_at
from
  scalingo_database_maintenance
where
  app_name = 'caresteouvert-api'
  and addon_id = 'ad-0c33a92f-000-000-000-0000000'
  and id = '60a4ab3d406c12000eed29e7';

Schema for scalingo_database_maintenance

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
addon_id	text	=	ID of the addon.
app_name	text	=	Name of the app.
ended_at	timestamp with time zone		End date of the maintenance.
id	text	=	Unique ID identifying the maintenance.
started_at	timestamp with time zone		Start date of the maintenance.
status	text		Status of the maintenance (scheduled, notified, queued, cancelled, running, failed, done).
type	text		Type of the maintenance (no-op, failing).