lrhache

On a recent project, I ran into an issue with Python Selenium webdriver. There's no easy way to open a new tab, grab whatever you need and return to original window opener.

Here's a couple people who ran into the same complication:

• http://stackoverflow.com/questions/17547473/how-to-open-a-new-tab-using-selenium-webdriver
• http://stackoverflow.com/questions/6421988/webdriver-open-new-tab/9122450#9122450
• https://groups.google.com/forum/#!topic/selenium-users/kah4iEPRopc
• ... and many many more.

So, after many minutes (read about an hour) of searching, I decided to do find a quick solution to this problem.

rgreenjr

-- 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%'