| Name | Alias | Host | Port | User | SSL Mode | Uptime | Size | Version |
|---|---|---|---|---|---|---|---|---|
| fort_cloud_prod | default | ec2-54-159-152-221.compute-1.amazonaws.com | 5432 | admin_panel | disable | 5d 10h 16m | n/a | 17.5 (Ubuntu 17.5-1.pgdg22.04+1) |
| fort_nkm | site_db | 143.105.208.105 | 2050 | admin_panel | disable | 7d 10h 29m | n/a | 17.5 (Ubuntu 17.5-1.pgdg24.04+1) |
| App | Client | Started | State | Sync | Reply Time | Byte Lag |
|---|---|---|---|---|---|---|
| 17/cloud_prod | None | None | None | None | None | 0 |
| fort_cloud_prod_fort_nkm | None | None | None | None | None | 0 |
| 17/nkm_prod | None | None | None | None | None | 0 |
| fort_nkm | None | None | None | None | None | 0 |
| Status | Start LSN | Recv LSN | Last Send | Last Receipt |
|---|---|---|---|---|
| No WAL receiver running. | ||||
Active: 1 | Idle: 15 | Total: 26
| PID | User | Duration | Query |
|---|---|---|---|
| 3684431 | admin_panel | 0:00:00 |
SELECT pid, usename, now() - q… |
Cache Hit Ratio: 100.0%
Slow Queries (>500 ms avg): 2
Deadlocks: 0
| Alias | Database | Size |
|---|---|---|
| default | fort_cloud_prod | 14 GB |
| site_db | fort_nkm | 21 GB |
| Slot | Plugin | Type | Active |
|---|---|---|---|
| slot_readonly_replica | None | physical | ✅ |
| to_fort_nkm | pgoutput | logical | ✅ |
Default DB Connect: OK
Site DB Connect: OK
| Table | Last Vacuum | Last AutoVac | Dead Rows |
|---|---|---|---|
| report_run | None | None | 0 |
| komtrax_fleet_1 | None | None | 0 |
| question | None | None | 0 |
| report_component | None | None | 0 |
| prestart_checklist_result_1 | None | None | 0 |
| fleet | None | None | 16 |
| mineplan | None | Sept. 16, 2025, 11:29 a.m. | 0 |
| health_event_ref | None | Aug. 1, 2025, 11:37 a.m. | 0 |
| circuit_type_rule | None | None | 0 |
| login_history | None | Sept. 21, 2025, 8:47 a.m. | 146 |
| pg_stat_statements_20250918 | None | None | 0 |
| alert_1 | None | None | 0 |
| event | None | None | 0 |
| event_2 | None | None | 7 |
| route_vertices | None | None | 0 |
| country | None | None | 1 |
| komtrax_fleet_1 | None | None | 0 |
| alert | None | None | 0 |
| gps_last_1 | None | None | 0 |
| obh | None | None | 13 |
| task | None | None | 0 |
| action_1 | None | None | 0 |
| route_edges_raw | None | None | 0 |
| location_role | None | None | 0 |
| komtrax_event_1 | None | None | 0 |
| obs | None | None | 0 |
| alert_type | None | None | 0 |
| role_app_permissions | None | None | 0 |
| action | None | None | 0 |
| general_config_value | None | None | 0 |
| health_tag_ref | None | None | 6 |
| alert_2 | None | Sept. 19, 2025, 7:17 p.m. | 0 |
| gps_last | None | None | 0 |
| task_type | None | None | 0 |
| message | None | None | 0 |
| site | None | None | 4 |
| general_config_option | None | None | 0 |
| komtrax_fleet_2 | None | None | 0 |
| gps_last_2 | None | Sept. 23, 2025, 3:24 p.m. | 103 |
| task_2 | None | Sept. 20, 2025, 8:53 a.m. | 85 |
| action_2 | None | Sept. 17, 2025, 10:50 a.m. | 12183 |
| event_haul | None | None | 0 |
| komtrax_fleet | None | None | 0 |
| alert_config | None | None | 0 |
| obs_deployment | None | None | 0 |
| alert_config | None | None | 0 |
| load_2 | None | Sept. 23, 2025, 2:56 p.m. | 1817 |
| general_config_category | None | None | 0 |
| event_1 | None | None | 0 |
| loader_shift_cycle_1 | None | None | 0 |
| model_type | None | None | 0 |
| loader_shift_cycle_2 | None | Sept. 23, 2025, 3:07 a.m. | 43 |
| material | None | None | 0 |
| material_type | None | None | 0 |
| tum_status | None | None | 0 |
| loader_shift_cycle | None | None | 0 |
| load | None | None | 0 |
| location_type | None | None | 0 |
| app_modules | None | None | 0 |
| tum_category | None | None | 0 |
| can_tag_1 | None | None | 0 |
| report_template | None | None | 0 |
| load_1 | None | None | 0 |
| event_haul_1 | None | None | 0 |
| komtrax_event_2 | None | None | 0 |
| scheduled_report | None | None | 0 |
| task_1 | None | None | 0 |
| report | None | None | 0 |
| can_tag | None | None | 0 |
| event_haul_2 | None | Sept. 22, 2025, 9:01 a.m. | 0 |
| obs_package | None | None | 0 |
| prestart_checklist_result | None | None | 0 |
| user | None | Sept. 23, 2025, 4:26 a.m. | 52 |
| prestart_checklist | None | None | 0 |
| model | None | None | 0 |
| model_specification | None | None | 0 |
| prestart_checklist_result_2 | None | None | 0 |
| route_edges | None | Sept. 22, 2025, 11:25 p.m. | 0 |
| komtrax_fleet_2 | None | None | 0 |
| user_role | None | Sept. 9, 2025, 5:10 a.m. | 0 |
| can_tag_2 | None | Sept. 19, 2025, 11:46 p.m. | 2 |
| location | None | None | 18 |
| komtrax_fleet | None | None | 0 |
| organization | None | None | 0 |
| spatial_ref_sys | None | Aug. 1, 2025, 11:34 a.m. | 0 |
| komtrax_event | None | None | 0 |
| message_2 | None | Sept. 19, 2025, 7:10 a.m. | 0 |
| message_1 | None | None | 0 |