Skip to content
Archive of entries posted on

Pg Jobs Active

I keep this one line as .sql in my home directory of all the work machines: SELECT   datname,usename,procpid,client_addr,waiting,query_start,current_query FROM   pg_stat_activity ; checking what is going on is easy psql -f short_queries_list.sql per the manual http://www.postgresql.org/docs/current/static/monitoring-stats.html

Sacramento Vehicle Miles Travelled

early visualizations of a model written in Python and PostGIS, in 2011 at Calthorpe Associates, Berkeley.       Lens on Daily Transportation PatternsSacramento, California