[QUERY ] VACUUM FULL ANALYZE VERBOSE jbpm_byteblock
INFO: vacuuming "public.jbpm_byteblock"
INFO: "jbpm_byteblock": found 15505882 removable, 18439352
nonremovable row versions in 4762603 pages
DETAIL: 0 dead row versions cannot be removed yet.
CPU 106.46s/45.32u sec elapsed 433.55 sec.
INFO: analyzing "public.jbpm_byteblock"
INFO: "jbpm_byteblock": scanned 300000 of 2564994 pages,
containing *2156123* live rows and 0 dead rows; 300000 rows in sample,
18438821 estimated total rows
[QUERY ] VACUUM FULL ANALYZE VERBOSE jbpm_variableinstance
INFO: vacuuming "public.jbpm_variableinstance"
INFO: "jbpm_variableinstance": found 0 removable, 15556252
nonremovable row versions in 283202 pages
DETAIL: 3070018 dead row versions cannot be removed yet.
CPU 7.59s/16.67u sec elapsed 65.72 sec.
INFO: analyzing "public.jbpm_variableinstance"
INFO: "jbpm_variableinstance": scanned 276005 of 276005 pages,
containing *12486234* live rows and *3070018* dead rows; 300000 rows in
sample, 12486234 estimated total rows
Não entendi esses números coloridos. O banco não tem nenhuma conexão, só a
minha.
O que significaria live rows no analyze? Não deveria ser igual ao
nonremovable do vacuum full? (VERMELHO)
Esse valor seria apenas das 300000 páginas?
Se sim por que na 2a tabela está diferente já que pegou todas as páginas?
Por que existem dead rows, já que passei um vacuum full na tabela ? (AZUL)
Qual seria a diferença do live rows do nonremovable rows?
Não estou entendendo a diferença dos valores das linhas no vacuum e no
analyze.
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
