How to Choose a ParadeDB SaaS Pricing Plan

Why How to Choose a ParadeDB SaaS Pricing Plan is important

-- Estimate current month cost for a workspace
WITH m AS (
  SELECT SUM(cluster_hours)     AS hrs,
         SUM(stored_vectors)/1e6 AS vec_m,
         SUM(egress_gb)          AS gb
  FROM   paradedb_usage
  WHERE  date_trunc('month', usage_date) = date_trunc('month', CURRENT_DATE)
), p AS (
  SELECT metric, unit_cost FROM pricing
)
SELECT (hrs      * (SELECT unit_cost FROM p WHERE metric='cluster_hour'))          +
       (vec_m    * (SELECT unit_cost FROM p WHERE metric='stored_vector_million')) +
       (gb       * (SELECT unit_cost FROM p WHERE metric='egress_gb'))             AS est_total
FROM   m;

-- ParadeDB pricing reference table
CREATE TABLE pricing (
    metric text PRIMARY KEY,
    unit_cost numeric -- USD per unit
);
-- Example rows
INSERT INTO pricing VALUES
 ('cluster_hour', 0.15),
 ('stored_vector_million', 5),
 ('egress_gb', 0.09);

-- Usage table populated by ParadeDB
CREATE TABLE paradedb_usage (
    usage_date date,
    cluster_hours numeric,
    stored_vectors bigint,
    egress_gb numeric
);

-- Stored procedure to switch plans
CALL paradedb.set_plan(plan_name text DEFAULT 'free');