Consolidated signals from the Supabase database, the embedder background worker, and the Node.js server. Color-coded so you can tell at a glance whether anything needs attention.
No signals tripping. Everything within normal operating ranges.
Nothing tripping. ✨
| case_embeddings | 407.2 MB | 41,096 |
| cases | 116.9 MB | 13,908 |
| source_pdfs | 5.9 MB | 9,426 |
| parties | 5.2 MB | 31,919 |
| embedding_jobs | 3.0 MB | 13,908 |
| motion_types | 2.2 MB | 15,947 |
| qa_shared_memos | 1.3 MB | 107 |
| monetary_amounts | 992.0 KB | 4,212 |
| Query | Mean | Calls | % Total |
|---|---|---|---|
| WITH pgrst_source AS (SELECT "pgrst_call".* FROM (SELECT $1 AS json_data) pgrst_payload, LATERAL (SELECT "p_case_id", "match_limit" FROM json_to_record(pgrst_payload.json_data) AS _("p_case_id" bigint | 5.39ms | 16,498 | 25% |
| WITH pgrst_source AS ( SELECT "public"."motion_types"."motion_type", row_to_json("motion_types_cases_1".*)::jsonb AS "cases" FROM "public"."motion_types" INNER JOIN LATERAL ( SELECT "cases_1"."county_ | 33.72ms | 1,866 | 17.7% |
| WITH pgrst_source AS ( SELECT "public"."cases".*, COALESCE( "cases_attorneys_1"."cases_attorneys_1", $14) AS "attorneys", COALESCE( "cases_parties_1"."cases_parties_1", $15) AS "parties", COALESCE( "c | 0.51ms | 21,025 | 3% |
| WITH pgrst_source AS ( SELECT "public"."cases".* FROM "public"."cases" WHERE "public"."cases"."county_id" = $1 AND "public"."cases"."division" = $2 AND "public"."cases"."ruling" ilike $3 AND "publ | 12.97ms | 747 | 2.7% |
| WITH pgrst_source AS (SELECT pgrst_call.pgrst_scalar FROM (SELECT "public"."refresh_coverage_materialized_views"() pgrst_scalar) pgrst_call) SELECT $3::bigint AS total_result_set, $4 AS page_total, co | 45.49ms | 189 | 2.4% |
| WITH pgrst_source AS ( SELECT "public"."cases".* FROM "public"."cases" WHERE "public"."cases"."division" = $1 AND "public"."cases"."ruling" ilike $2 AND "public"."cases"."appearance_required" = $3 | 50.37ms | 166 | 2.3% |
| WITH pgrst_source AS ( SELECT "public"."cases".* FROM "public"."cases" WHERE "public"."cases"."division" = $1 AND "public"."cases"."ruling" ilike $2 AND "public"."cases"."appearance_required" = $3 | 41.63ms | 176 | 2.1% |
| WITH pgrst_source AS ( SELECT "public"."cases".* FROM "public"."cases" WHERE "public"."cases"."division" = $1 AND "public"."cases"."appearance_required" = $2 ORDER BY "public"."cases"."ingested_at" | 56.19ms | 125 | 2% |
| WITH pgrst_source AS ( SELECT "public"."motion_types"."case_id" FROM "public"."motion_types" WHERE "public"."motion_types"."motion_type" ilike $1 LIMIT $2 OFFSET $3 ) SELECT $4::bigint AS total_re | 17.21ms | 399 | 1.9% |
| WITH pgrst_source AS ( SELECT "public"."cases".* FROM "public"."cases" WHERE "public"."cases"."division" = $1 AND "public"."cases"."ruling" ilike $2 AND "public"."cases"."appearance_required" = $3 | 38.75ms | 137 | 1.5% |
| WITH pgrst_source AS ( SELECT "public"."cases".* FROM "public"."cases" WHERE "public"."cases"."county_id" = $1 ORDER BY "public"."cases"."hearing_date" DESC NULLS LAST LIMIT $2 OFFSET $3 ) , pgrst_s | 20.41ms | 254 | 1.5% |
| WITH pgrst_source AS ( SELECT "public"."cases".* FROM "public"."cases" WHERE "public"."cases"."county_id" = $1 AND "public"."cases"."division" = $2 AND "public"."cases"."prevailing_party" = $3 AND | 8.91ms | 501 | 1.3% |
| Table | Seq scans | Idx scans | Seq % |
|---|---|---|---|
| cases | 21,542 | 119,102,888 | 0% |
| embedding_jobs | 28,770 | 111,969 | 20.4% |
| motion_types | 14,042 | 1,390,391 | 1% |
| source_pdfs | 1,343 | 76,597 | 1.7% |
| case_embeddings | 14 | 417,415 | 0% |
| attorneys | 10 | 106,167 | 0% |
| monetary_amounts | 4 | 100,462 | 0% |
| causes_of_action | 4 | 100,466 | 0% |
| parties | 3 | 100,468 | 0% |
| case_embeddings | 99.90% |
| cases | 99.99% |
| source_pdfs | 98.12% |
| parties | 97.46% |
| embedding_jobs | 99.95% |
| motion_types | 99.90% |
| monetary_amounts | 96.75% |
| attorneys | 99.76% |
| causes_of_action | 97.08% |
| counties | 99.93% |
No queries running > 5 seconds. 🟢
No alerts have fired yet.