datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query | backend_type -------+----------+--------+----------+----------+------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+---------------------+-------------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------- | | 65 | | | | | | | 2021-01-13 10:55:06.855082+00 | | | | Activity | AutoVacuumMain | | | | | autovacuum launcher | | 67 | 10 | postgres | | | | | 2021-01-13 10:55:06.856508+00 | | | | Activity | LogicalLauncherMain | | | | | background worker 16385 | syndesis | 107536 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 54118 | 2021-01-13 15:08:50.224273+00 | | 2021-01-13 15:08:50.232314+00 | 2021-01-13 15:08:50.232347+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 16385 | syndesis | 82 | 16384 | syndesis | | ::1 | | 45338 | 2021-01-13 10:55:37.453093+00 | | 2021-01-13 10:55:38.014084+00 | 2021-01-13 10:55:38.024217+00 | Client | ClientRead | idle | | | SELECT pg_database.datname, pg_database_size(pg_database.datname) as size FROM pg_database | client backend 16385 | syndesis | 86654 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 52660 | 2021-01-13 15:04:25.99246+00 | | 2021-01-13 15:14:03.94798+00 | 2021-01-13 15:14:03.947992+00 | Client | ClientRead | idle | | | COMMIT | client backend 16385 | syndesis | 87202 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 52696 | 2021-01-13 15:04:32.027862+00 | | 2021-01-13 15:04:32.034133+00 | 2021-01-13 15:04:32.034167+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 16385 | syndesis | 104964 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 53800 | 2021-01-13 15:07:50.222372+00 | | 2021-01-13 15:07:50.229744+00 | 2021-01-13 15:07:50.229782+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 16385 | syndesis | 86404 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 52646 | 2021-01-13 15:04:23.274716+00 | | 2021-01-13 15:13:58.738889+00 | 2021-01-13 15:13:58.738964+00 | Client | ClientRead | idle | | | select path,value,ovalue from jsondb where path LIKE $1 order by path ASC | client backend 16385 | syndesis | 88548 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 52784 | 2021-01-13 15:04:47.082805+00 | | 2021-01-13 15:04:47.088699+00 | 2021-01-13 15:04:47.088732+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 16385 | syndesis | 86711 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 52668 | 2021-01-13 15:04:26.607196+00 | | 2021-01-13 15:04:26.614058+00 | 2021-01-13 15:04:26.614092+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 16385 | syndesis | 89769 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 52868 | 2021-01-13 15:05:00.448124+00 | | 2021-01-13 15:05:00.454254+00 | 2021-01-13 15:05:00.454286+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 16385 | syndesis | 112673 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 54760 | 2021-01-13 15:10:50.225296+00 | | 2021-01-13 15:10:50.232098+00 | 2021-01-13 15:10:50.232132+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 16385 | syndesis | 83708 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 52476 | 2021-01-13 15:03:53.471702+00 | 2021-01-13 15:07:22.040405+00 | 2021-01-13 15:07:22.061723+00 | 2021-01-13 15:07:23.109371+00 | Client | ClientRead | idle in transaction | | 41941 | SELECT p.proname,p.oid FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n WHERE p.pronamespace=n.oid AND n.nspname='pg_catalog' AND ( proname = 'lo_open' or proname = 'lo_close' or proname = 'lo_creat' or proname = 'lo_unlink' or proname = 'lo_lseek' or proname = 'lo_lseek64' or proname = 'lo_tell' or proname = 'lo_tell64' or proname = 'loread' or proname = 'lowrite' or proname = 'lo_truncate' or proname = 'lo_truncate64') | client backend 16385 | syndesis | 117232 | 16384 | syndesis | PostgreSQL JDBC Driver | 10.2.1.1 | | 55320 | 2021-01-13 15:12:37.397158+00 | | 2021-01-13 15:12:37.403293+00 | 2021-01-13 15:12:37.403325+00 | Client | ClientRead | idle | | | SET application_name = 'PostgreSQL JDBC Driver' | client backend 12295 | postgres | 120959 | 10 | postgres | psql | | | -1 | 2021-01-13 15:14:04.10589+00 | 2021-01-13 15:14:04.11032+00 | 2021-01-13 15:14:04.11032+00 | 2021-01-13 15:14:04.110322+00 | | | active | | 42035 | select * from pg_stat_activity; | client backend 12295 | postgres | 106146 | 10 | postgres | psql | | | -1 | 2021-01-13 15:08:17.900756+00 | | 2021-01-13 15:08:25.078596+00 | 2021-01-13 15:08:25.226807+00 | Client | ClientRead | idle | | | select * from pg_stat_activity; | client backend | | 63 | | | | | | | 2021-01-13 10:55:06.853873+00 | | | | Activity | BgWriterHibernate | | | | | background writer | | 62 | | | | | | | 2021-01-13 10:55:06.853546+00 | | | | Activity | CheckpointerMain | | | | | checkpointer | | 64 | | | | | | | 2021-01-13 10:55:06.854338+00 | | | | Activity | WalWriterMain | | | | | walwriter (19 rows)