| Subject | Question about gathering Metadata in Firebird |
|---|---|
| Author | Babak Bastan |
| Post date | 2015-07-06T19:34:39Z |
Hi experts
I am new in Firebird. I would like to gather Metadata about queries in Firebird ( something like this in MSSQ )
I have just found Monitoring Tables in Firebird, which have intersteing information for me, but the problem there is no same column in MON$IO_STATS and (MON$TRANSACTIONS and MON$STATEMENTS )
If I run such a query, I am getting no resualt:
SELECT * from MON$TRANSACTIONS as T INNER JOIN MON$IO_STATS as IO on ( T.MON$STAT_ID=IO.MON$STAT_ID) INNER JOIN MON$STATEMENTS as S on(S.MON$STAT_ID=T.MON$STAT_ID)
Would you please say me, how can I gather Meadata about queries in Firebird?