pgCluu :: pgCluu

Cluster

Wed Jun 28 09:26:17 2023 to Wed Jun 28 10:00:20 2023

off Data checksums
1.55 GB Cluster size
4 Databases
1152 Connections
76184449 Tuples returned
75% Hit cache ratio
1 Unlogged tables (gilles)
0 Invalid indexes
0 Hash indexes
0 Deadlocks
2023-06-14 09:35:44+02 Last bgwriter stats reset

Databases

1.53 GB Largest database
(pgbench)
950 Most connections
(pgbench)
42575582 Most tuples returned
(pgbench)
74% Worst cache utilization
(pgbench)
3 Extensions (credcheck-2.0.0, plpgsql-1.0, pgtt-2.10.0)

System

Wed Jun 28 09:26:17 2023 to Wed Jun 28 10:00:19 2023

69.56% Highest CPU utilization
(Wed Jun 28 09:29:09 2023)
4.84 Highest system load
(Wed Jun 28 09:34:19 2023)
9 Highest blocked processes
(Wed Jun 28 09:58:31 2023)
0 ms Highest device wait time
(unknown on device unknown)
394.41 MB Lowest system cache
(Wed Jun 28 09:26:17 2023)
7.79 GB Highest dirty memory
(Wed Jun 28 09:28:19 2023)
0 Most read device
(unknown)
0 Most written device
(unknown)
0 Highest tps on device
(unknown)

Archiver

0 Last archived wal
0 Last archived time
0 Last failed wal
0 Last failed time
2023-06-14 09:35:44 Last stats reset

Packages

rc  pgdg-keyring                                  2018.2                                  all          keyring for apt.postgresql.org
ii  postgresql-12                                 12.15-1.pgdg22.04+1                     amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-13                                 13.11-1.pgdg22.04+1                     amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-14                                 14.8-1.pgdg22.04+1                      amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-14-hypopg                          1.3.1-2.pgdg22.04+1                     amd64        PostgreSQL extension adding support for hypothetical indexes.
ii  postgresql-14-postgis-3                       3.3.3+dfsg-1.pgdg22.04+1                amd64        Geographic objects support for PostgreSQL 14
ii  postgresql-14-postgis-3-scripts               3.3.3+dfsg-1.pgdg22.04+1                all          Geographic objects support for PostgreSQL 14 -- SQL scripts
ii  postgresql-15                                 15.3-1.pgdg22.04+1                      amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-15-postgis-3                       3.3.3+dfsg-1.pgdg22.04+1                amd64        Geographic objects support for PostgreSQL 15
ii  postgresql-15-postgis-3-scripts               3.3.3+dfsg-1.pgdg22.04+1                all          Geographic objects support for PostgreSQL 15 -- SQL scripts
ii  postgresql-client-12                          12.15-1.pgdg22.04+1                     amd64        front-end programs for PostgreSQL 12
ii  postgresql-client-13                          13.11-1.pgdg22.04+1                     amd64        front-end programs for PostgreSQL 13
ii  postgresql-client-14                          14.8-1.pgdg22.04+1                      amd64        front-end programs for PostgreSQL 14
ii  postgresql-client-15                          15.3-1.pgdg22.04+1                      amd64        front-end programs for PostgreSQL 15
ii  postgresql-client-common                      250.pgdg22.04+1                         all          manager for multiple PostgreSQL client versions
ii  postgresql-common                             250.pgdg22.04+1                         all          PostgreSQL database-cluster manager
ii  postgresql-contrib                            15+250.pgdg22.04+1                      all          additional facilities for PostgreSQL (supported version)
ii  postgresql-plperl-14                          14.8-1.pgdg22.04+1                      amd64        PL/Perl procedural language for PostgreSQL 14
ii  postgresql-postgis                            3.3.3+dfsg-1.pgdg22.04+1                amd64        Geographic objects support for PostgreSQL -- Metapackage
ii  postgresql-postgis-scripts                    3.3.3+dfsg-1.pgdg22.04+1                all          Geographic objects support for PostgreSQL -- SQL scripts metapackage
ii  postgresql-server-dev-12                      12.15-1.pgdg22.04+1                     amd64        development files for PostgreSQL 12 server-side programming
ii  postgresql-server-dev-13                      13.11-1.pgdg22.04+1                     amd64        development files for PostgreSQL 13 server-side programming
ii  postgresql-server-dev-14                      14.8-1.pgdg22.04+1                      amd64        development files for PostgreSQL 14 server-side programming
ii  postgresql-server-dev-15                      15.3-1.pgdg22.04+1                      amd64        development files for PostgreSQL 15 server-side programming

About pgCluu

pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster. It is divided in two parts, a collector used to grab statistics on the PostgreSQL cluster using psql and sysstat, a grapher that will generate all HTML output. It is fully open source and free of charge.

License

pgCluu is licenced under the PostgreSQL Licence a liberal Open Source license, similar to the BSD or MIT licenses.

That mean that all parts of the program are open source and free of charge.

This is the case for both, the collector and the grapher programs.

Download

