统计日志数据

• 复制
  复制成功

select * from tbase_log order by process_id,log_time;

• 复制
  复制成功

SELECT * FROM TBase_log WHERE error_severity='ERROR' limit 1;   

• 复制
  复制成功

postgres=#  select count(1),process_id,user_name,database_name from tbase_log group by process_id,user_name,database_name order by count(1) desc limit 10;
 count | process_id | user_name | database_name 
-------+------------+-----------+---------------
  2770 |      48067 | pgxz      | postgres
    10 |      22143 | pgxz      | postgres
    10 |      28778 | pgxz      | postgres
     9 |      28367 | pgxz      | postgres
     9 |      44280 | pgxz      | postgres
     8 |      32442 | pgxz      | postgres
     7 |      17911 | pgxz      | postgres
     7 |      21865 | pgxz      | postgres
     7 |      26159 | pgxz      | postgres
     7 |      45471 | pgxz      | postgres
(10 rows)

• 复制
  复制成功

postgres=#  select count(1),user_name from tbase_log group by user_name order by count(1) desc limit 10;                                                           
 count | user_name 
-------+-----------
 10790 | pgxz

• 复制
  复制成功

postgres=#  select count(1),database_name from tbase_log group by database_name order by count(1) desc limit 10;             
 count | database_name 
-------+---------------
 10790 | postgres
(1 row)

• 复制
  复制成功

postgres=# select count(1),user_name,database_name from tbase_log where error_severity='ERROR' group by user_name,database_name order by count(1) desc limit 10;           
 count | user_name | database_name 
-------+-----------+---------------
  1390 | pgxz      | postgres
(1 row)