| -- 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%' |
There is an excellent example of transitioning data in D3, but this only works in version 3.
D3 version 4 requires a slightly different approach,
namely that the entered selections need to be merged prior to transition.
Added transition on exit. Also did a little code cleanup, especially given that eval is pretty gross.
| { | |
| "name": "Iceberg", | |
| "foreground": "#c6c8d1", | |
| "background": "#161821", | |
| "black": "#161821", | |
| "red": "#e27878", | |
| "green": "#b4be82", | |
| "yellow": "#e2a478", | |
| "blue": "#84a0c6", | |
| "purple": "#a093c7", |
