Please refer to previous revisions if you know what to do.
The patch proposed was merged into kernel in 5.8 release, but no longer working as of linux 5.11
Please contact me, if you have new info about workarounds for CSR Bluetooth Dongle.
Telegram:
| ru: | |
| date: | |
| formats: | |
| # Форматы указываются в виде, поддерживаемом strftime. | |
| # По умолчанию используется default. | |
| # Можно добавлять собственные форматы | |
| # | |
| # | |
| # Use the strftime parameters for formats. | |
| # When no format has been given, it uses default. |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |