givemetraffic

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

givemetraffic

# -*- mode: ruby -*-
# vi: set ft=ruby :



Vagrant.configure("2") do |config|
  config.vm.box = "ubuntu/xenial64"

  config.vm.box_check_update = false
  config.vm.network "private_network", ip: "192.168.33.10"

givemetraffic

http://kinozal.tv/details.php?id=1553711

givemetraffic

[
  {
    "_id": "5980d30770669307b3cfdb01",
    "id": 5997,
    "name": "Ackley",
    "county": "Franklin County / Hardin County",
    "state_code": "IA",
    "state": "Iowa",
    "zip_codes": 50601,
    "type": "City",