Hi Peter,
On 2018-02-28 16:50:44 +, Phil Florent wrote:
> With an index creation (create index t1_i1 on t1(c1, c2);) I have this kind
> of output :
>
> ./t -d 20 -o "pid, backend_type, query, wait_event_type, wait_event"
> busy_pc | distinct_exe | pid | backend_type | query
Hi,
I created an index on a 11devel base while sampling pg_stat_activity with a
little tool. Tool catches a line if state = active. Collected rows are
aggregated and sorted by activity percentage.
Test environment :
select version();