Merge Left Join (cost=6600.19..6610.98 rows=560 width=340) Merge Cond: (((rapor_ek.kaynak)::text = (m.kaynagagore)::text) AND ((rapor_ek.sebep)::text = (m.sebebegore)::text)) -> Sort (cost=41.16..42.56 rows=560 width=116) Sort Key: rapor_ek.kaynak, rapor_ek.sebep -> Seq Scan on rapor_ek (cost=0.00..15.60 rows=560 width=116) -> Materialize (cost=6559.03..6565.45 rows=31 width=256) -> GroupAggregate (cost=6559.03..6565.06 rows=31 width=256) Group Key: m.kaynagagore, m.sebebegore InitPlan 1 (returns $0) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 2 (returns $1) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_1 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 3 (returns $2) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_2 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 4 (returns $3) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_3 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 5 (returns $4) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_4 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 6 (returns $5) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_5 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 7 (returns $6) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_6 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 8 (returns $7) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_7 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) InitPlan 9 (returns $8) -> Aggregate (cost=2.43..2.44 rows=1 width=8) -> Seq Scan on sabitler i_8 (cost=0.00..2.42 rows=1 width=4) Filter: ((kaynak)::text = 'CİHANBEYLİ'::text) -> Sort (cost=6537.09..6537.27 rows=70 width=46) Sort Key: m.kaynagagore, m.sebebegore -> Seq Scan on veri m (cost=0.00..6534.94 rows=70 width=46) Filter: ((baslangic >= '2015-01-01 00:00:00'::timestamp without time zone) AND (bitis <= '2015-01-31 23:59:59.999'::timestamp without time zone) AND ((ilce)::text = 'CİHANBEYLİ'::text) AND ((bildirimegore)::text = 'Bildirimsiz'::text) AND ((sureyegore)::text = 'Uzun'::text))