Dev Portalv0.1
Dev PortaldevtoolsObservability PortalobservabilityDeployment Portaldeploy
MQorb dev · local
Dev Portal

Database

postgres 17.2 · acme_api_dev · localhost:5432
Migrations
12applied1 pending
Tables
916.6 MB
Pool
3of 10 conns0 waiting
Seed
2hagoorb seed

Migrations

cmd/migrate
  • 0013_projects_search_tsvectorpendingmigrations/0013_projects_search_tsvector.sql
  • 0012_projects_add_archived_atcmd/migrate41 ms20m ago
  • 0011_org_invites_token_hashcmd/migrate88 ms2h ago
  • 0010_river_v6river302 ms3h ago
  • 0009_audit_events_partitioncmd/migrate1204 ms3h ago
  • 0008_settings_historycmd/migrate27 ms3h ago
  • 0007_releases_instancescmd/migrate34 ms3h ago

Slow queries

from this process, over 20 ms
  • SELECT date_trunc('hour', at), count(*) FROM audit_events WHERE at > $1 GROUP BY 1241.8 ms
    12 callsGET /ops/audit/statsno index on audit_events(at)
  • SELECT * FROM org_members WHERE org_id = $1 ORDER BY joined_at148.2 ms
    61 callsGET /v1/orgs/{org}/membersSELECT * pulls the avatar blob
  • SELECT projects.* FROM projects WHERE org_id = $122.7 ms
    220 callsGET /v1/orgs/{org}/projectsno LIMIT

Tables

rows and size
  • usersseed
    42112 KB
  • sessions
    748 KB
  • orgsseed
    632 KB
  • org_membersseed
    5164 KB
  • org_invites
    316 KB
  • projectsseed
    4801.2 MB
  • audit_events
    12,3189.8 MB
  • settings
    216 KB
  • river_job
    3,1144.1 MB