public.node_stats

Description

Aggregated statistics by node type showing counts, importance, tokens, and age ranges.

Table Definition

CREATE VIEW node_stats AS (
 SELECT type,
    count(*) AS count,
    avg(importance) AS avg_importance,
    sum(token_count) AS total_tokens,
    min(created_at) AS oldest,
    max(created_at) AS newest
   FROM nodes
  GROUP BY type
)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
type	text		true
count	bigint		true
avg_importance	double precision		true
total_tokens	bigint		true
oldest	timestamp with time zone		true
newest	timestamp with time zone		true

Referenced Tables

Name	Columns	Comment	Type
public.nodes	14	Core memory storage for conversation messages and context	BASE TABLE

Relations

---

Generated by tbls