QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------------------------------- Sort (cost=302633306088.35..302633311468.34 rows=2151999 width=826) Sort Key: m.id -> Hash Join (cost=53.40..302632292689.69 rows=2151999 width=826) Hash Cond: (m.categorieid = c.id) -> Hash Join (cost=40.25..94447.21 rows=2151999 width=310) Hash Cond: (m.emetteurid = e.id) -> Hash Join (cost=20.13..64837.10 rows=2151999 width=166) Hash Cond: (m.destinataireid = d.id) -> Seq Scan on main m (cost=0.00..35226.99 rows=2151999 width=22) -> Hash (cost=14.50..14.50 rows=450 width=150) -> Seq Scan on destinataires d (cost=0.00..14.50 rows=450 width=150) -> Hash (cost=14.50..14.50 rows=450 width=150) -> Seq Scan on emetteurs e (cost=0.00..14.50 rows=450 width=150) -> Hash (cost=11.40..11.40 rows=140 width=520) -> Seq Scan on categories c (cost=0.00..11.40 rows=140 width=520) SubPlan -> Seq Scan on message_default me (cost=0.00..124748.88 rows=1 width=514) Filter: (id = $0) -> Subquery Scan me (cost=34.45..303.92 rows=2 width=32) -> GroupAggregate (cost=34.45..303.90 rows=2 width=25) -> Hash Join (cost=34.45..303.11 rows=148 width=25) Hash Cond: (me.variableid = adme.id) -> Index Scan using message_132_id_key on message_132 me (cost=0.00..266.62 rows=148 width=11) Index Cond: (id = $0) -> Hash (cost=20.31..20.31 rows=1131 width=20) -> Seq Scan on association_details_message adme (cost=0.00..20.31 rows=1131 width=20) -> Subquery Scan me (cost=0.09..1668.14 rows=2 width=32) -> GroupAggregate (cost=0.09..1668.12 rows=2 width=26) -> Merge Join (cost=0.09..1663.46 rows=923 width=26) Merge Cond: (me.variableid = adme.id) -> Index Scan using message_131_id_key on message_131 me (cost=0.00..1630.29 rows=923 width=12) Index Cond: (id = $0) -> Index Scan using association_details_message_pkey on association_details_message adme (cost=0.00..49.22 rows=1131 width=20) -> Seq Scan on message_128 (cost=0.00..3.99 rows=1 width=17) Filter: (id = $0) -> Seq Scan on message_127 (cost=0.00..24.23 rows=6 width=34) Filter: (id = $0) -> Seq Scan on message_123 (cost=0.00..33.90 rows=9 width=5) Filter: (id = $0) -> Hash Join (cost=35.00..62.74 rows=10 width=33) Hash Cond: (q.id = me.id_quai) -> Seq Scan on quais q (cost=0.00..22.70 rows=1270 width=34) -> Hash (cost=34.88..34.88 rows=10 width=3) -> Seq Scan on message_122 me (cost=0.00..34.88 rows=10 width=3) Filter: (id = $0) -> Seq Scan on message_119 (cost=0.00..31.39 rows=8 width=10) Filter: (id = $0) -> Seq Scan on message_118 (cost=0.00..4.90 rows=1 width=2) Filter: (id = $0) -> Hash Join (cost=33.24..61.15 rows=9 width=36) Hash Cond: (q.id = me.id_quai) -> Seq Scan on quais q (cost=0.00..22.70 rows=1270 width=34) -> Hash (cost=33.13..33.13 rows=9 width=6) -> Seq Scan on message_117 me (cost=0.00..33.13 rows=9 width=6) Filter: (id = $0) -> Hash Join (cost=23.81..35.85 rows=3 width=58) Hash Cond: (f.id = me.id_fournisseur) -> Seq Scan on fournisseurs f (cost=0.00..11.40 rows=140 width=26) -> Hash (cost=23.75..23.75 rows=5 width=36) -> Seq Scan on message_116 me (cost=0.00..23.75 rows=5 width=36) Filter: (id = $0) -> Seq Scan on message_115 (cost=0.00..23.89 rows=5 width=36) Filter: (id = $0) -> Nested Loop (cost=0.00..10.87 rows=1 width=38) -> Seq Scan on message_112 me (cost=0.00..2.53 rows=1 width=8) Filter: (id = $0) -> Index Scan using quais_pkey on quais q (cost=0.00..8.27 rows=1 width=34) Index Cond: (q.id = me.id_quai) -> Seq Scan on message_111 (cost=0.00..4.72 rows=1 width=4) Filter: (id = $0) -> Seq Scan on message_110 (cost=0.00..2.96 rows=1 width=4) Filter: (id = $0) -> Seq Scan on message_106 (cost=0.00..6.48 rows=1 width=32) Filter: (id = $0) -> Nested Loop (cost=0.00..10.98 rows=1 width=35) -> Seq Scan on message_103 me (cost=0.00..2.67 rows=1 width=13) Filter: (id = $0) -> Index Scan using fournisseurs_pkey on fournisseurs f (cost=0.00..8.27 rows=1 width=26) Index Cond: (f.id = me.id_fournisseur) -> Nested Loop (cost=0.00..12.80 rows=1 width=40) -> Seq Scan on message_101 me (cost=0.00..4.50 rows=1 width=18) Filter: (id = $0) -> Index Scan using fournisseurs_pkey on fournisseurs f (cost=0.00..8.27 rows=1 width=26) Index Cond: (f.id = me.id_fournisseur) -> Nested Loop (cost=0.00..18.03 rows=1 width=40) -> Seq Scan on message_98 me (cost=0.00..9.73 rows=1 width=18) Filter: (id = $0) -> Index Scan using fournisseurs_pkey on fournisseurs f (cost=0.00..8.27 rows=1 width=26) Index Cond: (f.id = me.id_fournisseur) -> Nested Loop (cost=0.00..444.95 rows=1 width=141) -> Nested Loop (cost=0.00..436.41 rows=1 width=111) -> Nested Loop (cost=0.00..428.13 rows=1 width=75) -> Seq Scan on message_97 me (cost=0.00..419.85 rows=1 width=39) Filter: (id = $0) -> Index Scan using modes_pkey on modes md (cost=0.00..8.27 rows=1 width=40) Index Cond: (md.id = me.mode_) -> Index Scan using k_sc_pkey on k_sc sc (cost=0.00..8.27 rows=1 width=40) Index Cond: (sc.id = me.k_sc) -> Index Scan using quais_pkey on quais q (cost=0.00..8.27 rows=1 width=34) Index Cond: (q.id = me.quai_al) -> Seq Scan on message_95 (cost=0.00..12.64 rows=1 width=14) Filter: (id = $0) -> Nested Loop (cost=0.00..13051.89 rows=1 width=81) Join Filter: (me.seg_avt = s1.id) -> Nested Loop (cost=0.00..13045.92 rows=1 width=66) Join Filter: (me.seg_arr = s2.id) -> Seq Scan on message_91 me (cost=0.00..13040.19 rows=1 width=51) Filter: (id = $0) -> Seq Scan on segments s2 (cost=0.00..3.66 rows=166 width=23) -> Seq Scan on segments s1 (cost=0.00..3.66 rows=166 width=23) -> Seq Scan on message_86 (cost=0.00..32.28 rows=9 width=8) Filter: (id = $0) -> Nested Loop (cost=0.00..16.78 rows=1 width=516) -> Index Scan using association_categories_inconnues_mainid_key on association_categories_inconnues aci (cost=0.00..8.50 rows=1 width=2) Index Cond: (mainid = $0) -> Index Scan using categories_inconnues_pkey on categories_inconnues ci (cost=0.00..8.27 rows=1 width=520) Index Cond: (ci.id = aci.categorieid) (117 lignes)