Jamie Bull jamiebull1

## postgres_queries_and_commands.sql
-- 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%'

## gist:2808d06f59a38138fa2d

      
              1 file
            
          
              4 forks
            
          
              11 comments
            
          
              33 stars
            
          
                amirziai
                / gist:2808d06f59a38138fa2d
            
            
              Last active
              December 8, 2022 18:09
            
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## pipwin.py
"""python -m pipwin pycuda-2016.1.2+cuda7518-cp34-cp34m-win_amd64.whl"""

from __future__ import absolute_import, division, print_function

import argparse
import os
import shutil
import tempfile
import sys
	-- 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%'
	"""python -m pipwin pycuda-2016.1.2+cuda7518-cp34-cp34m-win_amd64.whl"""

	from __future__ import absolute_import, division, print_function

	import argparse
	import os
	import shutil
	import tempfile
	import sys