PgHero

Live Queries

6 queries

Pid Duration State
1921538 00:08:26 active
cims1
SELECT     "personnels".* FROM       "personnels"  WHERE     (status ='Active')
2023139 0.0 s active
/opt/pghero/vendor/bundle/ruby/3.1.0/bin/puma pghero
SELECT captured_at, size AS size_bytes FROM pghero_space_stats WHERE database = 'primary' AND captured_at >= '2026-03-01 15:15:03.070327' AND schema = 'public' AND relation = 'workflow_workflowinstance' ORDER BY 1 ASC /*pghero*/
2023138 0.0 s active
/opt/pghero/vendor/bundle/ruby/3.1.0/bin/puma pghero
SELECT captured_at, size AS size_bytes FROM pghero_space_stats WHERE database = 'primary' AND captured_at >= '2026-03-01 15:15:03.070327' AND schema = 'public' AND relation = 'workflow_workflowinstance' ORDER BY 1 ASC /*pghero*/
2023137 0.0 s active
/opt/pghero/vendor/bundle/ruby/3.1.0/bin/puma pghero
SELECT captured_at, size AS size_bytes FROM pghero_space_stats WHERE database = 'primary' AND captured_at >= '2026-03-01 15:15:03.070327' AND schema = 'public' AND relation = 'workflow_workflowinstance' ORDER BY 1 ASC /*pghero*/
2006840 0.0 s active
/opt/pghero/vendor/bundle/ruby/3.1.0/bin/puma pghero
SELECT captured_at, size AS size_bytes FROM pghero_space_stats WHERE database = 'primary' AND captured_at >= '2026-03-01 15:15:03.070327' AND schema = 'public' AND relation = 'workflow_workflowinstance' ORDER BY 1 ASC /*pghero*/
2017242 -0.0 s active
/opt/pghero/vendor/bundle/ruby/3.1.0/bin/puma pghero
SELECT n.nspname AS schema, c.relname AS relation, CASE c.relkind WHEN 'r' THEN 'table' WHEN 'm' then 'matview' ELSE 'index' END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'm', 'i') ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/

You may need to restart your app servers afterwards.