ЗАПИСИ
АПРЕЛЬ 17, 2015

Just a note on how to get running time for a query defined by regex:

  1. SELECT datname,waiting,now()-query_start,current_query
  2. FROM pg_stat_activity
  3. WHERE current_query ilike '%YOUR QUERY REGEX GOES HERE%'
  4. ORDER BY procpid;

Нет комметрариев