steampipe 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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
app_nametext=Name of the app.
container_size_hourly_pricebigintPrice per hour of this container size in cents.
container_size_human_cputextHuman representation of the CPU priority.
container_size_human_nametextDisplay name of the type.
container_size_idtextID of the container size.
container_size_memorybigintRAM allocated to the containers in bytes.
container_size_nametextName of the size, used as parameter in operations.
container_size_ordinalbigintSorting index to display a list of sizes.
container_size_skutextStock Keeping Unit aka Products catalog ID.
container_size_thirtydays_pricebigintPrice for 30 days in cents.
created_attimestamp with time zoneCreation date of the container.
deleted_attimestamp with time zoneDeletion date of the container.
idtextID of the container.
labeltextLabel of the container.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextState of the container.
typetextType of container (web, worker, etc.).
type_indexbigintIndex number of the container for the given type.