backend> SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind = 'r'; user=,db=WARNING: base de datos ”Zpostgres”Z debe ser limpiada dentro de 998972 transacciones user=,db=HINT: Para evitar que la base de datos se desactive, ejecute VACUUM en toda la base de datos ”Zpostgres”Z 1: relname (typeid = 19, len = 64, typmod = -1, byval = f) 2: age (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "sql_sizing" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000063" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "sql_sizing_profiles" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000061" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "sql_features" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000059" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "sql_implementation_info" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000057" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_authid" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "sql_languages" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000053" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "sql_packages" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000051" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "sql_parts" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000049" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_statistic" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000047" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_type" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000045" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_attribute" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000044" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_proc" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000043" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_class" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000041" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_autovacuum" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000040" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_attrdef" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000039" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_constraint" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000037" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_inherits" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000035" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_index" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000034" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_operator" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000033" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_opclass" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000032" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_am" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000031" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_amop" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000030" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_amproc" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000029" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_language" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000028" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_largeobject" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000027" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_aggregate" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000026" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_rewrite" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000025" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_trigger" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000023" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_listener" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000022" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_description" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000021" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_cast" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000019" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_namespace" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000018" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_conversion" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000017" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_depend" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "100000016" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_tablespace" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_pltemplate" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_shdepend" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_shdescription" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_database" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: relname = "pg_auth_members" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t) ---- ------------------------------------------------------------- backend>SELECT datname, age(datfrozenxid) FROM pg_database; user=,db=WARNING: base de datos ”Zpostgres”Z debe ser limpiada dentro de 998969 transacciones user=,db=HINT: Para evitar que la base de datos se desactive, ejecute VACUUM en toda la base de datos ”Zpostgres”Z 1: datname (typeid = 19, len = 64, typmod = -1, byval = f) 2: age (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: datname = "postgres" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484678" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: datname = "alertas" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484678" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: datname = "prueba" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484678" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: datname = "template1" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484678" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: datname = "template0" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484678" (typeid = 23, len = 4, typmod = -1, byval = t) ---- 1: datname = "pruebasfoo" (typeid = 19, len = 64, typmod = -1, byval = f) 2: age = "2146484678" (typeid = 23, len = 4, typmod = -1, byval = t) ---- backend>