查看慢sql

```sql
SELECT 
  datname, 
  usename, 
  client_addr, 
  application_name, 
  state, 
  backend_start, 
  xact_start, 
  xact_stay, 
  query_start, 
  query_stay, 
  REPLACE(
    QUERY, 
    chr(10), 
    ' '
  ) AS QUERY 
FROM 
  (
    SELECT 
      pgsa.datname AS datname, 
      pgsa.usename AS usename, 
      pgsa.client_addr client_addr, 
      pgsa.application_name AS application_name, 
      pgsa.state AS state, 
      pgsa.backend_start AS backend_start, 
      pgsa.xact_start AS xact_start, 
      EXTRACT(
        epoch 
        FROM 
          (NOW() - pgsa.xact_start)
      ) AS xact_stay, 
      pgsa.query_start AS query_start, 
      EXTRACT(
        epoch 
        FROM 
          (NOW() - pgsa.query_start)
      ) AS query_stay, 
      pgsa.query AS QUERY 
    FROM 
      pg_stat_activity AS pgsa 
    WHERE 
      pgsa.state != 'idle' 
      AND pgsa.state != 'idle in transaction' 
      AND pgsa.state != 'idle in transaction (aborted)'
  ) idleconnections 
ORDER BY 
  query_stay DESC 
LIMIT 
  5;
```