Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- bitflix=# select * from pg_stat_activity
- bitflix-# ;
- 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
- -------+---------+-----+----------+---------+--------------------------+-----------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------+------------------------------
- | | 27 | | | | | | | 2019-07-16 19:40:00.64439+00 | | | | Activity | AutoVacuumMain | | | | | autovacuum launcher
- | | 29 | 10 | bitflix | | | | | 2019-07-16 19:40:00.645673+00 | | | | Activity | LogicalLauncherMain | | | | | logical replication launcher
- 16384 | bitflix | 30 | 10 | bitflix | PostgreSQL JDBC Driver | 177.207.209.188 | | 38380 | 2019-07-16 19:40:02.781252+00 | | 2019-07-16 20:05:00.271597+00 | 2019-07-16 20:05:00.271665+00 | Client | ClientRead | idle | | | SHOW TRANSACTION ISOLATION LEVEL | client backend
- 16384 | bitflix | 32 | 10 | bitflix | DBeaver 6.1.0 - Main | 177.207.209.188 | | 62493 | 2019-07-16 19:40:45.550261+00 | | 2019-07-16 19:55:07.655936+00 | 2019-07-16 19:55:07.658389+00 | Client | ClientRead | idle | | | select * from process_items | client backend
- 16384 | bitflix | 33 | 10 | bitflix | DBeaver 6.1.0 - Metadata | 177.207.209.188 | | 62494 | 2019-07-16 19:40:46.693895+00 | | 2019-07-16 19:55:05.896598+00 | 2019-07-16 19:55:05.896637+00 | Client | ClientRead | idle | | | SELECT i.*,c.relnamespace FROM pg_catalog.pg_inherits i,pg_catalog.pg_class c WHERE i.inhrelid=$1 AND c.oid=i.inhparent ORDER BY i.inhseqno | client backend
- 16384 | bitflix | 74 | 10 | bitflix | psql | 172.18.0.1 | | 45604 | 2019-07-16 20:13:28.058615+00 | | 2019-07-16 20:13:46.649814+00 | 2019-07-16 20:13:54.355024+00 | Client | ClientRead | idle | | | select * from process_items; | client backend
- 16384 | bitflix | 50 | 10 | bitflix | PostgreSQL JDBC Driver | 177.207.209.188 | | 45890 | 2019-07-16 19:54:51.11959+00 | | 2019-07-16 20:01:15.940253+00 | 2019-07-16 20:01:15.940341+00 | Client | ClientRead | idle | | | SHOW TRANSACTION ISOLATION LEVEL | client backend
- 16384 | bitflix | 56 | 10 | bitflix | PostgreSQL JDBC Driver | 177.207.209.188 | | 48152 | 2019-07-16 19:59:25.165375+00 | | 2019-07-16 19:59:27.152676+00 | 2019-07-16 19:59:27.152793+00 | Client | ClientRead | idle | | | SHOW TRANSACTION ISOLATION LEVEL | client backend
- 16384 | bitflix | 60 | 10 | bitflix | | 172.18.0.1 | | 45536 | 2019-07-16 20:02:47.134684+00 | | 2019-07-16 20:02:51.942246+00 | 2019-07-16 20:02:51.942401+00 | Client | ClientRead | idle | | | ROLLBACK | client backend
- 16384 | bitflix | 84 | 10 | bitflix | psql | 172.18.0.1 | | 45622 | 2019-07-16 20:16:00.327637+00 | 2019-07-16 20:16:31.548405+00 | 2019-07-16 20:16:31.548405+00 | 2019-07-16 20:16:31.548408+00 | | | active | | 350974 | select * from pg_stat_activity +| client backend
- | | | | | | | | | | | | | | | | | | ; |
- | | 25 | | | | | | | 2019-07-16 19:40:00.643516+00 | | | | Activity | BgWriterMain | | | | | background writer
- | | 24 | | | | | | | 2019-07-16 19:40:00.643081+00 | | | | Activity | CheckpointerMain | | | | | checkpointer
- | | 26 | | | | | | | 2019-07-16 19:40:00.643634+00 | | | | Activity | WalWriterMain | | | | | walwriter
- (13 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement