query("SELECT value FROM config WHERE key = 'relay_name'")->fetchColumn() ?: 'C-Relay-PG'; $relay_desc = $pdo->query("SELECT value FROM config WHERE key = 'relay_description'")->fetchColumn() ?: ''; $relay_pubkey = $pdo->query("SELECT value FROM config WHERE key = 'relay_pubkey'")->fetchColumn() ?: ''; $relay_version = $pdo->query("SELECT value FROM config WHERE key = 'relay_version'")->fetchColumn() ?: ''; } catch (PDOException $e) {} // Convert relay pubkey (hex) to npub and format into 3 lines of 3 groups of 7 chars $relay_npub = $relay_pubkey; if ($relay_pubkey && preg_match('/^[0-9a-fA-F]{64}$/', $relay_pubkey)) { $relay_npub = hex_to_npub($relay_pubkey); } // Format npub (63 chars) into 3 lines of "xxxxxxx xxxxxxx xxxxxxx" $formatted_npub = $relay_npub; if (strlen($relay_npub) === 63) { $line1 = substr($relay_npub, 0, 7) . ' ' . substr($relay_npub, 7, 7) . ' ' . substr($relay_npub, 14, 7); $line2 = substr($relay_npub, 21, 7) . ' ' . substr($relay_npub, 28, 7) . ' ' . substr($relay_npub, 35, 7); $line3 = substr($relay_npub, 42, 7) . ' ' . substr($relay_npub, 49, 7) . ' ' . substr($relay_npub, 56, 7); $formatted_npub = $line1 . "\n" . $line2 . "\n" . $line3; } $display_name = $relay_version ? ($relay_name . ' ' . $relay_version) : $relay_name; ?> C-Relay-PG Admin
R E L A Y
DATABASE STATISTICS
Loading chart...
MetricValue
Database Size-
Total Events-
Process ID-
WebSocket Connections-
Active Subscriptions-
Memory Usage-
CPU Usage-
CPU Core-
Oldest Event-
Newest Event-
Event KindCountPercentage
Loading...
PeriodEvents
Last 24 Hours-
Last 7 Days-
Last 30 Days-
RankNamePubkeyEvent CountPercentage
Loading...