RoadDB — BlackRoad Database Explorer

RoadDB

· BlackRoad Data Explorer ·

blackroad-prod ▾

📁 Tables 12 ▸

users847

sessions2.4k

events94k

agents69

deployments312

api_keys1.2k

webhooks88

orgs20

products18

routes4.7k

analytics182k

logs1.1M

📁 Views 3 ▸

active_users

event_summary

deploy_stats

📁 Functions 5 ▸

get_user_stats()

calc_ltv()

refresh_summary()

purge_old_logs()

sync_routes()

📁 Indexes 18 ▸

users_email_idx

events_user_id_idx

events_created_at_idx

sessions_user_id_idx

+ 14 more…

⊞ users ×

⌥ SQL Query ×

⊞ events ×

id	email	name	role	created_at	last_seen	status

Showing 1–20 of 847 rows …

8 rows returned in 847ms ↓ Export

id	email	name	event_count	last_event

id	user_id	event_type	payload	created_at

Showing 1–20 of 94,122 rows

Table Info

users

Rows847

Size3.2 MB

Updated2m ago

Schemapublic

Columns ▸

PKiduuid

emailtext

nametext

roletext

created_attimestamptz

last_seentimestamptz

statustext

FKorg_iduuid

metadatajsonb

Indexes ▸

users_pkey

UNIQUE · id

users_email_idx

BTREE · email

users_org_id_idx

BTREE · org_id

users_status_idx

BTREE · status

Foreign Keys ▸

org_id

→ orgs.id ON DELETE SET NULL

Recent Queries ▸

SELECT * FROM users WHERE status = 'active'

847ms · 312 rows

UPDATE users SET last_seen = NOW() WHERE id = '…'

12ms · 1 row

SELECT u.*, COUNT(e.id) FROM users u LEFT JOIN…

847ms · 8 rows

DELETE FROM sessions WHERE expires_at < NOW()

234ms · 88 rows

SELECT COUNT(*) FROM events WHERE created_at > …

56ms · 1 row

blackroad-prod · PostgreSQL 15.2 · 124ms · 20 rows · Read-only mode OFF

public · UTC

✦

Ask Orion

Ask

Type a question and Orion will write the SQL for you.