cloudforms vmdb attributes

gistfile1.sql

/* 
psql -d vmdb_production
*/

select state,count(*) from containers group by state;
/*   state  | count 
---------+-------
 running |   297
(1 row) */

/* OR  */

select state,last_state,count(*) from containers group by state,last_state;
/*   state  | last_state | count 
---------+------------+-------
 running | terminated |     6
 running |            |   291
(2 rows) */

/* 
***************************************************
*/

/* pods */
select phase,count(*) from container_groups group by phase;
/*   phase  | count 
---------+-------
 Running |   297
(1 row) */

/* 
***************************************************
*/

select count(*) from container_images;
/*  count 
-------
 30197
(1 row)
 */
 
 /* 
***************************************************
*/

select count(*) from container_image_registries;
/*  count 
-------
     4
(1 row) */

/* 
***************************************************
*/
select count(*) from container_projects;
/*  count 
-------
    14
(1 row) */

/* 
***************************************************
*/

select count(*) from container_routes;
/*  count 
-------
     4
(1 row) */

/* 
***************************************************
*/
select count(*) from container_services;
/*  count 
-------
    27
(1 row) */

/* 
***************************************************
*/
select count(*) from container_replicators;
/*  count 
-------
    11
(1 row) */

/* 
***************************************************
*/
select count(*) from container_nodes;
/*  count 
-------
    61
(1 row) */

/* 
***************************************************
*/
select count(*) from container_templates;
/*  count 
-------
   121
(1 row) */

/* 
***************************************************
*/
select count(*) from volumes;
/*  count 
-------
     0
(1 row) */

select count(*) from container_volumes;
/*  count 
-------
   307
(1 row) */

select type,name,count(*) from container_volumes group by type,name;
/*       type       |              name               | count 
-----------------+---------------------------------+-------
 ContainerVolume | hawkular-metrics-client-secrets |     1
 ContainerVolume | router-token-y0lsn              |     1
 ContainerVolume | default-token-wps5q             |    71
 ContainerVolume | registry-storage                |     1
 ContainerVolume | hawkular-metrics-secrets        |     1
 ContainerVolume | default-token-w7929             |    60
 ContainerVolume | server-certificate              |     1
 ContainerVolume | hawkular-token-14hkv            |     1
 ContainerVolume | hawkular-metrics-certificate    |     1
 ContainerVolume | default-token-209a2             |    59
 ContainerVolume | hawkular-cassandra-secrets      |     1
 ContainerVolume | default-token-yrjm4             |    60
 ContainerVolume | cassandra-token-utjrf           |     1
 ContainerVolume | hawkular-metrics-account        |     1
 ContainerVolume | heapster-secrets                |     1
 ContainerVolume | default-token-yagte             |     1
 ContainerVolume | default-token-p5yre             |    40
 ContainerVolume | registry-certificates           |     1
 ContainerVolume | registry-token-5wds4            |     1
 ContainerVolume | cassandra-data                  |     1
 ContainerVolume | default-token-35qzg             |     1
 ContainerVolume | heapster-token-kzhit            |     1
(22 rows)
 */

/* 
***************************************************
*/
select count(*) from container_builds;
/*  count 
-------
     0
(1 row) */

/* 
***************************************************
*/

/* 
***************************************************
*/

/* 
***************************************************
*/

/* 
***************************************************
*/

/* 
***************************************************
*/