public.robot_activity

Description

Robot usage metrics showing total nodes created and last activity timestamp.

Table Definition

CREATE VIEW robot_activity AS (
 SELECT r.id,
    r.name,
    count(n.id) AS total_nodes,
    max(n.created_at) AS last_node_created
   FROM (robots r
     LEFT JOIN nodes n ON ((n.robot_id = r.id)))
  GROUP BY r.id, r.name
)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	text		true
name	text		true
total_nodes	bigint		true
last_node_created	timestamp with time zone		true

Referenced Tables

Name	Columns	Comment	Type
public.robots	5	Registry of all LLM robots using the HTM system	BASE TABLE
public.nodes	14	Core memory storage for conversation messages and context	BASE TABLE

Relations

---

Generated by tbls