1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
|
/* beginnings of a cgroup v2 regression test */
\pset pager off
\x auto
DROP EXTENSION IF EXISTS pgnodemx;
CREATE EXTENSION pgnodemx;
SELECT cgroup_mode();
SELECT * FROM cgroup_path();
SELECT cgroup_process_count();
SELECT current_setting('pgnodemx.containerized');
SELECT current_setting('pgnodemx.cgroup_enabled');
SELECT cgroup_scalar_bigint('memory.current');
SELECT cgroup_scalar_float8('memory.current');
SELECT cgroup_scalar_text('memory.current');
SELECT cgroup_scalar_text('cgroup.type');
SELECT cgroup_scalar_bigint('memory.high');
SELECT cgroup_scalar_bigint('memory.max');
SELECT cgroup_scalar_bigint('memory.swap.current');
-- should return NULL
SELECT cgroup_scalar_bigint(null);
-- should fail
SELECT cgroup_scalar_bigint('bar/../../etc/memory.max');
-- should fail
SELECT cgroup_scalar_bigint('/memory.max');
CREATE USER pgnodemx_joe;
SET SESSION AUTHORIZATION pgnodemx_joe;
-- should fail
SELECT cgroup_scalar_bigint('memory.current');
RESET SESSION AUTHORIZATION;
DROP USER pgnodemx_joe;
SELECT cgroup_setof_bigint('cgroup.procs');
SELECT cgroup_array_text('cpu.max');
SELECT cgroup_array_bigint('cpu.max');
SELECT cgroup_array_text('cgroup.controllers');
SELECT * FROM cgroup_setof_kv('memory.stat');
SELECT * FROM cgroup_setof_kv('cgroup.events');
SELECT * FROM cgroup_setof_kv('cgroup.stat');
SELECT * FROM cgroup_setof_kv('cpu.stat');
SELECT * FROM cgroup_setof_kv('io.weight');
SELECT * FROM cgroup_setof_kv('memory.events');
SELECT * FROM cgroup_setof_kv('memory.events.local');
SELECT * FROM cgroup_setof_kv('memory.swap.events');
SELECT * FROM cgroup_setof_kv('pids.events');
SELECT * FROM cgroup_setof_nkv('memory.pressure');
SELECT * FROM cgroup_setof_nkv('io.stat');
SELECT * FROM cgroup_setof_nkv('io.pressure');
SELECT * FROM cgroup_setof_nkv('cpu.pressure');
SELECT envvar_text('PGDATA');
SELECT envvar_bigint('PGPORT');
SELECT * FROM proc_diskstats();
SELECT * FROM proc_mountinfo();
SELECT * FROM proc_meminfo();
SELECT * FROM fsinfo(current_setting('data_directory'));
SELECT pg_size_pretty(total_bytes) AS total_size,
pg_size_pretty(available_bytes) AS available_size
FROM fsinfo(current_setting('data_directory'));
SELECT * FROM proc_network_stats();
SELECT interface,
rx_bytes,
rx_packets,
tx_bytes,
tx_packets
FROM proc_network_stats();
SELECT current_setting('pgnodemx.kdapi_enabled');
SELECT * FROM kdapi_setof_kv('labels');
SELECT * FROM kdapi_scalar_bigint('cpu_limit');
SELECT * FROM kdapi_scalar_bigint('cpu_request');
SELECT * FROM kdapi_scalar_bigint('mem_limit');
SELECT * FROM kdapi_scalar_bigint('mem_request');
SELECT *
FROM proc_mountinfo() m
JOIN proc_diskstats() d USING (major_number, minor_number)
JOIN fsinfo(current_setting('data_directory')) f USING (major_number, minor_number);
SELECT "user", nice, system, idle, iowait
FROM proc_cputime();
SELECT load1, load5, load15, last_pid
FROM proc_loadavg();
WITH m (key,val) AS
(
SELECT key, val
FROM proc_meminfo()
)
SELECT
((SELECT val FROM m WHERE key = 'MemTotal') - (SELECT val FROM m WHERE key = 'MemFree')) / 1024 as memused,
(SELECT val FROM m WHERE key = 'MemFree') / 1024 AS memfree,
(SELECT val FROM m WHERE key = 'Shmem') / 1024 AS memshared,
(SELECT val FROM m WHERE key = 'Buffers') / 1024 AS membuffers,
(SELECT val FROM m WHERE key = 'Cached') / 1024 AS memcached,
((SELECT val FROM m WHERE key = 'SwapTotal') - (SELECT val FROM m WHERE key = 'SwapFree')) / 1024 AS swapused,
(SELECT val FROM m WHERE key = 'SwapFree') / 1024 AS swapfree,
(SELECT val FROM m WHERE key = 'SwapCached') / 1024 as swapcached;
SELECT
s.pid,
comm,
fullcomm,
state,
ppid,
pgrp,
session,
tty_nr,
tpgid,
flags,
minflt,
cminflt,
majflt,
cmajflt,
utime,
stime,
cutime,
cstime,
priority,
nice,
num_threads,
itrealvalue,
starttime,
vsize,
kpages_to_bytes(rss) / 1024 as rss,
exit_signal,
processor,
rt_priority,
policy,
delayacct_blkio_ticks,
uid,
username,
rchar,
wchar,
syscr,
syscw,
reads,
writes,
cwrites
FROM proc_pid_stat() s
JOIN proc_pid_cmdline() c
ON s.pid = c.pid
JOIN proc_pid_io() i
ON c.pid = i.pid;
SELECT exec_path(), * FROM stat_file(exec_path());
|
