public static boolean getBoolean(AgnosticResultRow row, String colName) throws PalantirSqlException { long ret = row.getLong(colName); if (ret == 0) { return false; } return true; }
/** * Returns the number of milliseconds since the last compaction, or Long.MAX_VALUE if * compaction has never run. */ private long getMillisSinceLastCompact() { AgnosticResultSet rs = conns.get().selectResultSetUnregisteredQuery( "SELECT FLOOR(EXTRACT(EPOCH FROM GREATEST( " + " last_vacuum, last_autovacuum, last_analyze, last_autoanalyze" + "))*1000) AS last, " + "FLOOR(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP)*1000) AS current " + "FROM pg_stat_user_tables WHERE relname = ?", prefixedTableName()); AgnosticResultRow row = Iterables.getOnlyElement(rs.rows()); // last could be null if vacuum has never run long last = row.getLong("last", -1); if (last == -1) { return Long.MAX_VALUE; } long current = row.getLong("current"); return current - last; }
public static boolean getBoolean(AgnosticResultRow row, String colName) throws PalantirSqlException { long ret = row.getLong(colName); if (ret == 0) { return false; } return true; }
/** * Returns the number of milliseconds since the last compaction, or Long.MAX_VALUE if * compaction has never run. */ private long getMillisSinceLastCompact() { AgnosticResultSet rs = conns.get().selectResultSetUnregisteredQuery( "SELECT FLOOR(EXTRACT(EPOCH FROM GREATEST( " + " last_vacuum, last_autovacuum, last_analyze, last_autoanalyze" + "))*1000) AS last, " + "FLOOR(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP)*1000) AS current " + "FROM pg_stat_user_tables WHERE relname = ?", prefixedTableName()); AgnosticResultRow row = Iterables.getOnlyElement(rs.rows()); // last could be null if vacuum has never run long last = row.getLong("last", -1); if (last == -1) { return Long.MAX_VALUE; } long current = row.getLong("current"); return current - last; }