void collectDbStats(ArrayList<SQLiteDebug.DbStats> dbStatsList){
  int lookaside=nativeGetDbLookaside(mConnectionPtr);
  long pageCount=0;
  long pageSize=0;
  try {
    pageCount=executeForLong("PRAGMA page_count;",null,null);
    pageSize=executeForLong("PRAGMA page_size;",null,null);
  }
 catch (  SQLiteException ex) {
  }
  dbStatsList.add(getMainDbStatsUnsafe(lookaside,pageCount,pageSize));
  CursorWindow window=new CursorWindow("collectDbStats");
  try {
    executeForCursorWindow("PRAGMA database_list;",null,window,0,0,false,null);
    for (int i=1; i < window.getNumRows(); i++) {
      String name=window.getString(i,1);
      String path=window.getString(i,2);
      pageCount=0;
      pageSize=0;
      try {
        pageCount=executeForLong("PRAGMA " + name + ".page_count;",null,null);
        pageSize=executeForLong("PRAGMA " + name + ".page_size;",null,null);
      }
 catch (      SQLiteException ex) {
      }
      String label="  (attached) " + name;
      if (!path.isEmpty()) {
        label+=": " + path;
      }
      dbStatsList.add(new SQLiteDebug.DbStats(label,pageCount,pageSize,0,0,0,0));
    }
  }
 catch (  SQLiteException ex) {
  }
 finally {
    window.close();
  }
}

void collectDbStats ( ArrayList < SQLiteDebug . DbStats > dbStatsList ) { int lookaside = nativeGetDbLookaside ( mConnectionPtr ) ; long pageCount = 0 ; long pageSize = 0 ; try { pageCount = executeForLong ( "PRAGMA page_count;" , null , null ) ; pageSize = executeForLong ( "PRAGMA page_size;" , null , null ) ; } catch ( SQLiteException ex ) { } dbStatsList . add ( getMainDbStatsUnsafe ( lookaside , pageCount , pageSize ) ) ; CursorWindow window = new CursorWindow ( "collectDbStats" ) ; try { executeForCursorWindow ( "PRAGMA database_list;" , null , window , 0 , 0 , false , null ) ; for ( int i = 1 ; i < window . getNumRows ( ) ; i ++ ) { String name = window . getString ( i , 1 ) ; String path = window . getString ( i , 2 ) ; pageCount = 0 ; pageSize = 0 ; try { pageCount = executeForLong ( "PRAGMA " + name + ".page_count;" , null , null ) ; pageSize = executeForLong ( "PRAGMA " + name + ".page_size;" , null , null ) ; } catch ( SQLiteException ex ) { } String label = "  (attached) " + name ; if ( ! path . isEmpty ( ) ) { label += ": " + path ; } dbStatsList . add ( new SQLiteDebug . DbStats ( label , pageCount , pageSize , 0 , 0 , 0 , 0 ) ) ; } } catch ( SQLiteException ex ) { } finally { window . close ( ) ; } }
collects statistics about database connection memory usage .
