Ok; faça agora na tb1, execute a query e nos mostre a query e o plano de
execução, ok?
________________________________
De: moisespsena <[email protected]>
Para: [email protected]
Enviadas: Sábado, 2 de Janeiro de 2010 16:18:04
Assunto: Re: [pgbr-geral] Re s: Índices e otimização
Bem, cliquei com o botão direito em cima da tabela e apareceu uma janela com as
opçoes: VACUM, ANALYSE, REINDEX. Marquei a opção VACUM e logo abaixo novas
opções apareceram: FULL, FREEZE e ANALYSE, marquei todas elas e mandei
executar, em seguida, tive a seguinte saída na aba 'mensagens' localizada na
parte inferior da janela:
INFO: vacuuming "public.tb2"INFO: "tb2": found 0 removable, 700001
nonremovable row versions in 5834 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 56 to 62 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 52116 bytes.
0 pages are or will become empty, including 0 at the end of the table.
1 pages containing 5448 free bytes are potential move destinations.
CPU 0.12s/0.31u sec elapsed 1.08 sec.INFO: index "tb2_pkey" now contains
700001 row versions in 1922 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.03s/0.00u sec elapsed 0.03 sec.INFO: index "tb2_idx" now contains 700001
row versions in 1922 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.01u sec elapsed 0.03 sec.INFO: "tb2": moved 0 row versions,
truncated 5834 to 5834 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.02 sec.
INFO: analyzing "public.tb2"INFO: "tb2": scanned 3000 of 5834 pages,
containing 360001 live rows and 0 dead rows; 3000 rows in sample, 700082
estimated total rowsTempo total de execução da consulta: 1289 ms.
________________________________
View this message in context: Re: Res: Índices e otimização
Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.
____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
