Re: [9.1] unusable for large views
От | Pavel Stehule |
---|---|
Тема | Re: [9.1] unusable for large views |
Дата | |
Msg-id | CAFj8pRBkfQtRgeaYedgumGkxo1pLJEAm+MDZK68yO=JGTHxaWw@mail.gmail.com обсуждение исходный текст |
Ответ на | [9.1] unusable for large views ("Omar Bettin" <o.bettin@informaticaindustriale.it>) |
Список | pgsql-hackers |
Hello please, send a result of explain analyze on 9.1.1 and older please, use http://explain.depesz.com/ Regards Pavel Stehule 2011/10/24 Omar Bettin <o.bettin@informaticaindustriale.it>: > Hello, > > > > I have tried 9.1.1 win64 version and when I am trying to declare a cursor > for a very large view (lot of joins and aggregate functions), > > postgres is using around 3GB of memory and the query never returns. > > > > Same proble selecting from the view without cursor. > > > > Same query worked fine from 8.3.3 to 9.0.5. > > > > Should I change some configuration params to have the same behavior as > previous versions? > > > > > > > > Tried on Win2008 server R2 64bit 8GB RAM. > > also on Win7 64bit 8GB RAM. > > default postgresql.conf > > > > Regards, > > > > > > The view (!) > > > > CREATE OR REPLACE VIEW articoli_rip_ven20110227_view AS > > SELECT a.pk_id, a.articolo, a.articolo_f, a.origine, ( SELECT > ditte.attivita > > FROM ditte > > WHERE ditte.partitario = a.cod_fornit) AS dummy_1, a.descrizion, > a.taglia, a.peso_spec, a.giacenza_colli, a.giacenza, rim.colli AS > rimanenza_colli, rim.quantita AS rimanenza_qta, rimass.colli AS > rimanenza_ass_colli, rimass.quantita AS rimanenza_ass_qta, > COALESCE(b20.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b21.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b22.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b23.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b24.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b25.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b26.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b27.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b28.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b29.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b30.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b31.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b32.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b33.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b34.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b35.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b36.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b37.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b38.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b39.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b40.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b41.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b42.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b43.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b44.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b45.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b46.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b47.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b48.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b49.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b50.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b51.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b52.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b53.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b54.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b55.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b56.quantita, NULL::numeric, 0::numeric)::double precision + > (COALESCE(rim.quantita, NULL::numeric, 0::numeric) + > COALESCE(rimass.quantita, NULL::numeric, 0::numeric))::double precision - > (COALESCE(b1.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b2.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b3.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b4.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b5.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b6.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b7.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b8.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b9.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b10.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b11.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b12.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b13.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b14.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b15.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b16.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b17.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b18.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b19.quantita, NULL::numeric, 0::numeric)::double precision) AS > diff_qta, COALESCE(b1.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b2.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b3.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b4.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b5.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b6.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b7.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b8.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b9.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b10.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b11.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b12.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b13.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b14.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b15.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b16.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b17.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b18.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b19.colli::integer, NULL::integer, 0)::smallint AS sum_colli_cli, > COALESCE(b1.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b2.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b3.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b4.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b5.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b6.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b7.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b8.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b9.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b10.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b11.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b12.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b13.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b14.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b15.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b16.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b17.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b18.quantita, NULL::numeric, 0::numeric)::double precision + > COALESCE(b19.quantita, NULL::numeric, 0::numeric)::double precision AS > sum_qta_cli, COALESCE(b20.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b21.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b22.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b23.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b24.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b25.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b26.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b27.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b28.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b29.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b30.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b31.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b32.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b33.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b34.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b35.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b36.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b37.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b38.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b39.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b40.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b41.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b42.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b43.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b44.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b45.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b46.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b47.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b48.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b49.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b50.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b51.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b52.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b53.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b54.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b55.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b56.colli::integer, NULL::integer, 0)::smallint + > (COALESCE(rim.colli, NULL::bigint, 0::bigint) + COALESCE(rimass.colli, > NULL::bigint, 0::bigint))::smallint AS sum_colli_for, COALESCE(b20.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b21.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b22.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b23.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b24.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b25.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b26.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b27.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b28.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b29.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b30.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b31.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b32.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b33.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b34.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b35.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b36.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b37.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b38.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b39.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b40.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b41.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b42.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b43.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b44.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b45.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b46.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b47.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b48.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b49.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b50.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b51.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b52.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b53.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b54.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b55.quantita, > NULL::numeric, 0::numeric)::double precision + COALESCE(b56.quantita, > NULL::numeric, 0::numeric)::double precision + (COALESCE(rim.quantita, > NULL::numeric, 0::numeric) + COALESCE(rimass.quantita, NULL::numeric, > 0::numeric))::double precision AS sum_qta_for, COALESCE(b20.colli::integer, > NULL::integer, 0)::smallint + COALESCE(b21.colli::integer, NULL::integer, > 0)::smallint + COALESCE(b22.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b23.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b24.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b25.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b26.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b27.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b28.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b29.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b30.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b31.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b32.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b33.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b34.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b35.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b36.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b37.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b38.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b39.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b40.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b41.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b42.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b43.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b44.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b45.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b46.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b47.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b48.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b49.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b50.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b51.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b52.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b53.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b54.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b55.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b56.colli::integer, NULL::integer, 0)::smallint + > (COALESCE(rim.colli, NULL::bigint, 0::bigint) + COALESCE(rimass.colli, > NULL::bigint, 0::bigint))::smallint - (COALESCE(b1.colli::integer, > NULL::integer, 0)::smallint + COALESCE(b2.colli::integer, NULL::integer, > 0)::smallint + COALESCE(b3.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b4.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b5.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b6.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b7.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b8.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b9.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b10.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b11.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b12.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b13.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b14.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b15.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b16.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b17.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b18.colli::integer, NULL::integer, 0)::smallint + > COALESCE(b19.colli::integer, NULL::integer, 0)::smallint) AS diff_colli, > (COALESCE(b1.stato::integer, NULL::integer, 0)::smallint > 0 OR b1.articolo > IS NULL) AND (COALESCE(b2.stato::integer, NULL::integer, 0)::smallint > 0 OR > b2.articolo IS NULL) AND (COALESCE(b3.stato::integer, NULL::integer, > 0)::smallint > 0 OR b3.articolo IS NULL) AND (COALESCE(b4.stato::integer, > NULL::integer, 0)::smallint > 0 OR b4.articolo IS NULL) AND > (COALESCE(b5.stato::integer, NULL::integer, 0)::smallint > 0 OR b5.articolo > IS NULL) AND (COALESCE(b6.stato::integer, NULL::integer, 0)::smallint > 0 OR > b6.articolo IS NULL) AND (COALESCE(b7.stato::integer, NULL::integer, > 0)::smallint > 0 OR b7.articolo IS NULL) AND (COALESCE(b8.stato::integer, > NULL::integer, 0)::smallint > 0 OR b8.articolo IS NULL) AND > (COALESCE(b9.stato::integer, NULL::integer, 0)::smallint > 0 OR b9.articolo > IS NULL) AND (COALESCE(b10.stato::integer, NULL::integer, 0)::smallint > 0 > OR b10.articolo IS NULL) AND (COALESCE(b11.stato::integer, NULL::integer, > 0)::smallint > 0 OR b11.articolo IS NULL) AND (COALESCE(b12.stato::integer, > NULL::integer, 0)::smallint > 0 OR b12.articolo IS NULL) AND > (COALESCE(b13.stato::integer, NULL::integer, 0)::smallint > 0 OR > b13.articolo IS NULL) AND (COALESCE(b14.stato::integer, NULL::integer, > 0)::smallint > 0 OR b14.articolo IS NULL) AND (COALESCE(b15.stato::integer, > NULL::integer, 0)::smallint > 0 OR b15.articolo IS NULL) AND > (COALESCE(b16.stato::integer, NULL::integer, 0)::smallint > 0 OR > b16.articolo IS NULL) AND (COALESCE(b17.stato::integer, NULL::integer, > 0)::smallint > 0 OR b17.articolo IS NULL) AND (COALESCE(b18.stato::integer, > NULL::integer, 0)::smallint > 0 OR b18.articolo IS NULL) AND > (COALESCE(b19.stato::integer, NULL::integer, 0)::smallint > 0 OR > b19.articolo IS NULL) AS chk_cli, (COALESCE(b20.stato, NULL::integer, > 0)::smallint > 0 OR b20.articolo IS NULL) AND (COALESCE(b21.stato, > NULL::integer, 0)::smallint > 0 OR b21.articolo IS NULL) AND > (COALESCE(b22.stato, NULL::integer, 0)::smallint > 0 OR b22.articolo IS > NULL) AND (COALESCE(b23.stato, NULL::integer, 0)::smallint > 0 OR > b23.articolo IS NULL) AND (COALESCE(b24.stato, NULL::integer, 0)::smallint > > 0 OR b24.articolo IS NULL) AND (COALESCE(b25.stato, NULL::integer, > 0)::smallint > 0 OR b25.articolo IS NULL) AND (COALESCE(b26.stato, > NULL::integer, 0)::smallint > 0 OR b26.articolo IS NULL) AND > (COALESCE(b27.stato, NULL::integer, 0)::smallint > 0 OR b27.articolo IS > NULL) AND (COALESCE(b28.stato, NULL::integer, 0)::smallint > 0 OR > b28.articolo IS NULL) AND (COALESCE(b29.stato, NULL::integer, 0)::smallint > > 0 OR b29.articolo IS NULL) AND (COALESCE(b30.stato, NULL::integer, > 0)::smallint > 0 OR b30.articolo IS NULL) AND (COALESCE(b31.stato, > NULL::integer, 0)::smallint > 0 OR b31.articolo IS NULL) AND > (COALESCE(b32.stato, NULL::integer, 0)::smallint > 0 OR b32.articolo IS > NULL) AND (COALESCE(b33.stato, NULL::integer, 0)::smallint > 0 OR > b33.articolo IS NULL) AND (COALESCE(b34.stato, NULL::integer, 0)::smallint > > 0 OR b34.articolo IS NULL) AND (COALESCE(b35.stato, NULL::integer, > 0)::smallint > 0 OR b35.articolo IS NULL) AND (COALESCE(b36.stato, > NULL::integer, 0)::smallint > 0 OR b36.articolo IS NULL) AND > (COALESCE(b37.stato, NULL::integer, 0)::smallint > 0 OR b37.articolo IS > NULL) AND (COALESCE(b38.stato, NULL::integer, 0)::smallint > 0 OR > b38.articolo IS NULL) AND (COALESCE(b39.stato, NULL::integer, 0)::smallint > > 0 OR b39.articolo IS NULL) AND (COALESCE(b40.stato, NULL::integer, > 0)::smallint > 0 OR b40.articolo IS NULL) AND (COALESCE(b41.stato, > NULL::integer, 0)::smallint > 0 OR b41.articolo IS NULL) AND > (COALESCE(b42.stato, NULL::integer, 0)::smallint > 0 OR b42.articolo IS > NULL) AND (COALESCE(b43.stato, NULL::integer, 0)::smallint > 0 OR > b43.articolo IS NULL) AND (COALESCE(b44.stato, NULL::integer, 0)::smallint > > 0 OR b44.articolo IS NULL) AND (COALESCE(b45.stato, NULL::integer, > 0)::smallint > 0 OR b45.articolo IS NULL) AND (COALESCE(b46.stato, > NULL::integer, 0)::smallint > 0 OR b46.articolo IS NULL) AND > (COALESCE(b47.stato, NULL::integer, 0)::smallint > 0 OR b47.articolo IS > NULL) AND (COALESCE(b48.stato, NULL::integer, 0)::smallint > 0 OR > b48.articolo IS NULL) AND (COALESCE(b49.stato, NULL::integer, 0)::smallint > > 0 OR b49.articolo IS NULL) AND (COALESCE(b50.stato, NULL::integer, > 0)::smallint > 0 OR b50.articolo IS NULL) AND (COALESCE(b51.stato, > NULL::integer, 0)::smallint > 0 OR b51.articolo IS NULL) AND > (COALESCE(b52.stato, NULL::integer, 0)::smallint > 0 OR b52.articolo IS > NULL) AND (COALESCE(b53.stato, NULL::integer, 0)::smallint > 0 OR > b53.articolo IS NULL) AND (COALESCE(b54.stato, NULL::integer, 0)::smallint > > 0 OR b54.articolo IS NULL) AND (COALESCE(b55.stato, NULL::integer, > 0)::smallint > 0 OR b55.articolo IS NULL) AND (COALESCE(b56.stato, > NULL::integer, 0)::smallint > 0 OR b56.articolo IS NULL) AS chk_for, > b1.colli AS t_colli7717cli, b1.quantita AS t_qta7717cli, b1.stato AS > st7717cli, b1.eti_ok AS ok7717cli, b2.colli AS t_colli7705cli, b2.quantita > AS t_qta7705cli, b2.stato AS st7705cli, b2.eti_ok AS ok7705cli, b3.colli AS > t_colli7715cli, b3.quantita AS t_qta7715cli, b3.stato AS st7715cli, > b3.eti_ok AS ok7715cli, b4.colli AS t_colli7704cli, b4.quantita AS > t_qta7704cli, b4.stato AS st7704cli, b4.eti_ok AS ok7704cli, b5.colli AS > t_colli7714cli, b5.quantita AS t_qta7714cli, b5.stato AS st7714cli, > b5.eti_ok AS ok7714cli, b6.colli AS t_colli7718cli, b6.quantita AS > t_qta7718cli, b6.stato AS st7718cli, b6.eti_ok AS ok7718cli, b7.colli AS > t_colli7713cli, b7.quantita AS t_qta7713cli, b7.stato AS st7713cli, > b7.eti_ok AS ok7713cli, b8.colli AS t_colli7708cli, b8.quantita AS > t_qta7708cli, b8.stato AS st7708cli, b8.eti_ok AS ok7708cli, b9.colli AS > t_colli7719cli, b9.quantita AS t_qta7719cli, b9.stato AS st7719cli, > b9.eti_ok AS ok7719cli, b10.colli AS t_colli7709cli, b10.quantita AS > t_qta7709cli, b10.stato AS st7709cli, b10.eti_ok AS ok7709cli, b11.colli AS > t_colli7722cli, b11.quantita AS t_qta7722cli, b11.stato AS st7722cli, > b11.eti_ok AS ok7722cli, b12.colli AS t_colli7706cli, b12.quantita AS > t_qta7706cli, b12.stato AS st7706cli, b12.eti_ok AS ok7706cli, b13.colli AS > t_colli7716cli, b13.quantita AS t_qta7716cli, b13.stato AS st7716cli, > b13.eti_ok AS ok7716cli, b14.colli AS t_colli7721cli, b14.quantita AS > t_qta7721cli, b14.stato AS st7721cli, b14.eti_ok AS ok7721cli, b15.colli AS > t_colli7707cli, b15.quantita AS t_qta7707cli, b15.stato AS st7707cli, > b15.eti_ok AS ok7707cli, b16.colli AS t_colli7712cli, b16.quantita AS > t_qta7712cli, b16.stato AS st7712cli, b16.eti_ok AS ok7712cli, b17.colli AS > t_colli7711cli, b17.quantita AS t_qta7711cli, b17.stato AS st7711cli, > b17.eti_ok AS ok7711cli, b18.colli AS t_colli7710cli, b18.quantita AS > t_qta7710cli, b18.stato AS st7710cli, b18.eti_ok AS ok7710cli, b19.colli AS > t_colli7720cli, b19.quantita AS t_qta7720cli, b19.stato AS st7720cli, > b19.eti_ok AS ok7720cli, b20.colli AS t_colli18499for, b20.quantita AS > t_qta18499for, b20.stato AS st18499for, b21.colli AS t_colli18502for, > b21.quantita AS t_qta18502for, b21.stato AS st18502for, b22.colli AS > t_colli18469for, b22.quantita AS t_qta18469for, b22.stato AS st18469for, > b23.colli AS t_colli18475for, b23.quantita AS t_qta18475for, b23.stato AS > st18475for, b24.colli AS t_colli18472for, b24.quantita AS t_qta18472for, > b24.stato AS st18472for, b25.colli AS t_colli18462for, b25.quantita AS > t_qta18462for, b25.stato AS st18462for, b26.colli AS t_colli18479for, > b26.quantita AS t_qta18479for, b26.stato AS st18479for, b27.colli AS > t_colli18505for, b27.quantita AS t_qta18505for, b27.stato AS st18505for, > b28.colli AS t_colli18470for, b28.quantita AS t_qta18470for, b28.stato AS > st18470for, b29.colli AS t_colli18477for, b29.quantita AS t_qta18477for, > b29.stato AS st18477for, b30.colli AS t_colli18465for, b30.quantita AS > t_qta18465for, b30.stato AS st18465for, b31.colli AS t_colli18453for, > b31.quantita AS t_qta18453for, b31.stato AS st18453for, b32.colli AS > t_colli18457for, b32.quantita AS t_qta18457for, b32.stato AS st18457for, > b33.colli AS t_colli18450for, b33.quantita AS t_qta18450for, b33.stato AS > st18450for, b34.colli AS t_colli18451for, b34.quantita AS t_qta18451for, > b34.stato AS st18451for, b35.colli AS t_colli18454for, b35.quantita AS > t_qta18454for, b35.stato AS st18454for, b36.colli AS t_colli18456for, > b36.quantita AS t_qta18456for, b36.stato AS st18456for, b37.colli AS > t_colli18455for, b37.quantita AS t_qta18455for, b37.stato AS st18455for, > b38.colli AS t_colli18458for, b38.quantita AS t_qta18458for, b38.stato AS > st18458for, b39.colli AS t_colli18501for, b39.quantita AS t_qta18501for, > b39.stato AS st18501for, b40.colli AS t_colli18504for, b40.quantita AS > t_qta18504for, b40.stato AS st18504for, b41.colli AS t_colli18471for, > b41.quantita AS t_qta18471for, b41.stato AS st18471for, b42.colli AS > t_colli18500for, b42.quantita AS t_qta18500for, b42.stato AS st18500for, > b43.colli AS t_colli18503for, b43.quantita AS t_qta18503for, b43.stato AS > st18503for, b44.colli AS t_colli18461for, b44.quantita AS t_qta18461for, > b44.stato AS st18461for, b45.colli AS t_colli18478for, b45.quantita AS > t_qta18478for, b45.stato AS st18478for, b46.colli AS t_colli18467for, > b46.quantita AS t_qta18467for, b46.stato AS st18467for, b47.colli AS > t_colli18474for, b47.quantita AS t_qta18474for, b47.stato AS st18474for, > b48.colli AS t_colli18459for, b48.quantita AS t_qta18459for, b48.stato AS > st18459for, b49.colli AS t_colli18460for, b49.quantita AS t_qta18460for, > b49.stato AS st18460for, b50.colli AS t_colli18464for, b50.quantita AS > t_qta18464for, b50.stato AS st18464for, b51.colli AS t_colli18480for, > b51.quantita AS t_qta18480for, b51.stato AS st18480for, b52.colli AS > t_colli18506for, b52.quantita AS t_qta18506for, b52.stato AS st18506for, > b53.colli AS t_colli18452for, b53.quantita AS t_qta18452for, b53.stato AS > st18452for, b54.colli AS t_colli18463for, b54.quantita AS t_qta18463for, > b54.stato AS st18463for, b55.colli AS t_colli18466for, b55.quantita AS > t_qta18466for, b55.stato AS st18466for, b56.colli AS t_colli18473for, > b56.quantita AS t_qta18473for, b56.stato AS st18473for > > FROM articoli a > > LEFT JOIN articoli_rim_rip_ven20110227_view rim ON rim.articolo = > a.articolo > > LEFT JOIN articoli_rim_ass_rip_ven20110227_view rimass ON rimass.articolo > = a.articolo > > LEFT JOIN bolrighe b1 ON b1.numero = 7717 AND b1.articolo = a.articolo > > LEFT JOIN bolrighe b2 ON b2.numero = 7705 AND b2.articolo = a.articolo > > LEFT JOIN bolrighe b3 ON b3.numero = 7715 AND b3.articolo = a.articolo > > LEFT JOIN bolrighe b4 ON b4.numero = 7704 AND b4.articolo = a.articolo > > LEFT JOIN bolrighe b5 ON b5.numero = 7714 AND b5.articolo = a.articolo > > LEFT JOIN bolrighe b6 ON b6.numero = 7718 AND b6.articolo = a.articolo > > LEFT JOIN bolrighe b7 ON b7.numero = 7713 AND b7.articolo = a.articolo > > LEFT JOIN bolrighe b8 ON b8.numero = 7708 AND b8.articolo = a.articolo > > LEFT JOIN bolrighe b9 ON b9.numero = 7719 AND b9.articolo = a.articolo > > LEFT JOIN bolrighe b10 ON b10.numero = 7709 AND b10.articolo = a.articolo > > LEFT JOIN bolrighe b11 ON b11.numero = 7722 AND b11.articolo = a.articolo > > LEFT JOIN bolrighe b12 ON b12.numero = 7706 AND b12.articolo = a.articolo > > LEFT JOIN bolrighe b13 ON b13.numero = 7716 AND b13.articolo = a.articolo > > LEFT JOIN bolrighe b14 ON b14.numero = 7721 AND b14.articolo = a.articolo > > LEFT JOIN bolrighe b15 ON b15.numero = 7707 AND b15.articolo = a.articolo > > LEFT JOIN bolrighe b16 ON b16.numero = 7712 AND b16.articolo = a.articolo > > LEFT JOIN bolrighe b17 ON b17.numero = 7711 AND b17.articolo = a.articolo > > LEFT JOIN bolrighe b18 ON b18.numero = 7710 AND b18.articolo = a.articolo > > LEFT JOIN bolrighe b19 ON b19.numero = 7720 AND b19.articolo = a.articolo > > LEFT JOIN magmodet b20 ON b20.numero = 18499 AND b20.articolo = > a.articolo > > LEFT JOIN magmodet b21 ON b21.numero = 18502 AND b21.articolo = > a.articolo > > LEFT JOIN magmodet b22 ON b22.numero = 18469 AND b22.articolo = > a.articolo > > LEFT JOIN magmodet b23 ON b23.numero = 18475 AND b23.articolo = > a.articolo > > LEFT JOIN magmodet b24 ON b24.numero = 18472 AND b24.articolo = > a.articolo > > LEFT JOIN magmodet b25 ON b25.numero = 18462 AND b25.articolo = > a.articolo > > LEFT JOIN magmodet b26 ON b26.numero = 18479 AND b26.articolo = > a.articolo > > LEFT JOIN magmodet b27 ON b27.numero = 18505 AND b27.articolo = > a.articolo > > LEFT JOIN magmodet b28 ON b28.numero = 18470 AND b28.articolo = > a.articolo > > LEFT JOIN magmodet b29 ON b29.numero = 18477 AND b29.articolo = > a.articolo > > LEFT JOIN magmodet b30 ON b30.numero = 18465 AND b30.articolo = > a.articolo > > LEFT JOIN magmodet b31 ON b31.numero = 18453 AND b31.articolo = > a.articolo > > LEFT JOIN magmodet b32 ON b32.numero = 18457 AND b32.articolo = > a.articolo > > LEFT JOIN magmodet b33 ON b33.numero = 18450 AND b33.articolo = > a.articolo > > LEFT JOIN magmodet b34 ON b34.numero = 18451 AND b34.articolo = > a.articolo > > LEFT JOIN magmodet b35 ON b35.numero = 18454 AND b35.articolo = > a.articolo > > LEFT JOIN magmodet b36 ON b36.numero = 18456 AND b36.articolo = > a.articolo > > LEFT JOIN magmodet b37 ON b37.numero = 18455 AND b37.articolo = > a.articolo > > LEFT JOIN magmodet b38 ON b38.numero = 18458 AND b38.articolo = > a.articolo > > LEFT JOIN magmodet b39 ON b39.numero = 18501 AND b39.articolo = > a.articolo > > LEFT JOIN magmodet b40 ON b40.numero = 18504 AND b40.articolo = > a.articolo > > LEFT JOIN magmodet b41 ON b41.numero = 18471 AND b41.articolo = > a.articolo > > LEFT JOIN magmodet b42 ON b42.numero = 18500 AND b42.articolo = > a.articolo > > LEFT JOIN magmodet b43 ON b43.numero = 18503 AND b43.articolo = > a.articolo > > LEFT JOIN magmodet b44 ON b44.numero = 18461 AND b44.articolo = > a.articolo > > LEFT JOIN magmodet b45 ON b45.numero = 18478 AND b45.articolo = > a.articolo > > LEFT JOIN magmodet b46 ON b46.numero = 18467 AND b46.articolo = > a.articolo > > LEFT JOIN magmodet b47 ON b47.numero = 18474 AND b47.articolo = > a.articolo > > LEFT JOIN magmodet b48 ON b48.numero = 18459 AND b48.articolo = > a.articolo > > LEFT JOIN magmodet b49 ON b49.numero = 18460 AND b49.articolo = > a.articolo > > LEFT JOIN magmodet b50 ON b50.numero = 18464 AND b50.articolo = > a.articolo > > LEFT JOIN magmodet b51 ON b51.numero = 18480 AND b51.articolo = > a.articolo > > LEFT JOIN magmodet b52 ON b52.numero = 18506 AND b52.articolo = > a.articolo > > LEFT JOIN magmodet b53 ON b53.numero = 18452 AND b53.articolo = > a.articolo > > LEFT JOIN magmodet b54 ON b54.numero = 18463 AND b54.articolo = > a.articolo > > LEFT JOIN magmodet b55 ON b55.numero = 18466 AND b55.articolo = > a.articolo > > LEFT JOIN magmodet b56 ON b56.numero = 18473 AND b56.articolo = > a.articolo; > >
В списке pgsql-hackers по дате отправления: