steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_container

The scalingo_container table can be used to query information about container, and you must specify which application in the where or join clause using the app_name column.

Examples

List container of an application

select
  label,
  type,
  state
from
  scalingo_container
where
  app_name = 'caresteouvert-api';

Count the number of containers running

select
  count(*)
from
  scalingo_container
where
  app_name = 'caresteouvert-api';

Get one-off containers running

select
  label,
  state
from
  scalingo_container
where
  app_name = 'caresteouvert-api'
  and type = 'one-off';

Schema for scalingo_container

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
app_name	text	=	Name of the app.
container_size_hourly_price	bigint		Price per hour of this container size in cents.
container_size_human_cpu	text		Human representation of the CPU priority.
container_size_human_name	text		Display name of the type.
container_size_id	text		ID of the container size.
container_size_memory	bigint		RAM allocated to the containers in bytes.
container_size_name	text		Name of the size, used as parameter in operations.
container_size_ordinal	bigint		Sorting index to display a list of sizes.
container_size_sku	text		Stock Keeping Unit aka Products catalog ID.
container_size_thirtydays_price	bigint		Price for 30 days in cents.
created_at	timestamp with time zone		Creation date of the container.
deleted_at	timestamp with time zone		Deletion date of the container.
id	text		ID of the container.
label	text		Label of the container.
state	text		State of the container.
type	text		Type of container (web, worker, etc.).
type_index	bigint		Index number of the container for the given type.