Skip to content

Instantly share code, notes, and snippets.

@mymtw

mymtw/queries at now

Created March 17, 2021 14:12
Show Gist options
  • Save mymtw/d056b9f8137c31715abbf4aae877a075 to your computer and use it in GitHub Desktop.
Save mymtw/d056b9f8137c31715abbf4aae877a075 to your computer and use it in GitHub Desktop.
Download ZIP
queries at now
Raw
queries at now
crypto=# SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-[ RECORD 1 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 24
age |
usename |
query |
-[ RECORD 2 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 27
age |
usename | crypto
query |
-[ RECORD 3 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 26
age |
usename | crypto
query |
-[ RECORD 4 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 28
age |
usename | crypto
query |
-[ RECORD 5 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 29
age |
usename | crypto
query |
-[ RECORD 6 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 22
age |
usename |
query |
-[ RECORD 7 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 21
age |
usename |
query |
-[ RECORD 8 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 23
age |
usename |
query |
-[ RECORD 9 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 7131
age | 00:00:00.000613
usename | crypto
query | SELECT traders.id AS traders_id, traders.acc_name AS traders_acc_name, traders.base AS traders_base, traders.real_base AS traders_real_base, traders.quote AS traders_quote, traders.data AS traders_data, traders.fields_snapshots AS traders_fields_snapshots, traders.trader_class AS traders_trader_class, traders.trader_subclass AS traders_trader_subclass, traders.exchange AS traders_exchange, traders.data_updated AS traders_data_updated +
| FROM traders, m2m_traders_params +
| WHERE 272 = m2m_traders_params.param_id AND traders.id = m2m_traders_params.trader_id
-[ RECORD 10 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 7132
age | 00:00:00.002345
usename | crypto
query | SELECT traders.id AS traders_id, traders.acc_name AS traders_acc_name, traders.base AS traders_base, traders.real_base AS traders_real_base, traders.quote AS traders_quote, traders.data AS traders_data, traders.fields_snapshots AS traders_fields_snapshots, traders.trader_class AS traders_trader_class, traders.trader_subclass AS traders_trader_subclass, traders.exchange AS traders_exchange, traders.data_updated AS traders_data_updated +
| FROM traders, m2m_traders_params +
| WHERE 655 = m2m_traders_params.param_id AND traders.id = m2m_traders_params.trader_id
-[ RECORD 11 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 7134
age | 00:00:00.002402
usename | crypto
query | SELECT traders.id AS traders_id, traders.acc_name AS traders_acc_name, traders.base AS traders_base, traders.real_base AS traders_real_base, traders.quote AS traders_quote, traders.data AS traders_data, traders.fields_snapshots AS traders_fields_snapshots, traders.trader_class AS traders_trader_class, traders.trader_subclass AS traders_trader_subclass, traders.exchange AS traders_exchange, traders.data_updated AS traders_data_updated +
| FROM traders, m2m_traders_params +
| WHERE 229 = m2m_traders_params.param_id AND traders.id = m2m_traders_params.trader_id
-[ RECORD 12 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 7135
age | 00:00:00.002944
usename | crypto
query | SELECT traders.id AS traders_id, traders.acc_name AS traders_acc_name, traders.base AS traders_base, traders.real_base AS traders_real_base, traders.quote AS traders_quote, traders.data AS traders_data, traders.fields_snapshots AS traders_fields_snapshots, traders.trader_class AS traders_trader_class, traders.trader_subclass AS traders_trader_subclass, traders.exchange AS traders_exchange, traders.data_updated AS traders_data_updated +
| FROM traders, m2m_traders_params +
| WHERE 353 = m2m_traders_params.param_id AND traders.id = m2m_traders_params.trader_id
-[ RECORD 13 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 7128
age | 00:00:00.004051
usename | crypto
query | SELECT traders.id AS traders_id, traders.acc_name AS traders_acc_name, traders.base AS traders_base, traders.real_base AS traders_real_base, traders.quote AS traders_quote, traders.data AS traders_data, traders.fields_snapshots AS traders_fields_snapshots, traders.trader_class AS traders_trader_class, traders.trader_subclass AS traders_trader_subclass, traders.exchange AS traders_exchange, traders.data_updated AS traders_data_updated +
| FROM traders, m2m_traders_params +
| WHERE 5492 = m2m_traders_params.param_id AND traders.id = m2m_traders_params.trader_id
-[ RECORD 14 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 7129
age | 00:00:00.336383
usename | crypto
query | ROLLBACK
-[ RECORD 15 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 6873
age | 00:00:00.616184
usename | crypto
query | ROLLBACK
-[ RECORD 16 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 6641
age | 00:00:00.78137
usename | crypto
query | COMMIT
-[ RECORD 17 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 6886
age | 00:00:02.43329
usename | crypto
query | ROLLBACK
-[ RECORD 18 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 6838
age | 00:00:02.594002
usename | crypto
query | COMMIT
-[ RECORD 19 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 6645
age | 00:00:18.539654
usename | crypto
query | ROLLBACK
-[ RECORD 20 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 6667
age | 00:00:18.741357
usename | crypto
query | COMMIT
-[ RECORD 21 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 2701
age | 00:06:16.058954
usename | crypto
query | COMMIT
-[ RECORD 22 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pid | 14541
age | 03:06:16.744805
usename | crypto
query | COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment