search

ctengiz / firewad

Web admin tool for Firebird SQL RDBMS
MIT License
10 stars 1 forks source link

Custom reports in monitoring #13

Open ctengiz opened 9 years ago

ctengiz commented 9 years ago

ie Report top 10 statements ranked by their memory usage:

SELECT FIRST 10 
  STMT.MON$ATTACHMENT_ID, STMT.MON$SQL_TEXT, MEM.MON$MEMORY_USED
FROM MON$MEMORY_USAGE MEM
NATURAL JOIN MON$STATEMENTS STMT
ORDER BY MEM.MON$MEMORY_USED DESC

(example is from README.monitoring_tables from Firebird dist.)