DB01
running
POSTGRES 16 · DB01-GEI-USA · 172.31.36.53 · AZ us-east-1a
Server
- Version
- PostgreSQL 16.13 (Ubuntu 16.13-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compile
- Started
- 2026-04-23 19:15:23.683203+00
- Uptime
- 04:30:35.936123
- Instance
- t3.large
- Private IP
- 172.31.36.53
Connections
- Max
- 200
- Current
- 7
| DB | State | n |
|---|---|---|
| [server] | [idle-back] | 5 |
| gei_erp | idle | 1 |
Database sizes
| DB | Size |
|---|---|
| fleet_db | 132 MB |
| gei_erp | 116 MB |
| postgres | 7503 kB |
- Total on disk
- 256 MB
Cache hit ratio >99% = working set in RAM
| DB | Hit % | Buffer hits | Disk reads | Commits | Rollbacks | Rows returned | Inserts | Updates | Deletes |
|---|---|---|---|---|---|---|---|---|---|
| fleet_db | 98.05% | 609723 | 12149 | 2948 | 1 | 2140597 | 208043 | 790 | 3 |
| gei_erp | 99.98% | 5355970 | 1076 | 182184 | 14 | 11932011 | 238654 | 44795 | 5553 |
Top tables by size
| Schema | Table | Total | Rows |
|---|
Top tables by rows
| Schema | Table | Rows | Dead |
|---|
Active long-running queries state ≠ idle · > 200ms
| PID | Secs | DB | User | Client | State | Query |
|---|---|---|---|---|---|---|
| — no queries over 200ms · healthy | ||||||
Locks held
| Mode | Count |
|---|---|
| ExclusiveLock | 1 |
| AccessShareLock | 1 |
Vacuum candidates
| Table | Dead | Dead % |
|---|---|---|
| no dead tuples | ||
Top used indexes
| Table | Index | Scans |
|---|
WAL
- Current LSN
- 0/16557848
- Total WAL
- 357 MB
Replication
single-node · no replicas
Key settings
| Name | Value | Unit |
|---|---|---|
| checkpoint_timeout | 300 | s |
| effective_cache_size | 524288 | 8kB |
| effective_io_concurrency | 200 | |
| maintenance_work_mem | 524288 | kB |
| max_connections | 200 | |
| random_page_cost | 1.1 | |
| shared_buffers | 262144 | 8kB |
| wal_buffers | 2048 | 8kB |
| work_mem | 16384 | kB |
Host OS via ssm
Resource load
- Uptime
- 23:46:00 up 4:42, 0 user, load average: 0.03, 0.01, 0.00
- Load avg
- 0.03 0.01 0.00 1/183 15099
- Kernel
- 6.17.0-1010-aws
- Tailnet IP
- none
Memory
total used free shared buff/cache available Mem: 7.6Gi 840Mi 5.5Gi 296Mi 1.9Gi 6.8Gi Swap: 4.0Gi 0B 4.0Gi
Root disk
/dev/root 96G 6.7G 90G 7% /
Services
| Service | State |
|---|---|
| apache2 | inactive |
| caddy | inactive |
| postgresql@16-main | active |
| tailscaled | inactive |
| snap.amazon-ssm-agent.amazon-ssm-agent | active |
| fleet-db-tunnel | inactive |
| gei-admin | inactive |
Listening ports
0.0.0.0:22 0.0.0.0:5432 127.0.0.53%lo:53 127.0.0.54:53 [::]:22 [::]:5432
Top CPU processes
15086 root 30.0 0.3 ssm-document-wo
15071 root 4.9 0.3 ssm-document-wo
2337 root 0.0 0.4 ssm-agent-worke
1 root 0.0 0.1 systemd
5213 postgres 0.0 1.0 postgres
9076 root 0.0 0.5 fwupd
662 root 0.0 0.5 snapd
5214 postgres 0.0 3.1 postgres
Recent logins
reboot system boot 6.17.0-1010-aws Thu Apr 23 19:03:13 2026 still running wtmp begins Thu Apr 23 19:03:13 2026