Tente executar um único explain. Depois, todos, em seqüência. Caso funcione, vale dar uma olhada no LOG do servidor.
2008/2/11, Wiliam Balan <[EMAIL PROTECTED]>: > > Pessoal, preciso jogar no postgresql varios comando de explain, como > estao abaixo( uns 40) mas da o seguinte erro, depois de processar alguns > > -------------------------------------------------------------------- > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > -------------------------------------------------------- > > Alguem saberia falar que configuração poderia alterar para não acontecer > isso? segue os comandos, são da base de dados benchmark DBT2. > > EXPLAIN DECLARE mycursor CURSOR FOR SELECT new_order(1, 6, 2496, 1, 8, > make_new_order_info(86000, 1, 8), make_new_order_info(52206, 1, 2), > make_new_order_info(10111, 1, 4), make_new_order_info(87936, 1, 8), > make_new_order_info(16384, 1, 9), make_new_order_info(60414, 1, 5), > make_new_order_info(540, 1, 8), make_new_order_info(36219, 1, 5), > make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0) ); > > EXPLAIN DECLARE mycursor CURSOR FOR SELECT new_order(1, 7, 990, 1, 9, > make_new_order_info(39388, 1, 1), make_new_order_info(4660, 1, 2), > make_new_order_info(64208, 1, 1), make_new_order_info(14333, 1, 4), > make_new_order_info(79360, 1, 2), make_new_order_info(82944, 1, 5), > make_new_order_info(2013, 1, 4), make_new_order_info(84992, 1, 4), > make_new_order_info(49087, 1, 1), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0) ); > > EXPLAIN SELECT payment(1, 9, 0, 1, 9, 'ABLEPRESPRI', 346.130000); > > EXPLAIN DECLARE mycursor CURSOR FOR SELECT new_order(1, 10, 72, 1, 11, > make_new_order_info(90111, 1, 1), make_new_order_info(96255, 1, 6), > make_new_order_info(99310, 1, 2), make_new_order_info(92922, 1, 3), > make_new_order_info(57032, 1, 2), make_new_order_info(79359, 1, 2), > make_new_order_info(83766, 1, 5), make_new_order_info(81788, 1, 9), > make_new_order_info(79743, 1, 7), make_new_order_info(47616, 1, 8), > make_new_order_info(40956, 1, 1), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), > make_new_order_info(0, 0, 0) ); > > Qualquer ajuda é bem vinda!!! > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- William Leite Araújo Analista de Banco de Dados - QualiConsult
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
