Kaarel Moppel

Take use of BRIN indexes when Postgres datastore is ver. 9.5+

1

Should give a nice size reduction as data is naturally ordered and insert only

"Unused schemas" view could be improved

1

In addition to min/max timestamps about gathered data existence we could also show when actually last IUD+call counts changed

Add handling for graphing sprocs with the same name but different signature

1

Currently a graph mixing both results is created without a warning

On sproc details page add indication about the schema

1

currently when the sproc has no parameters there's no way to understand which in which schema the sproc was called

feature idea - "stats mode"

1

Show only counts of active connections, exceptions, tx, load, xlog written (and other available numeric values) as 10s,1m,5m averages. Even better would be graphs. Currently there is no memory besides...

Filter activities by a username pattern

2

Currently there's a "--pid" flag but in practice pid's can change so fast that tracking by username would be more helpful

Idea: a built in webserver providing similar view on activity data

1

So basically an addition option to run the script in daemon mode and provide an HTML view + also JSON data

Locking information shown duplicated for one pid

4

Doesn't make too much sense probably as there is no information about different lock types given. pid | lock 5250 | 41921,41921

Added --db-filter and --user-filter flags

4

Flags for displaying processes on only desired DBs or users. Input should be Postgres regexes.

Monitoring backends of a single database only

1

Somekind of command line flag would suffice here I think.