plcstevens

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

plcstevens

  (function() {
    var script = document.createElement('script');
    script.type = 'text/javascript';
    script.src = 'http://cdn.mark.reevoo.com/assets/reevoo_mark.js';
    var s = document.getElementById('reevoomark-loader');
    s.parentNode.insertBefore(script, s);
  })();
 
  afterReevooMarkLoaded = [function(){
    ReevooApi.load('YOUR_TRKREF_HERE', function(retailer){

plcstevens

<script id="reevoomark-loader" type="text/javascript" charset="utf-8">
  (function() {
    var trkref = 'TRKREF';
    var myscript = document.createElement('script');
    myscript.type = 'text/javascript';
    var protocol = (window.location.protocol == 'https:')? window.location.protocol : 'http:';
    myscript.src=(protocol + '//mark.reevoo.com/reevoomark/'+trkref+'.js?async=true');
    var s = document.getElementById('reevoomark-loader');
    s.parentNode.insertBefore(myscript, s);
  })();