CREATE TABLE veri (
autoinc integer generated by default as identity not null primary key,
geribildirimid integer,
ilantarihi timestamp,
kodno integer,
kademe integer,
il varchar(20),
ilce varchar(20),
sebeke varchar(255),
aciklama varchar(150),
kaynagagore varchar(15),
sureyegore varchar(15),
sebebegore varchar(20),
bildirimegore varchar(15),
baslangic timestamp,
bitis timestamp,
kesintisuresi numeric(12,2),
ek_iiog integer,
ek_iiag integer,
ek_idog integer,
ek_idag integer,
es_iiog numeric(12,2),
es_iiag numeric(12,2),
es_idog numeric(12,2),
es_idag numeric(12,2),
isletme varchar(30),
sure timestamp
);

CREATE TABLE sabitler (
kaynak varchar(20) not null primary key,
iiag integer,
iiog integer,
idag integer,
idog integer,
toplam integer
);

CREATE TABLE rapor_ek (
kaynak varchar(20) NOT NULL,
sebep varchar(20) NOT NULL,
CONSTRAINT "rapor_ek_pkey" PRIMARY KEY (kaynak, sebep)
);

CREATE TABLE "public"."veri" (
"autoinc" serial NOT NULL primary key,
"geribildirimid" int4,
"ilantarihi" timestamp(0),
"kodno" int4,
"kademe" int2,
"il" varchar(20) COLLATE "default",
"ilce" varchar(20) COLLATE "default",
"sebeke" varchar(255) COLLATE "default",
"aciklama" varchar(150) COLLATE "default",
"kaynagagore" varchar(15) COLLATE "default",
"sureyegore" varchar(15) COLLATE "default",
"sebebegore" varchar(20) COLLATE "default",
"bildirimegore" varchar(15) COLLATE "default",
"baslangic" timestamp(0),
"bitis" timestamp(0),
"kesintisuresi" numeric(12,2),
"ek_iiog" int4,
"ek_iiag" int4,
"ek_idog" int4,
"ek_idag" int4,
"es_iiog" numeric(12,2),
"es_iiag" numeric(12,2),
"es_idog" numeric(12,2),
"es_idag" numeric(12,2),
"isletme" varchar(30) COLLATE "default",
"sure" timestamp(0)
);

CREATE TABLE "public"."sabitler" (
"kaynak" varchar(20) COLLATE "default" NOT NULL,
"iiag" int4,
"iiog" int4,
"idag" int4,
"idog" int4,
"toplam" int4,
CONSTRAINT "sabitler_pkey" PRIMARY KEY ("kaynak")
);

CREATE TABLE "public"."rapor_ek" (
"kaynak" varchar(20) COLLATE "default" NOT NULL,
"sebep" varchar(20) COLLATE "default" NOT NULL,
CONSTRAINT "rapor_ek_pkey" PRIMARY KEY ("kaynak", "sebep")
);

Field #01: RAPOR_EK.KAYNAK Alias:KAYNAK Type:STRING(20)
Field #02: RAPOR_EK.SEBEP Alias:SEBEP Type:STRING(20)
Field #03: .COALESCE Alias:IAIK_OG Type:NUMERIC(18,2)
Field #04: .COALESCE Alias:IAIK_AG Type:NUMERIC(18,2)
Field #05: .COALESCE Alias:IAIK_TOPLAM Type:NUMERIC(18,2)
Field #06: .COALESCE Alias:IADK_OG Type:NUMERIC(18,2)
Field #07: .COALESCE Alias:IADK_AG Type:NUMERIC(18,2)
Field #08: .COALESCE Alias:IADK_TOPLAM Type:NUMERIC(18,2)
Field #09: .COALESCE Alias:GNLTOPLAM Type:NUMERIC(18,2)
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN (DT I INDEX (RDB$PRIMARY2))
PLAN JOIN (RAPOR_EK ORDER rapor_ek_pkey, SORT (DT M NATURAL))

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))