Official releases at SourceForge:
[ http://sourceforge.net/projects/pgcluu/ ].

Source code at github:
[ https://github.com/darold/pgcluu ].

ChangeLog can be read on-line on GitHub repository here
Offical web site is hosted at pgcluu.darold.net

Authors

pgCluu is an original development of Gilles Darold.

Some parts of the collector are taken from pgstats a C program writen by Guillaume Lelarge and especially the SQL queries including the compatibility with all PostgreSQL versions.

Btw pgCluu grapher is compatible with files generated by pgstats, sar and sadc so you can use it independently to graph those data. Some part of the sar output parser are taken from SysUsage

System

OS information

10:00:20 up 1 day Uptime
inspiron-14 Hostname
Linux 5.19.0-45-generic #46~22.04.1-Ubuntu SMP Kernel
x86_64 GNU/Linux Arch
Ubuntu Distribution
22.04.2 LTS (Jammy Jellyfish) Version

Kernel

/sys/kernel/mm/transparent_hugepage/

defrag never
enabled never
khugepaged/defrag 1

sysctl parameters

sched_autogroup_enabled 1
net.ipv4.tcp_keepalive_intvl 75
net.ipv4.tcp_keepalive_probes 9
net.ipv4.tcp_keepalive_time 7200
vm.dirty_background_bytes 0
vm.dirty_background_ratio 10
vm.dirty_bytes 0
vm.dirty_ratio 20
vm.nr_hugepages 0
vm.nr_overcommit_hugepages 0
vm.overcommit_kbytes 0
vm.overcommit_memory 0
vm.overcommit_ratio 50
vm.swappiness 60
vm.zone_reclaim_mode 0

CPU

CPUs information

11th Gen Intel(R) Core(TM) i7-11390H
2900.000 Speed
12288 KB Cache
2 Sockets
4 Cores per CPU
8 Cores
scaling_governor powersave

Memory

Memory information

15.00 GB Total memory
1.63 GB Free memory
404.46 MB Buffers
9.24 GB Cached
957.03 MB Total swap
957.03 MB Free swap
36.86 MB Page Tables
788.09 MB Shared memory

sysctl parameters

16384.00 PB kernel.shmmax
67108864.00 PB kernel.shmall

Filesystem

Filesystem Size Used Free Use% Mount

/dev/mapper/vgubuntu-root 466G 408G 35G 93% /

/dev/nvme0n1p2 1,7G 286M 1,3G 19% /boot

/dev/nvme0n1p1 511M 44M 468M 9% /boot/efi

Filesystem	Size	Used	Free	Use%	Mount
/dev/mapper/vgubuntu-root	466G	408G	35G	93%	/
/dev/nvme0n1p2	1,7G	286M	1,3G	19%	/boot
/dev/nvme0n1p1	511M	44M	468M	9%	/boot/efi

Process list

USER	PID	%CPU	%MEM	VSZ	RSS	TTY	STAT	START	TIME	COMMAND
root	2	0.0	0.0	0	0	?	S	juin27	0:00	[kthreadd]
root	3	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [rcu_gp]
root	4	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [rcu_par_gp]
root	5	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [slub_flushwq]
root	6	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [netns]
root	8	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/0:0H-events_highpri]
root	10	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [mm_percpu_wq]
root	11	0.0	0.0	0	0	?	I	juin27	0:00	\_ [rcu_tasks_kthread]
root	12	0.0	0.0	0	0	?	I	juin27	0:00	\_ [rcu_tasks_rude_kthread]
root	13	0.0	0.0	0	0	?	I	juin27	0:00	\_ [rcu_tasks_trace_kthread]
root	14	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ksoftirqd/0]
root	15	0.0	0.0	0	0	?	I	juin27	0:37	\_ [rcu_preempt]
root	16	0.0	0.0	0	0	?	S	juin27	0:00	\_ [migration/0]
root	17	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/0]
root	19	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/0]
root	20	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/1]
root	21	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/1]
root	22	0.0	0.0	0	0	?	S	juin27	0:00	\_ [migration/1]
root	23	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ksoftirqd/1]
root	25	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/1:0H-events_highpri]
root	26	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/2]
root	27	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/2]
root	28	0.0	0.0	0	0	?	S	juin27	0:06	\_ [migration/2]
root	29	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ksoftirqd/2]
root	31	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/2:0H-events_highpri]
root	32	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/3]
root	33	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/3]
root	34	0.0	0.0	0	0	?	S	juin27	0:17	\_ [migration/3]
root	35	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ksoftirqd/3]
root	37	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/3:0H-events_highpri]
root	38	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/4]
root	39	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/4]
root	40	0.0	0.0	0	0	?	S	juin27	0:12	\_ [migration/4]
root	41	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ksoftirqd/4]
root	43	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/4:0H-events_highpri]
root	44	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/5]
root	45	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/5]
root	46	0.0	0.0	0	0	?	S	juin27	0:11	\_ [migration/5]
root	47	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ksoftirqd/5]
root	49	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/5:0H-events_highpri]
root	50	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/6]
root	51	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/6]
root	52	0.0	0.0	0	0	?	S	juin27	0:12	\_ [migration/6]
root	53	0.0	0.0	0	0	?	S	juin27	0:07	\_ [ksoftirqd/6]
root	55	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/6:0H-kblockd]
root	56	0.0	0.0	0	0	?	S	juin27	0:00	\_ [cpuhp/7]
root	57	0.0	0.0	0	0	?	S	juin27	0:00	\_ [idle_inject/7]
root	58	0.0	0.0	0	0	?	S	juin27	0:16	\_ [migration/7]
root	59	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ksoftirqd/7]
root	61	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kworker/7:0H-kblockd]
root	62	0.0	0.0	0	0	?	S	juin27	0:00	\_ [kdevtmpfs]
root	63	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [inet_frag_wq]
root	64	0.0	0.0	0	0	?	S	juin27	0:00	\_ [kauditd]
root	65	0.0	0.0	0	0	?	S	juin27	0:00	\_ [khungtaskd]
root	67	0.0	0.0	0	0	?	S	juin27	0:00	\_ [oom_reaper]
root	69	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [writeback]
root	70	0.0	0.0	0	0	?	S	juin27	0:02	\_ [kcompactd0]
root	71	0.0	0.0	0	0	?	SN	juin27	0:00	\_ [ksmd]
root	73	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kintegrityd]
root	74	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kblockd]
root	75	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [blkcg_punt_bio]
root	78	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [tpm_dev_wq]
root	79	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [ata_sff]
root	80	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [md]
root	81	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [edac-poller]
root	82	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [devfreq_wq]
root	84	0.0	0.0	0	0	?	S	juin27	0:00	\_ [watchdogd]
root	85	0.0	0.0	0	0	?	I<	juin27	0:01	\_ [kworker/3:1H-kblockd]
root	86	0.0	0.0	0	0	?	S	juin27	0:00	\_ [kswapd0]
root	87	0.0	0.0	0	0	?	S	juin27	0:00	\_ [ecryptfs-kthread]
root	93	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kthrotld]
root	98	0.0	0.0	0	0	?	S	juin27	0:00	\_ [irq/123-pciehp]
root	104	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [acpi_thermal_pm]
root	105	0.0	0.0	0	0	?	S	juin27	0:00	\_ [xenbus_probe]
root	106	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [vfio-irqfd-clea]
root	108	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [mld]
root	109	0.0	0.0	0	0	?	I<	juin27	0:02	\_ [kworker/0:1H-kblockd]
root	110	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [ipv6_addrconf]
root	115	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kstrp]
root	121	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [zswap-shrink]
root	168	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [charger_manager]
root	190	0.0	0.0	0	0	?	I<	juin27	0:02	\_ [kworker/1:1H-kblockd]
root	226	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [nvme-wq]
root	227	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [nvme-reset-wq]
root	228	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [nvme-delete-wq]
root	229	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [cryptd]
root	251	0.0	0.0	0	0	?	I<	juin27	0:01	\_ [kworker/4:1H-kblockd]
root	254	0.5	0.0	0	0	?	S	juin27	8:42	\_ [irq/144-DELL0B23:00]
root	260	0.0	0.0	0	0	?	I<	juin27	0:01	\_ [kworker/2:1H-kblockd]
root	262	0.0	0.0	0	0	?	S	juin27	0:00	\_ [card0-crtc0]
root	263	0.0	0.0	0	0	?	S	juin27	0:00	\_ [card0-crtc1]
root	264	0.0	0.0	0	0	?	S	juin27	0:00	\_ [card0-crtc2]
root	265	0.0	0.0	0	0	?	S	juin27	0:00	\_ [card0-crtc3]
root	267	0.0	0.0	0	0	?	I<	juin27	0:01	\_ [kworker/5:1H-kblockd]
root	541	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kdmflush/253:0]
root	547	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kcryptd_io/253:]
root	548	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kcryptd/253:0]
root	549	0.0	0.0	0	0	?	S	juin27	0:15	\_ [dmcrypt_write/253:0]
root	553	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kdmflush/253:1]
root	554	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [kdmflush/253:2]
root	598	0.0	0.0	0	0	?	S	juin27	0:03	\_ [jbd2/dm-1-8]
root	599	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [ext4-rsv-conver]
root	693	0.0	0.0	0	0	?	I<	juin27	0:02	\_ [kworker/6:1H-kblockd]
root	700	0.0	0.0	0	0	?	I<	juin27	0:02	\_ [kworker/7:1H-kblockd]
root	883	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [cfg80211]
root	922	0.0	0.0	0	0	?	S	juin27	0:00	\_ [jbd2/nvme0n1p2-8]
root	923	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [ext4-rsv-conver]
root	931	0.0	0.0	0	0	?	S	juin27	0:07	\_ [irq/155-iwlwifi:default_queue]
root	932	0.0	0.0	0	0	?	S	juin27	0:01	\_ [irq/156-iwlwifi:queue_1]
root	933	0.0	0.0	0	0	?	S	juin27	0:01	\_ [irq/157-iwlwifi:queue_2]
root	934	0.0	0.0	0	0	?	S	juin27	0:01	\_ [irq/158-iwlwifi:queue_3]
root	935	0.0	0.0	0	0	?	S	juin27	0:01	\_ [irq/159-iwlwifi:queue_4]
root	936	0.0	0.0	0	0	?	S	juin27	0:04	\_ [irq/160-iwlwifi:queue_5]
root	937	0.0	0.0	0	0	?	S	juin27	0:01	\_ [irq/161-iwlwifi:queue_6]
root	938	0.0	0.0	0	0	?	S	juin27	0:01	\_ [irq/162-iwlwifi:queue_7]
root	939	0.0	0.0	0	0	?	S	juin27	0:01	\_ [irq/163-iwlwifi:queue_8]
root	941	0.0	0.0	0	0	?	S	juin27	0:00	\_ [irq/164-iwlwifi:exception]
root	1052	0.0	0.0	0	0	?	S	juin27	0:00	\_ [irq/165-AudioDSP]
root	1186	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [USBC000:00-con0]
root	2259	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [iprt-VBoxWQueue]
root	2260	0.0	0.0	0	0	?	S	juin27	0:00	\_ [iprt-VBoxTscThread]
root	2324	0.0	0.0	0	0	?	I<	juin27	0:00	\_ [dio/dm-1]
root	2753	0.0	0.0	0	0	?	S<	juin27	0:00	\_ [krfcommd]
root	67662	0.0	0.0	0	0	?	I<	juin27	0:06	\_ [kworker/u17:2-rb_allocator]
root	74907	0.0	0.0	0	0	?	S	06:46	0:00	\_ [irq/143-mei_me]
root	79386	0.1	0.0	0	0	?	I	07:07	0:12	\_ [kworker/u16:2-kcryptd/253:0]
root	79826	0.1	0.0	0	0	?	I	07:14	0:12	\_ [kworker/u16:3-kcryptd/253:0]
root	80843	0.1	0.0	0	0	?	I	07:26	0:13	\_ [kworker/u16:6-thunderbolt0]
root	92597	0.1	0.0	0	0	?	I	07:43	0:13	\_ [kworker/u16:4-kcryptd/253:0]
root	99211	0.0	0.0	0	0	?	I	08:52	0:00	\_ [kworker/1:0-events]
root	99299	0.0	0.0	0	0	?	I	08:54	0:00	\_ [kworker/7:1-mm_percpu_wq]
root	99460	0.0	0.0	0	0	?	I	08:58	0:00	\_ [kworker/3:1-events]
root	99478	0.3	0.0	0	0	?	I	08:59	0:12	\_ [kworker/u16:7-kcryptd/253:0]
root	99479	0.3	0.0	0	0	?	I	08:59	0:12	\_ [kworker/u16:9-kcryptd/253:0]
root	99562	0.0	0.0	0	0	?	I	09:02	0:00	\_ [kworker/1:1-mm_percpu_wq]
root	99840	0.0	0.0	0	0	?	I<	09:03	0:00	\_ [kworker/u17:1-rb_allocator]
root	100041	0.3	0.0	0	0	?	I	09:13	0:08	\_ [kworker/u16:0-kcryptd/253:0]
root	100171	0.2	0.0	0	0	?	I	09:19	0:06	\_ [kworker/u16:5-kcryptd/253:0]
root	100256	0.0	0.0	0	0	?	I	09:23	0:00	\_ [kworker/4:2-events]
root	100368	0.0	0.0	0	0	?	I	09:25	0:00	\_ [kworker/0:0-events]
root	101699	0.0	0.0	0	0	?	I	09:26	0:00	\_ [kworker/6:1-events]
root	105597	0.0	0.0	0	0	?	I	09:27	0:00	\_ [kworker/5:1-events]
root	108859	0.0	0.0	0	0	?	I	09:28	0:00	\_ [kworker/2:0-events]
root	122608	0.0	0.0	0	0	?	I	09:31	0:00	\_ [kworker/6:0-events]
root	139893	0.0	0.0	0	0	?	I	09:36	0:00	\_ [kworker/4:0-mm_percpu_wq]
root	154770	0.0	0.0	0	0	?	I	09:40	0:00	\_ [kworker/3:2-events]
root	158041	0.0	0.0	0	0	?	I	09:41	0:00	\_ [kworker/5:0-events]
root	173491	0.3	0.0	0	0	?	I	09:45	0:03	\_ [kworker/u16:10-kcryptd/253:0]
root	193536	0.0	0.0	0	0	?	I	09:50	0:00	\_ [kworker/2:1-events]
root	196073	0.0	0.0	0	0	?	I	09:50	0:00	\_ [kworker/5:2-events]
root	198652	0.3	0.0	0	0	?	I	09:51	0:01	\_ [kworker/u16:8-events_power_efficient]
root	199435	0.0	0.0	0	0	?	I	09:51	0:00	\_ [kworker/1:3-events]
root	202560	0.0	0.0	0	0	?	I	09:52	0:00	\_ [kworker/6:2-events]
root	207698	0.0	0.0	0	0	?	I	09:54	0:00	\_ [kworker/7:0]
root	208341	0.3	0.0	0	0	?	I	09:54	0:01	\_ [kworker/u16:11-kcryptd/253:0]
root	208986	0.0	0.0	0	0	?	I	09:54	0:00	\_ [kworker/0:1-pm]
root	209122	0.0	0.0	0	0	?	I	09:54	0:00	\_ [kworker/0:3-events]
root	212992	0.0	0.0	0	0	?	I	09:55	0:00	\_ [kworker/5:3]
root	214282	0.0	0.0	0	0	?	I	09:55	0:00	\_ [kworker/2:2-mm_percpu_wq]
root	214931	0.0	0.0	0	0	?	I	09:56	0:00	\_ [kworker/6:3-kdmflush/253:1]
root	221379	0.0	0.0	0	0	?	I	09:57	0:00	\_ [kworker/1:2-events]
root	228470	0.0	0.0	0	0	?	I	09:59	0:00	\_ [kworker/4:1]
root	231049	0.0	0.0	0	0	?	I	10:00	0:00	\_ [kworker/0:2]
root	1	0.0	0.0	168752	14260	?	Ss	juin27	0:03	/sbin/init splash
root	665	0.0	0.5	132900	81956	?	S	juin27	0:04	/lib/systemd/systemd-journald
root	701	0.0	0.0	26996	7308	?	Ss	juin27	0:00	/lib/systemd/systemd-udevd
systemd+	1018	0.0	0.0	14824	6244	?	Ss	juin27	1:04	/lib/systemd/systemd-oomd
systemd+	1020	0.0	0.0	26320	14448	?	Ss	juin27	0:04	/lib/systemd/systemd-resolved
systemd+	1022	0.0	0.0	89376	6640	?	Ssl	juin27	0:00	/lib/systemd/systemd-timesyncd
root	1094	0.0	0.0	243432	8572	?	Ssl	juin27	0:01	/usr/libexec/accounts-daemon
root	1095	0.0	0.0	2812	1144	?	Ss	juin27	0:02	/usr/sbin/acpid
avahi	1097	0.0	0.0	7628	4316	?	Ss	juin27	0:00	avahi-daemon: running [inspiron-14.local]
avahi	1147	0.0	0.0	7440	340	?	S	juin27	0:00	\_ avahi-daemon: chroot helper
root	1098	0.0	0.0	10632	5032	?	Ss	juin27	0:00	/usr/lib/bluetooth/bluetoothd
root	1100	0.0	0.0	12040	3048	?	Ss	juin27	0:00	/usr/sbin/cron -f -P
message+	1101	0.0	0.0	11288	7184	?	Ss	juin27	0:06	@dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only
root	1103	0.0	0.1	339788	21540	?	Ssl	juin27	0:09	/usr/sbin/NetworkManager --no-daemon
root	1110	0.0	0.0	82800	3928	?	Ssl	juin27	0:03	/usr/sbin/irqbalance --foreground
root	1112	0.0	0.0	151268	1884	?	Ssl	juin27	0:00	/usr/bin/lxcfs /var/lib/lxcfs
root	1113	0.0	0.1	43612	21608	?	Ss	juin27	0:00	/usr/bin/python3 /usr/bin/networkd-dispatcher --run-startup-triggers
root	1114	0.0	0.0	246152	12100	?	Ssl	juin27	0:01	/usr/libexec/polkitd --no-debug
root	1116	0.0	0.0	242908	8000	?	Ssl	juin27	0:00	/usr/libexec/power-profiles-daemon
root	1118	0.0	0.1	1612648	18840	?	Ssl	juin27	0:06	/usr/bin/pritunl-client-service
syslog	1121	0.0	0.0	222424	6148	?	Ssl	juin27	0:00	/usr/sbin/rsyslogd -n -iNONE
root	1124	0.0	0.3	1540816	50852	?	Ssl	juin27	0:08	/usr/lib/snapd/snapd
root	1126	0.0	0.0	239068	6876	?	Ssl	juin27	0:00	/usr/libexec/switcheroo-control
root	1130	0.0	0.0	48264	8296	?	Ss	juin27	0:00	/lib/systemd/systemd-logind
root	1132	0.0	0.0	278744	11064	?	Ssl	juin27	1:15	/usr/sbin/thermald --systemd --dbus-enable --adaptive
root	1135	0.0	0.1	394048	16448	?	Ssl	juin27	0:00	/usr/libexec/udisks2/udisksd
root	1137	0.0	0.0	17768	11988	?	Ss	juin27	0:00	/sbin/wpa_supplicant -u -s -O /run/wpa_supplicant
root	1154	0.0	0.2	394824	34424	?	Ssl	juin27	0:02	/opt/cisco/anyconnect/bin/vpnagentd -execv_instance
root	1205	0.0	0.0	4848	1324	?	Ss	juin27	0:00	/usr/lib/x86_64-linux-gnu/lxc/lxc-monitord --daemon
mssql	1206	0.0	0.1	69756	18372	?	Ssl	juin27	0:00	/opt/mssql/bin/sqlservr
mssql	1933	1.0	5.4	17906800	870688	?	Sl	juin27	16:35	\_ /opt/mssql/bin/sqlservr
root	1215	0.0	0.2	1579524	44744	?	Ssl	juin27	0:29	/usr/bin/containerd
root	1217	0.0	0.0	244324	12708	?	Ssl	juin27	0:00	/usr/sbin/ModemManager
root	1218	0.0	0.0	243068	8072	?	Ssl	juin27	0:00	/usr/libexec/boltd
root	1242	0.0	0.1	120696	23324	?	Ssl	juin27	0:00	/usr/bin/python3 /usr/share/unattended-upgrades/unattended-upgrade-shutdown --wait-for-signal
root	1255	0.0	0.0	15420	8860	?	Ss	juin27	0:00	sshd: /usr/sbin/sshd -D [listener] 0 of 10-100 startups
bind	1271	0.0	0.1	1272172	17152	?	Ssl	juin27	0:03	/usr/sbin/named -u bind
root	1283	0.0	0.0	244040	9520	?	Ssl	juin27	0:00	/usr/sbin/gdm3
root	2602	0.0	0.0	394824	12244	?	Sl	juin27	0:00	\_ gdm-session-worker [pam/gdm-password]
gilles	2793	0.0	0.0	165124	6320	tty2	Ssl+	juin27	0:00	\_ /usr/libexec/gdm-wayland-session env GNOME_SHELL_SESSION_MODE=ubuntu /usr/bin/gnome-session --session=ubuntu
gilles	2800	0.0	0.0	225764	15564	tty2	Sl+	juin27	0:00	\_ /usr/libexec/gnome-session-binary --session=ubuntu
mysql	1347	0.4	2.4	2307720	396116	?	Ssl	juin27	7:20	/usr/sbin/mysqld
root	1352	0.0	0.0	245588	9724	?	Ssl	juin27	0:05	/usr/libexec/upowerd
root	1360	0.0	0.0	6872	4900	?	Ss	juin27	0:02	/usr/sbin/apache2 -k start
www-data	1370	0.0	0.0	6840	4216	?	S	juin27	0:00	\_ /usr/sbin/apache2 -k start
www-data	1371	0.0	0.0	1998272	4704	?	Sl	juin27	0:00	\_ /usr/sbin/apache2 -k start
www-data	1372	0.0	0.0	1932736	4704	?	Sl	juin27	0:00	\_ /usr/sbin/apache2 -k start
rtkit	1368	0.0	0.0	154000	1544	?	SNsl	juin27	0:00	/usr/libexec/rtkit-daemon
root	1799	0.0	0.2	376604	40508	?	Ssl	juin27	0:07	/usr/libexec/packagekitd
colord	1963	0.0	0.0	248404	13908	?	Ssl	juin27	0:00	/usr/libexec/colord
root	2196	0.0	0.4	1764472	76280	?	Ssl	juin27	0:07	/usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sock
kernoops	2216	0.0	0.0	13084	460	?	Ss	juin27	0:00	/usr/sbin/kerneloops --test
kernoops	2227	0.0	0.0	13084	460	?	Ss	juin27	0:00	/usr/sbin/kerneloops
gilles	2671	0.0	0.0	18196	11132	?	Ss	juin27	0:01	/lib/systemd/systemd --user
gilles	2672	0.0	0.0	171036	5156	?	S	juin27	0:00	\_ (sd-pam)
gilles	2678	0.0	0.0	42556	6900	?	S	juin27	0:00	\_ /usr/bin/pipewire
gilles	2679	0.0	0.0	26148	6536	?	Ssl	juin27	0:00	\_ /usr/bin/pipewire-media-session
gilles	2680	0.7	0.1	2845532	31260	?	S	juin27	11:05	\_ /usr/bin/pulseaudio --daemonize=no --log-target=journal
gilles	2694	0.0	0.0	10388	6700	?	Ss	juin27	0:02	\_ /usr/bin/dbus-daemon --session --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only
gilles	2696	0.0	0.0	243408	8524	?	Ssl	juin27	0:00	\_ /usr/libexec/gvfsd
gilles	3004	0.0	0.0	391656	9164	?	Sl	juin27	0:00	\| \_ /usr/libexec/gvfsd-trash --spawner :1.2 /org/gtk/gvfs/exec_spaw/0
gilles	5780	0.0	0.0	284460	12020	?	Sl	juin27	0:00	\| \_ /usr/libexec/gvfsd-http --spawner :1.2 /org/gtk/gvfs/exec_spaw/1
gilles	7005	0.0	0.0	391648	9252	?	Sl	juin27	0:00	\| \_ /usr/libexec/gvfsd-network --spawner :1.2 /org/gtk/gvfs/exec_spaw/2
gilles	7013	0.0	0.1	525504	22696	?	Sl	juin27	0:00	\| \_ /usr/libexec/gvfsd-smb-browse --spawner :1.2 /org/gtk/gvfs/exec_spaw/3
gilles	7026	0.0	0.0	319588	9108	?	Sl	juin27	0:00	\| \_ /usr/libexec/gvfsd-dnssd --spawner :1.2 /org/gtk/gvfs/exec_spaw/4
gilles	2706	0.0	0.0	380888	6460	?	Sl	juin27	0:00	\_ /usr/libexec/gvfsd-fuse /run/user/1000/gvfs -f
gilles	2724	0.0	0.0	539908	8124	?	Ssl	juin27	0:00	\_ /usr/libexec/xdg-document-portal
root	2735	0.0	0.0	2792	1012	?	Ss	juin27	0:00	\| \_ fusermount3 -o rw,nosuid,nodev,fsname=portal,auto_unmount,subtype=portal -- /run/user/1000/doc
gilles	2728	0.0	0.0	239016	5452	?	Ssl	juin27	0:00	\_ /usr/libexec/xdg-permission-store
gilles	2752	0.0	0.1	710908	29160	?	SNsl	juin27	0:02	\_ /usr/libexec/tracker-miner-fs-3
gilles	2761	0.0	0.0	318976	9864	?	Ssl	juin27	0:00	\_ /usr/libexec/gvfs-udisks2-volume-monitor
gilles	2766	0.0	0.0	239408	6760	?	Ssl	juin27	0:00	\_ /usr/libexec/gvfs-goa-volume-monitor
gilles	2770	0.0	0.2	567428	39880	?	Sl	juin27	0:00	\_ /usr/libexec/goa-daemon
gilles	2777	0.0	0.0	341284	15184	?	Sl	juin27	0:00	\_ /usr/libexec/goa-identity-service
gilles	2779	0.0	0.0	239192	6752	?	Ssl	juin27	0:00	\_ /usr/libexec/gvfs-mtp-volume-monitor
gilles	2787	0.0	0.0	240280	6876	?	Ssl	juin27	0:00	\_ /usr/libexec/gvfs-gphoto2-volume-monitor
gilles	2792	0.0	0.0	317980	8432	?	Ssl	juin27	0:02	\_ /usr/libexec/gvfs-afc-volume-monitor
gilles	2839	0.0	0.0	94452	5032	?	Ssl	juin27	0:00	\_ /usr/libexec/gnome-session-ctl --monitor
gilles	2854	0.0	0.1	662100	19024	?	Ssl	juin27	0:00	\_ /usr/libexec/gnome-session-binary --systemd-service --session=ubuntu
gilles	2877	0.0	0.0	309628	7740	?	Sl	juin27	0:00	\| \_ /usr/libexec/at-spi-bus-launcher --launch-immediately
gilles	2888	0.0	0.0	8560	4588	?	S	juin27	0:00	\| \| \_ /usr/bin/dbus-daemon --config-file=/usr/share/defaults/at-spi2/accessibility.conf --nofork --print-address 11 --address=unix:path=/run/user/1000/at-spi/bus
gilles	3085	0.0	0.0	232272	7056	?	Sl	juin27	0:00	\| \_ /usr/libexec/gsd-disk-utility-notify
gilles	3093	0.0	0.4	809216	67380	?	Sl	juin27	0:00	\| \_ /usr/libexec/evolution-data-server/evolution-alarm-notify
gilles	5712	0.0	0.2	498048	33384	?	Sl	juin27	0:01	\| \_ update-notifier
gilles	2885	1.5	2.3	5618664	374212	?	Ssl	juin27	22:49	\_ /usr/bin/gnome-shell
gilles	6644	0.0	0.5	839108	85092	?	Sl	juin27	0:09	\| \_ /usr/bin/Xwayland :0 -rootless -noreset -accessx -core -auth /run/user/1000/.mutter-Xwaylandauth.UUUY61 -listen 4 -listen 5 -displayfd 6 -initfd 7
gilles	76893	0.0	0.3	3046448	57512	?	Sl	06:46	0:00	\| \_ gjs /usr/share/gnome-shell/extensions/ding@rastersoft.com/ding.js -E -P /usr/share/gnome-shell/extensions/ding@rastersoft.com -M 0 -D 0:0:1600:900:1:27:0:0:0:0
gilles	77187	0.0	0.7	1657104	116280	?	SLl	06:46	0:00	\| \_ pidgin
gilles	2963	0.0	0.1	582980	20464	?	Sl	juin27	0:00	\_ /usr/libexec/gnome-shell-calendar-server
gilles	2969	0.0	0.1	878608	26860	?	Ssl	juin27	0:00	\_ /usr/libexec/evolution-source-registry
gilles	2976	0.0	0.1	1458012	32032	?	Ssl	juin27	0:00	\_ /usr/libexec/evolution-calendar-factory
gilles	2984	0.0	0.0	157200	6192	?	Ssl	juin27	0:00	\_ /usr/libexec/dconf-service
gilles	2989	0.0	0.1	748980	29452	?	Ssl	juin27	0:00	\_ /usr/libexec/evolution-addressbook-factory
gilles	3015	0.0	0.1	2942344	29304	?	Sl	juin27	0:00	\_ /usr/bin/gjs /usr/share/gnome-shell/org.gnome.Shell.Notifications
gilles	3017	0.0	0.0	162680	7296	?	Sl	juin27	0:00	\_ /usr/libexec/at-spi2-registryd --use-gnome-session
gilles	3033	0.0	0.0	2888	968	?	Ss	juin27	0:00	\_ sh -c /usr/bin/ibus-daemon --panel disable $([ "$XDG_SESSION_TYPE" = "x11" ] && echo "--xim")
gilles	3036	0.0	0.0	465656	12696	?	Sl	juin27	0:49	\| \_ /usr/bin/ibus-daemon --panel disable
gilles	3155	0.0	0.0	166360	7584	?	Sl	juin27	0:00	\| \_ /usr/libexec/ibus-memconf
gilles	3156	0.0	0.1	351116	29416	?	Sl	juin27	0:06	\| \_ /usr/libexec/ibus-extension-gtk3
gilles	3236	0.0	0.0	166616	7976	?	Sl	juin27	0:18	\| \_ /usr/libexec/ibus-engine-simple
gilles	3034	0.0	0.0	313380	7204	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-a11y-settings
gilles	3037	0.0	0.1	466156	27848	?	Ssl	juin27	0:02	\_ /usr/libexec/gsd-color
gilles	3039	0.0	0.1	378408	16788	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-datetime
gilles	3041	0.0	0.0	316344	9368	?	Ssl	juin27	0:02	\_ /usr/libexec/gsd-housekeeping
gilles	3044	0.0	0.1	343948	22708	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-keyboard
gilles	3048	0.0	0.1	867624	27520	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-media-keys
gilles	3051	0.0	0.1	718960	29012	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-power
gilles	3053	0.0	0.0	252788	11972	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-print-notifications
gilles	3055	0.0	0.0	460648	6832	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-rfkill
gilles	3057	0.0	0.0	239080	6624	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-screensaver-proxy
gilles	3058	0.0	0.0	469292	12120	?	Ssl	juin27	0:01	\_ /usr/libexec/gsd-sharing
gilles	3060	0.0	0.0	462728	8544	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-smartcard
gilles	3062	0.0	0.0	322300	9816	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-sound
gilles	3064	0.0	0.1	344576	23076	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-wacom
gilles	3145	0.0	0.0	345148	14004	?	Sl	juin27	0:00	\_ /usr/libexec/gsd-printer
gilles	3168	0.0	0.0	240112	7864	?	Sl	juin27	0:00	\_ /usr/libexec/ibus-portal
gilles	3190	0.0	1.9	1495448	313168	?	Sl	juin27	0:09	\_ /snap/snap-store/959/usr/bin/snap-store --gapplication-service
gilles	3281	0.0	0.0	757736	15048	?	Ssl	juin27	0:01	\_ /usr/libexec/xdg-desktop-portal
gilles	3292	0.0	0.0	167716	8660	?	Ssl	juin27	0:00	\_ /usr/libexec/gvfsd-metadata
gilles	3301	0.0	0.3	1154600	61292	?	Ssl	juin27	0:04	\_ /usr/libexec/xdg-desktop-portal-gnome
gilles	3375	0.0	0.1	2934132	28384	?	Sl	juin27	0:00	\_ /usr/bin/gjs /usr/share/gnome-shell/org.gnome.ScreenSaver
gilles	3397	0.0	0.1	347860	27108	?	Ssl	juin27	0:00	\_ /usr/libexec/xdg-desktop-portal-gtk
gilles	3478	0.0	0.0	76148	13008	?	Ss	juin27	0:00	\_ /snap/snapd-desktop-integration/83/usr/bin/snapd-desktop-integration
gilles	3554	0.0	0.1	307560	24612	?	Sl	juin27	0:00	\| \_ /snap/snapd-desktop-integration/83/usr/bin/snapd-desktop-integration
gilles	6030	0.0	0.1	1088360	26188	?	Sl	juin27	0:02	\_ /usr/bin/snap userd
gilles	6663	0.0	0.5	1045616	82064	?	Ssl	juin27	0:00	\_ /usr/libexec/gsd-xsettings
gilles	6706	0.0	0.1	197512	25972	?	Sl	juin27	0:00	\_ /usr/libexec/ibus-x11
gilles	80506	0.1	0.4	568300	64872	?	Ssl	07:22	0:16	\_ /usr/libexec/gnome-terminal-server
gilles	80524	0.0	0.0	14084	5956	pts/0	Ss+	07:22	0:00	\| \_ bash
gilles	80962	0.0	0.0	14568	6580	pts/1	Ss	07:27	0:00	\| \_ bash
root	98554	0.0	0.0	17176	6176	pts/1	S+	08:47	0:00	\| \| \_ sudo su - postgres
root	98555	0.0	0.0	17176	980	pts/2	Ss	08:47	0:00	\| \| \_ sudo su - postgres
root	98556	0.0	0.0	15928	5008	pts/2	S	08:47	0:00	\| \| \_ su - postgres
postgres	98557	0.0	0.0	13940	5892	pts/2	S+	08:47	0:00	\| \| \_ -bash
gilles	99483	0.0	0.0	14084	5928	pts/3	Ss	08:59	0:00	\| \_ bash
gilles	101042	0.3	0.0	21948	11716	pts/3	S+	09:26	0:07	\| \_ pgcluu_collectd
gilles	230914	0.0	0.0	0	0	pts/3	Z+	10:00	0:00	\| \_ [pgcluu_collectd]
gilles	230915	0.0	0.0	0	0	pts/3	Z+	10:00	0:00	\| \_ [pgcluu_collectd]
gilles	231052	0.0	0.0	2888	964	pts/3	S+	10:00	0:00	\| \_ sh -c ps -faux 2>/dev/null
gilles	231053	0.0	0.0	16072	4228	pts/3	R+	10:00	0:00	\| \_ ps -faux
gilles	80675	0.0	0.0	86800	4148	?	SLs	07:24	0:00	\_ /usr/bin/gpg-agent --supervised
postgres	100370	0.0	0.1	178928	29532	?	Ss	09:25	0:01	\_ /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
postgres	100371	0.1	0.8	179280	141556	?	Ss	09:25	0:04	\_ postgres: checkpointer
postgres	100372	0.2	0.8	179064	140888	?	Ss	09:25	0:05	\_ postgres: background writer
postgres	100374	0.2	0.0	179064	7392	?	Ss	09:25	0:04	\_ postgres: walwriter
postgres	100375	0.0	0.0	180504	12380	?	Ss	09:25	0:00	\_ postgres: autovacuum launcher
postgres	100376	0.0	0.0	180528	5304	?	Ss	09:25	0:00	\_ postgres: logical replication launcher
gilles	2690	0.0	0.0	391144	8384	?	Sl	juin27	0:00	/usr/bin/gnome-keyring-daemon --daemonize --login
gilles	8071	0.0	0.0	8088	5940	?	S	juin27	0:00	\_ /usr/bin/ssh-agent -D -a /run/user/1000/keyring/.ssh
root	3468	0.0	0.4	438152	74908	?	Ssl	juin27	0:03	/usr/libexec/fwupd/fwupd
root	77887	0.0	0.0	75752	14388	?	Ss	06:51	0:00	/usr/sbin/cupsd -l
lp	77933	0.0	0.0	16280	5396	?	S	06:51	0:00	\_ /usr/lib/cups/notifier/dbus dbus://
root	77888	0.0	0.0	173516	13160	?	Ssl	06:51	0:00	/usr/sbin/cups-browsed

Cluster

Databases

System

Archiver

Packages

About pgCluu

License

Download

Authors

System

Kernel

CPU

Memory

Filesystem

Process list