steampipe plugin install francois2metz/scalingo

Table: scalingo_container_type

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

Examples

List container types of an application

select
name,
amount
from
scalingo_container_type
where
app_name = 'caresteouvert-api';

Count the number of all container types

select
sum(amount)
from
scalingo_container_type
where
app_name = 'caresteouvert-api';

Schema for scalingo_container_type

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
amountbigintAmount of containers of the given type.
app_idtextID of the application.
app_nametext=Name of the app.
commandtextCommand used to run the container.
nametextType of container (web, worker, etc.).
sizetextSize of the containers of this type (S/M/XL/..).
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.