Josua Marcel C.

MySQL has show full processlist; to see a list of currently running queries.

PostgreSQL has a similar shell like select * from pg_stat_activity;

SHOW FULL PROCESSLIST in PostgreSQL
SHOW FULL PROCESSLIST in PostgreSQL

1. Simple Command

select * from pg_stat_activity;

2. Second Option

SELECT user, pid, client_addr, query, query_start, NOW() - query_start AS elapsed
FROM pg_stat_activity
WHERE query != '<IDLE>'
-- AND EXTRACT(EPOCH FROM (NOW() - query_start)) > 1
ORDER BY elapsed DESC;

3. Third Option

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;

4. Finding Long Processing Time / Stuck Queries

SELECT pid, now() - pg_stat_activity.query_start AS duration, query, state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

5. Cancelling Long Running Queries

SELECT pg_cancel_backend(pid);

6. Kill Process ID / Terminate Stuck Queries

SELECT pg_terminate_backend(pid);

SHOW FULL PROCESSLIST in PostgreSQL

--

--

If you feel pain or discomfort during descent: Stop, hold in place and equalize forcefully until your ears clear.

Relax and chill. I gather all the 6 APKs that needed for only 1 step needed to have Play Store in your Xiaomi 6A or any Xiaomi with China ROM

  1. Install 6 Google Framework here http://bit.ly/redmi5play
  2. Download Redmi 5 Play Alternative https://bit.ly/redmi5play2

(I downloaded all the APKs from apkmirror.com) There are some viruses or scam detected by Google Drive but it’s okay, because the Google Play Store size is around 40MB so the Google Drive detected it as a scam lol

And done, you may use Google Play Store in China ROM.

read my blogs: https://josuamarcelc.com/blog

--

--