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: ## PG10 Syntax SELECT datname,usename,pid,client_addr,wait_event,query_start,query FROM pg_stat_activity ; checking what is going on is easy psql -f short_queries_list.sql per the manual

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