nastaveni db

seq_page_cost = 10000.00        # measured on an arbitrary scale
#random_page_cost = 0.0001      # same scale as above
#seq_page_cost = 1.0                    # measured on an arbitrary scale
random_page_cost = 4.00                 # same scale as above
#cpu_tuple_cost = 0.01                  # same scale as above
#cpu_index_tuple_cost = 0.005           # same scale as above
#cpu_operator_cost = 0.0025             # same scale as above
effective_cache_size = 356MB

schema db

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

COMMENT ON SCHEMA public IS 'Standard public schema';

SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = true;

CREATE TABLE kotelna_v2 (
    id integer NOT NULL,
    cas timestamp without time zone,
    jazyk character(1),
    stanice smallint,
    adresa character(1),
    dotaz_prikaz character varying(5),
    dotaz_data character varying(20),
    odpoved_status smallint,
    odpoved_data character varying(20)
);

SET default_with_oids = false;

CREATE TABLE kotelna_v2_2006_10_1 ( CHECK (cas >= '1.10.2006' AND cas < '15.10.2006') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2006_10_2 ( CHECK (cas >= '15.10.2006' AND cas < '1.11.2006') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2006_11_1 ( CHECK (cas >= '1.11.2006' AND cas < '15.11.2006') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2006_11_2 ( CHECK (cas >= '15.11.2006' AND cas < '1.12.2006') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2006_12_1 ( CHECK (cas >= '1.12.2006' AND cas < '15.12.2006') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2006_12_2 ( CHECK (cas >= '15.12.2006' AND cas < '1.1.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_1_1 ( CHECK (cas >= '1.1.2007' AND cas < '15.1.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_1_2 ( CHECK (cas >= '15.1.2007' AND cas < '1.2.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_2_1 ( CHECK (cas >= '1.2.2007' AND cas < '15.2.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_2_2 ( CHECK (cas >= '15.2.2007' AND cas < '1.3.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_3_1 ( CHECK (cas >= '1.3.2007' AND cas < '15.3.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_3_2 ( CHECK (cas >= '15.3.2007' AND cas < '1.4.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_4_1 ( CHECK (cas >= '1.4.2007' AND cas < '15.4.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_4_2 ( CHECK (cas >= '15.4.2007' AND cas < '1.5.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_5_1 ( CHECK (cas >= '1.5.2007' AND cas < '15.5.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_5_2 ( CHECK (cas >= '15.5.2007' AND cas < '1.6.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_6_1 ( CHECK (cas >= '1.6.2007' AND cas < '15.6.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_6_2 ( CHECK (cas >= '15.6.2007' AND cas < '1.7.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_7_1 ( CHECK (cas >= '1.7.2007' AND cas < '15.7.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_7_2 ( CHECK (cas >= '15.7.2007' AND cas < '1.8.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_8_1 ( CHECK (cas >= '1.8.2007' AND cas < '15.8.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_8_2 ( CHECK (cas >= '15.8.2007' AND cas < '1.9.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_9_1 ( CHECK (cas >= '1.9.2007' AND cas < '15.9.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_9_2 ( CHECK (cas >= '15.9.2007' AND cas < '1.10.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_10_1 ( CHECK (cas >= '1.10.2007' AND cas < '15.10.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_10_2 ( CHECK (cas >= '15.10.2007' AND cas < '1.11.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_11_1 ( CHECK (cas >= '1.11.2007' AND cas < '15.11.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_11_2 ( CHECK (cas >= '15.11.2007' AND cas < '1.12.2007') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2007_12_1 ( CHECK (cas >= '1.12.2007' AND cas < '15.12.2007') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2007_12_2 ( CHECK (cas >= '15.12.2007' AND cas < '1.1.2008') ) INHERITS ( kotelna_v2 );


CREATE TABLE kotelna_v2_2008_1_1 ( CHECK (cas >= '1.1.2008' AND cas < '15.1.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_1_2 ( CHECK (cas >= '15.1.2008' AND cas < '1.2.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_2_1 ( CHECK (cas >= '1.2.2008' AND cas < '15.2.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_2_2 ( CHECK (cas >= '15.2.2008' AND cas < '1.3.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_3_1 ( CHECK (cas >= '1.3.2008' AND cas < '15.3.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_3_2 ( CHECK (cas >= '15.3.2008' AND cas < '1.4.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_4_1 ( CHECK (cas >= '1.4.2008' AND cas < '15.4.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_4_2 ( CHECK (cas >= '15.4.2008' AND cas < '1.5.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_5_1 ( CHECK (cas >= '1.5.2008' AND cas < '15.5.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_5_2 ( CHECK (cas >= '15.5.2008' AND cas < '1.6.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_6_1 ( CHECK (cas >= '1.6.2008' AND cas < '15.6.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_6_2 ( CHECK (cas >= '15.6.2008' AND cas < '1.7.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_7_1 ( CHECK (cas >= '1.7.2008' AND cas < '15.7.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_7_2 ( CHECK (cas >= '15.7.2008' AND cas < '1.8.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_8_1 ( CHECK (cas >= '1.8.2008' AND cas < '15.8.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_8_2 ( CHECK (cas >= '15.8.2008' AND cas < '1.9.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_9_1 ( CHECK (cas >= '1.9.2008' AND cas < '15.9.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_9_2 ( CHECK (cas >= '15.9.2008' AND cas < '1.10.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_10_1 ( CHECK (cas >= '1.10.2008' AND cas < '15.10.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_10_2 ( CHECK (cas >= '15.10.2008' AND cas < '1.11.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_11_1 ( CHECK (cas >= '1.11.2008' AND cas < '15.11.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_11_2 ( CHECK (cas >= '15.11.2008' AND cas < '1.12.2008') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2008_12_1 ( CHECK (cas >= '1.12.2008' AND cas < '15.12.2008') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2008_12_2 ( CHECK (cas >= '15.12.2008' AND cas < '1.1.2009') ) INHERITS ( kotelna_v2 );


CREATE TABLE kotelna_v2_2009_1_1 ( CHECK (cas >= '1.1.2009' AND cas < '15.1.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_1_2 ( CHECK (cas >= '15.1.2009' AND cas < '1.2.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_2_1 ( CHECK (cas >= '1.2.2009' AND cas < '15.2.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_2_2 ( CHECK (cas >= '15.2.2009' AND cas < '1.3.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_3_1 ( CHECK (cas >= '1.3.2009' AND cas < '15.3.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_3_2 ( CHECK (cas >= '15.3.2009' AND cas < '1.4.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_4_1 ( CHECK (cas >= '1.4.2009' AND cas < '15.4.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_4_2 ( CHECK (cas >= '15.4.2009' AND cas < '1.5.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_5_1 ( CHECK (cas >= '1.5.2009' AND cas < '15.5.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_5_2 ( CHECK (cas >= '15.5.2009' AND cas < '1.6.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_6_1 ( CHECK (cas >= '1.6.2009' AND cas < '15.6.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_6_2 ( CHECK (cas >= '15.6.2009' AND cas < '1.7.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_7_1 ( CHECK (cas >= '1.7.2009' AND cas < '15.7.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_7_2 ( CHECK (cas >= '15.7.2009' AND cas < '1.8.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_8_1 ( CHECK (cas >= '1.8.2009' AND cas < '15.8.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_8_2 ( CHECK (cas >= '15.8.2009' AND cas < '1.9.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_9_1 ( CHECK (cas >= '1.9.2009' AND cas < '15.9.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_9_2 ( CHECK (cas >= '15.9.2009' AND cas < '1.10.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_10_1 ( CHECK (cas >= '1.10.2009' AND cas < '15.10.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_10_2 ( CHECK (cas >= '15.10.2009' AND cas < '1.11.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_11_1 ( CHECK (cas >= '1.11.2009' AND cas < '15.11.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_11_2 ( CHECK (cas >= '15.11.2009' AND cas < '1.12.2009') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2009_12_1 ( CHECK (cas >= '1.12.2009' AND cas < '15.12.2009') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2009_12_2 ( CHECK (cas >= '15.12.2009' AND cas < '1.1.2010') ) INHERITS ( kotelna_v2 );


CREATE TABLE kotelna_v2_2010_1_1 ( CHECK (cas >= '1.1.2010' AND cas < '15.1.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_1_2 ( CHECK (cas >= '15.1.2010' AND cas < '1.2.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_2_1 ( CHECK (cas >= '1.2.2010' AND cas < '15.2.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_2_2 ( CHECK (cas >= '15.2.2010' AND cas < '1.3.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_3_1 ( CHECK (cas >= '1.3.2010' AND cas < '15.3.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_3_2 ( CHECK (cas >= '15.3.2010' AND cas < '1.4.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_4_1 ( CHECK (cas >= '1.4.2010' AND cas < '15.4.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_4_2 ( CHECK (cas >= '15.4.2010' AND cas < '1.5.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_5_1 ( CHECK (cas >= '1.5.2010' AND cas < '15.5.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_5_2 ( CHECK (cas >= '15.5.2010' AND cas < '1.6.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_6_1 ( CHECK (cas >= '1.6.2010' AND cas < '15.6.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_6_2 ( CHECK (cas >= '15.6.2010' AND cas < '1.7.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_7_1 ( CHECK (cas >= '1.7.2010' AND cas < '15.7.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_7_2 ( CHECK (cas >= '15.7.2010' AND cas < '1.8.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_8_1 ( CHECK (cas >= '1.8.2010' AND cas < '15.8.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_8_2 ( CHECK (cas >= '15.8.2010' AND cas < '1.9.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_9_1 ( CHECK (cas >= '1.9.2010' AND cas < '15.9.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_9_2 ( CHECK (cas >= '15.9.2010' AND cas < '1.10.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_10_1 ( CHECK (cas >= '1.10.2010' AND cas < '15.10.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_10_2 ( CHECK (cas >= '15.10.2010' AND cas < '1.11.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_11_1 ( CHECK (cas >= '1.11.2010' AND cas < '15.11.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_11_2 ( CHECK (cas >= '15.11.2010' AND cas < '1.12.2010') ) INHERITS ( kotelna_v2 );

CREATE TABLE kotelna_v2_2010_12_1 ( CHECK (cas >= '1.12.2010' AND cas < '15.12.2010') ) INHERITS ( kotelna_v2 );
CREATE TABLE kotelna_v2_2010_12_2 ( CHECK (cas >= '15.12.2010' AND cas < '1.1.2011') ) INHERITS ( kotelna_v2 );

------------
CREATE RULE kotelna_v2_2006_1_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.1.2006' AND cas < DATE '15.1.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_1_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_2_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.2.2006' AND cas < DATE '15.2.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_2_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_3_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.3.2006' AND cas < DATE '15.3.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_3_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_4_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.4.2006' AND cas < DATE '15.4.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_4_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_5_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.5.2006' AND cas < DATE '15.5.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_5_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_6_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.6.2006' AND cas < DATE '15.6.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_6_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_7_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.7.2006' AND cas < DATE '15.7.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_7_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_8_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.8.2006' AND cas < DATE '15.8.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_8_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_9_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.9.2006' AND cas < DATE '15.9.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_9_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_10_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.10.2006' AND cas < DATE '15.10.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_10_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_11_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.11.2006' AND cas < DATE '15.11.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_11_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_12_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.12.2006' AND cas < DATE '15.12.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_12_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);


CREATE RULE kotelna_v2_2006_1_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.1.2006' AND cas < DATE '1.2.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_1_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_2_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.2.2006' AND cas < DATE '1.3.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_2_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_3_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.3.2006' AND cas < DATE '1.4.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_3_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_4_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.4.2006' AND cas < DATE '1.5.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_4_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_5_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.5.2006' AND cas < DATE '1.6.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_5_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_6_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.6.2006' AND cas < DATE '1.7.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_6_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_7_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.7.2006' AND cas < DATE '1.8.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_7_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_8_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.8.2006' AND cas < DATE '1.9.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_8_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_9_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.9.2006' AND cas < DATE '1.10.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_9_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_10_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.10.2006' AND cas < DATE '1.11.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_10_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_11_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.11.2006' AND cas < DATE '1.12.2006' ) DO INSTEAD INSERT INTO kotelna_v2_2006_11_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2006_12_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.12.2006' AND cas < DATE '1.1.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2006_12_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);

------------------------------



CREATE RULE kotelna_v2_2007_1_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.1.2007' AND cas < DATE '15.1.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_1_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_2_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.2.2007' AND cas < DATE '15.2.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_2_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_3_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.3.2007' AND cas < DATE '15.3.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_3_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_4_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.4.2007' AND cas < DATE '15.4.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_4_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_5_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.5.2007' AND cas < DATE '15.5.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_5_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_6_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.6.2007' AND cas < DATE '15.6.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_6_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_7_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.7.2007' AND cas < DATE '15.7.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_7_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_8_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.8.2007' AND cas < DATE '15.8.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_8_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_9_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.9.2007' AND cas < DATE '15.9.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_9_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_10_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.10.2007' AND cas < DATE '15.10.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_10_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_11_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.11.2007' AND cas < DATE '15.11.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_11_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_12_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.12.2007' AND cas < DATE '15.12.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_12_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);


CREATE RULE kotelna_v2_2007_1_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.1.2007' AND cas < DATE '1.2.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_1_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_2_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.2.2007' AND cas < DATE '1.3.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_2_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_3_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.3.2007' AND cas < DATE '1.4.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_3_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_4_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.4.2007' AND cas < DATE '1.5.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_4_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_5_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.5.2007' AND cas < DATE '1.6.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_5_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_6_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.6.2007' AND cas < DATE '1.7.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_6_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_7_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.7.2007' AND cas < DATE '1.8.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_7_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_8_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.8.2007' AND cas < DATE '1.9.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_8_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_9_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.9.2007' AND cas < DATE '1.10.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_9_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_10_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.10.2007' AND cas < DATE '1.11.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_10_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_11_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.11.2007' AND cas < DATE '1.12.2007' ) DO INSTEAD INSERT INTO kotelna_v2_2007_11_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2007_12_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.12.2007' AND cas < DATE '1.1.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2007_12_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);

------------
CREATE RULE kotelna_v2_2008_1_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.1.2008' AND cas < DATE '15.1.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_1_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_2_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.2.2008' AND cas < DATE '15.2.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_2_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_3_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.3.2008' AND cas < DATE '15.3.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_3_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_4_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.4.2008' AND cas < DATE '15.4.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_4_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_5_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.5.2008' AND cas < DATE '15.5.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_5_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_6_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.6.2008' AND cas < DATE '15.6.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_6_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_7_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.7.2008' AND cas < DATE '15.7.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_7_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_8_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.8.2008' AND cas < DATE '15.8.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_8_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_9_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.9.2008' AND cas < DATE '15.9.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_9_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_10_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.10.2008' AND cas < DATE '15.10.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_10_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_11_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.11.2008' AND cas < DATE '15.11.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_11_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_12_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.12.2008' AND cas < DATE '15.12.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_12_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);


CREATE RULE kotelna_v2_2008_1_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.1.2008' AND cas < DATE '1.2.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_1_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_2_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.2.2008' AND cas < DATE '1.3.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_2_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_3_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.3.2008' AND cas < DATE '1.4.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_3_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_4_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.4.2008' AND cas < DATE '1.5.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_4_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_5_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.5.2008' AND cas < DATE '1.6.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_5_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_6_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.6.2008' AND cas < DATE '1.7.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_6_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_7_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.7.2008' AND cas < DATE '1.8.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_7_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_8_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.8.2008' AND cas < DATE '1.9.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_8_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_9_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.9.2008' AND cas < DATE '1.10.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_9_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_10_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.10.2008' AND cas < DATE '1.11.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_10_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_11_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.11.2008' AND cas < DATE '1.12.2008' ) DO INSTEAD INSERT INTO kotelna_v2_2008_11_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2008_12_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.12.2008' AND cas < DATE '1.1.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2008_12_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);

------------------------------


------------
CREATE RULE kotelna_v2_2009_1_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.1.2009' AND cas < DATE '15.1.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_1_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_2_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.2.2009' AND cas < DATE '15.2.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_2_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_3_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.3.2009' AND cas < DATE '15.3.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_3_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_4_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.4.2009' AND cas < DATE '15.4.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_4_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_5_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.5.2009' AND cas < DATE '15.5.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_5_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_6_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.6.2009' AND cas < DATE '15.6.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_6_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_7_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.7.2009' AND cas < DATE '15.7.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_7_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_8_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.8.2009' AND cas < DATE '15.8.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_8_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_9_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.9.2009' AND cas < DATE '15.9.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_9_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_10_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.10.2009' AND cas < DATE '15.10.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_10_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_11_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.11.2009' AND cas < DATE '15.11.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_11_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_12_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.12.2009' AND cas < DATE '15.12.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_12_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);


CREATE RULE kotelna_v2_2009_1_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.1.2009' AND cas < DATE '1.2.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_1_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_2_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.2.2009' AND cas < DATE '1.3.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_2_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_3_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.3.2009' AND cas < DATE '1.4.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_3_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_4_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.4.2009' AND cas < DATE '1.5.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_4_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_5_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.5.2009' AND cas < DATE '1.6.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_5_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_6_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.6.2009' AND cas < DATE '1.7.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_6_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_7_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.7.2009' AND cas < DATE '1.8.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_7_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_8_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.8.2009' AND cas < DATE '1.9.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_8_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_9_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.9.2009' AND cas < DATE '1.10.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_9_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_10_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.10.2009' AND cas < DATE '1.11.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_10_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_11_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.11.2009' AND cas < DATE '1.12.2009' ) DO INSTEAD INSERT INTO kotelna_v2_2009_11_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2009_12_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.12.2009' AND cas < DATE '1.1.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2009_12_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);

------------------------------
------------
CREATE RULE kotelna_v2_2010_1_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.1.2010' AND cas < DATE '15.1.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_1_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_2_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.2.2010' AND cas < DATE '15.2.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_2_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_3_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.3.2010' AND cas < DATE '15.3.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_3_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_4_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.4.2010' AND cas < DATE '15.4.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_4_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_5_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.5.2010' AND cas < DATE '15.5.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_5_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_6_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.6.2010' AND cas < DATE '15.6.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_6_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_7_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.7.2010' AND cas < DATE '15.7.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_7_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_8_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.8.2010' AND cas < DATE '15.8.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_8_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_9_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.9.2010' AND cas < DATE '15.9.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_9_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_10_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.10.2010' AND cas < DATE '15.10.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_10_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_11_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.11.2010' AND cas < DATE '15.11.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_11_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_12_1_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '1.12.2010' AND cas < DATE '15.12.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_12_1 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);


CREATE RULE kotelna_v2_2010_1_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.1.2010' AND cas < DATE '1.2.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_1_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_2_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.2.2010' AND cas < DATE '1.3.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_2_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_3_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.3.2010' AND cas < DATE '1.4.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_3_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_4_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.4.2010' AND cas < DATE '1.5.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_4_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_5_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.5.2010' AND cas < DATE '1.6.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_5_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_6_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.6.2010' AND cas < DATE '1.7.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_6_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_7_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.7.2010' AND cas < DATE '1.8.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_7_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_8_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.8.2010' AND cas < DATE '1.9.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_8_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_9_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.9.2010' AND cas < DATE '1.10.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_9_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_10_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.10.2010' AND cas < DATE '1.11.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_10_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_11_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.11.2010' AND cas < DATE '1.12.2010' ) DO INSTEAD INSERT INTO kotelna_v2_2010_11_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);
CREATE RULE kotelna_v2_2010_12_2_insert AS ON INSERT TO kotelna_v2 WHERE ( cas >= DATE '15.12.2010' AND cas < DATE '1.1.2011' ) DO INSTEAD INSERT INTO kotelna_v2_2010_12_2 VALUES (NEW.id,NEW.cas,NEW.jazyk,NEW.stanice,NEW.adresa,NEW.dotaz_prikaz,NEW.dotaz_data,NEW.odpoved_status,NEW.odpoved_data);

------------------------------
-
CREATE UNIQUE INDEX kotelna_v2_2006_1_1_unique ON kotelna_v2_2006_1_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_2_1_unique ON kotelna_v2_2006_2_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_3_1_unique ON kotelna_v2_2006_3_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_4_1_unique ON kotelna_v2_2006_4_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_5_1_unique ON kotelna_v2_2006_5_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_6_1_unique ON kotelna_v2_2006_6_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_7_1_unique ON kotelna_v2_2006_7_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_8_1_unique ON kotelna_v2_2006_8_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_9_1_unique ON kotelna_v2_2006_9_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_10_1_unique ON kotelna_v2_2006_10_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_11_1_unique ON kotelna_v2_2006_11_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_12_1_unique ON kotelna_v2_2006_12_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_1_2_unique ON kotelna_v2_2006_1_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_2_2_unique ON kotelna_v2_2006_2_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_3_2_unique ON kotelna_v2_2006_3_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_4_2_unique ON kotelna_v2_2006_4_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_5_2_unique ON kotelna_v2_2006_5_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_6_2_unique ON kotelna_v2_2006_6_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_7_2_unique ON kotelna_v2_2006_7_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_8_2_unique ON kotelna_v2_2006_8_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_9_2_unique ON kotelna_v2_2006_9_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_10_2_unique ON kotelna_v2_2006_10_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_11_2_unique ON kotelna_v2_2006_11_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2006_12_2_unique ON kotelna_v2_2006_12_2 (id);


CREATE UNIQUE INDEX kotelna_v2_2007_1_1_unique ON kotelna_v2_2007_1_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_2_1_unique ON kotelna_v2_2007_2_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_3_1_unique ON kotelna_v2_2007_3_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_4_1_unique ON kotelna_v2_2007_4_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_5_1_unique ON kotelna_v2_2007_5_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_6_1_unique ON kotelna_v2_2007_6_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_7_1_unique ON kotelna_v2_2007_7_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_8_1_unique ON kotelna_v2_2007_8_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_9_1_unique ON kotelna_v2_2007_9_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_10_1_unique ON kotelna_v2_2007_10_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_11_1_unique ON kotelna_v2_2007_11_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_12_1_unique ON kotelna_v2_2007_12_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_1_2_unique ON kotelna_v2_2007_1_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_2_2_unique ON kotelna_v2_2007_2_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_3_2_unique ON kotelna_v2_2007_3_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_4_2_unique ON kotelna_v2_2007_4_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_5_2_unique ON kotelna_v2_2007_5_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_6_2_unique ON kotelna_v2_2007_6_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_7_2_unique ON kotelna_v2_2007_7_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_8_2_unique ON kotelna_v2_2007_8_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_9_2_unique ON kotelna_v2_2007_9_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_10_2_unique ON kotelna_v2_2007_10_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_11_2_unique ON kotelna_v2_2007_11_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2007_12_2_unique ON kotelna_v2_2007_12_2 (id);


CREATE UNIQUE INDEX kotelna_v2_2008_1_1_unique ON kotelna_v2_2008_1_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_2_1_unique ON kotelna_v2_2008_2_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_3_1_unique ON kotelna_v2_2008_3_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_4_1_unique ON kotelna_v2_2008_4_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_5_1_unique ON kotelna_v2_2008_5_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_6_1_unique ON kotelna_v2_2008_6_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_7_1_unique ON kotelna_v2_2008_7_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_8_1_unique ON kotelna_v2_2008_8_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_9_1_unique ON kotelna_v2_2008_9_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_10_1_unique ON kotelna_v2_2008_10_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_11_1_unique ON kotelna_v2_2008_11_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_12_1_unique ON kotelna_v2_2008_12_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_1_2_unique ON kotelna_v2_2008_1_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_2_2_unique ON kotelna_v2_2008_2_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_3_2_unique ON kotelna_v2_2008_3_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_4_2_unique ON kotelna_v2_2008_4_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_5_2_unique ON kotelna_v2_2008_5_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_6_2_unique ON kotelna_v2_2008_6_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_7_2_unique ON kotelna_v2_2008_7_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_8_2_unique ON kotelna_v2_2008_8_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_9_2_unique ON kotelna_v2_2008_9_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_10_2_unique ON kotelna_v2_2008_10_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_11_2_unique ON kotelna_v2_2008_11_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2008_12_2_unique ON kotelna_v2_2008_12_2 (id);


CREATE UNIQUE INDEX kotelna_v2_2009_1_1_unique ON kotelna_v2_2009_1_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_2_1_unique ON kotelna_v2_2009_2_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_3_1_unique ON kotelna_v2_2009_3_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_4_1_unique ON kotelna_v2_2009_4_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_5_1_unique ON kotelna_v2_2009_5_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_6_1_unique ON kotelna_v2_2009_6_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_7_1_unique ON kotelna_v2_2009_7_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_8_1_unique ON kotelna_v2_2009_8_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_9_1_unique ON kotelna_v2_2009_9_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_10_1_unique ON kotelna_v2_2009_10_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_11_1_unique ON kotelna_v2_2009_11_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_12_1_unique ON kotelna_v2_2009_12_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_1_2_unique ON kotelna_v2_2009_1_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_2_2_unique ON kotelna_v2_2009_2_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_3_2_unique ON kotelna_v2_2009_3_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_4_2_unique ON kotelna_v2_2009_4_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_5_2_unique ON kotelna_v2_2009_5_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_6_2_unique ON kotelna_v2_2009_6_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_7_2_unique ON kotelna_v2_2009_7_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_8_2_unique ON kotelna_v2_2009_8_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_9_2_unique ON kotelna_v2_2009_9_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_10_2_unique ON kotelna_v2_2009_10_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_11_2_unique ON kotelna_v2_2009_11_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2009_12_2_unique ON kotelna_v2_2009_12_2 (id);


CREATE UNIQUE INDEX kotelna_v2_2010_1_1_unique ON kotelna_v2_2010_1_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_2_1_unique ON kotelna_v2_2010_2_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_3_1_unique ON kotelna_v2_2010_3_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_4_1_unique ON kotelna_v2_2010_4_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_5_1_unique ON kotelna_v2_2010_5_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_6_1_unique ON kotelna_v2_2010_6_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_7_1_unique ON kotelna_v2_2010_7_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_8_1_unique ON kotelna_v2_2010_8_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_9_1_unique ON kotelna_v2_2010_9_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_10_1_unique ON kotelna_v2_2010_10_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_11_1_unique ON kotelna_v2_2010_11_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_12_1_unique ON kotelna_v2_2010_12_1 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_1_2_unique ON kotelna_v2_2010_1_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_2_2_unique ON kotelna_v2_2010_2_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_3_2_unique ON kotelna_v2_2010_3_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_4_2_unique ON kotelna_v2_2010_4_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_5_2_unique ON kotelna_v2_2010_5_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_6_2_unique ON kotelna_v2_2010_6_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_7_2_unique ON kotelna_v2_2010_7_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_8_2_unique ON kotelna_v2_2010_8_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_9_2_unique ON kotelna_v2_2010_9_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_10_2_unique ON kotelna_v2_2010_10_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_11_2_unique ON kotelna_v2_2010_11_2 (id);
CREATE UNIQUE INDEX kotelna_v2_2010_12_2_unique ON kotelna_v2_2010_12_2 (id);

-----------------------------

CREATE  INDEX kotelna_v2_2006_1_1_cas ON kotelna_v2_2006_1_1 (cas);
CREATE  INDEX kotelna_v2_2006_2_1_cas ON kotelna_v2_2006_2_1 (cas);
CREATE  INDEX kotelna_v2_2006_3_1_cas ON kotelna_v2_2006_3_1 (cas);
CREATE  INDEX kotelna_v2_2006_4_1_cas ON kotelna_v2_2006_4_1 (cas);
CREATE  INDEX kotelna_v2_2006_5_1_cas ON kotelna_v2_2006_5_1 (cas);
CREATE  INDEX kotelna_v2_2006_6_1_cas ON kotelna_v2_2006_6_1 (cas);
CREATE  INDEX kotelna_v2_2006_7_1_cas ON kotelna_v2_2006_7_1 (cas);
CREATE  INDEX kotelna_v2_2006_8_1_cas ON kotelna_v2_2006_8_1 (cas);
CREATE  INDEX kotelna_v2_2006_9_1_cas ON kotelna_v2_2006_9_1 (cas);
CREATE  INDEX kotelna_v2_2006_10_1_cas ON kotelna_v2_2006_10_1 (cas);
CREATE  INDEX kotelna_v2_2006_11_1_cas ON kotelna_v2_2006_11_1 (cas);
CREATE  INDEX kotelna_v2_2006_12_1_cas ON kotelna_v2_2006_12_1 (cas);
CREATE  INDEX kotelna_v2_2006_1_2_cas ON kotelna_v2_2006_1_2 (cas);
CREATE  INDEX kotelna_v2_2006_2_2_cas ON kotelna_v2_2006_2_2 (cas);
CREATE  INDEX kotelna_v2_2006_3_2_cas ON kotelna_v2_2006_3_2 (cas);
CREATE  INDEX kotelna_v2_2006_4_2_cas ON kotelna_v2_2006_4_2 (cas);
CREATE  INDEX kotelna_v2_2006_5_2_cas ON kotelna_v2_2006_5_2 (cas);
CREATE  INDEX kotelna_v2_2006_6_2_cas ON kotelna_v2_2006_6_2 (cas);
CREATE  INDEX kotelna_v2_2006_7_2_cas ON kotelna_v2_2006_7_2 (cas);
CREATE  INDEX kotelna_v2_2006_8_2_cas ON kotelna_v2_2006_8_2 (cas);
CREATE  INDEX kotelna_v2_2006_9_2_cas ON kotelna_v2_2006_9_2 (cas);
CREATE  INDEX kotelna_v2_2006_10_2_cas ON kotelna_v2_2006_10_2 (cas);
CREATE  INDEX kotelna_v2_2006_11_2_cas ON kotelna_v2_2006_11_2 (cas);
CREATE  INDEX kotelna_v2_2006_12_2_cas ON kotelna_v2_2006_12_2 (cas);


CREATE  INDEX kotelna_v2_2007_1_1_cas ON kotelna_v2_2007_1_1 (cas);
CREATE  INDEX kotelna_v2_2007_2_1_cas ON kotelna_v2_2007_2_1 (cas);
CREATE  INDEX kotelna_v2_2007_3_1_cas ON kotelna_v2_2007_3_1 (cas);
CREATE  INDEX kotelna_v2_2007_4_1_cas ON kotelna_v2_2007_4_1 (cas);
CREATE  INDEX kotelna_v2_2007_5_1_cas ON kotelna_v2_2007_5_1 (cas);
CREATE  INDEX kotelna_v2_2007_6_1_cas ON kotelna_v2_2007_6_1 (cas);
CREATE  INDEX kotelna_v2_2007_7_1_cas ON kotelna_v2_2007_7_1 (cas);
CREATE  INDEX kotelna_v2_2007_8_1_cas ON kotelna_v2_2007_8_1 (cas);
CREATE  INDEX kotelna_v2_2007_9_1_cas ON kotelna_v2_2007_9_1 (cas);
CREATE  INDEX kotelna_v2_2007_10_1_cas ON kotelna_v2_2007_10_1 (cas);
CREATE  INDEX kotelna_v2_2007_11_1_cas ON kotelna_v2_2007_11_1 (cas);
CREATE  INDEX kotelna_v2_2007_12_1_cas ON kotelna_v2_2007_12_1 (cas);
CREATE  INDEX kotelna_v2_2007_1_2_cas ON kotelna_v2_2007_1_2 (cas);
CREATE  INDEX kotelna_v2_2007_2_2_cas ON kotelna_v2_2007_2_2 (cas);
CREATE  INDEX kotelna_v2_2007_3_2_cas ON kotelna_v2_2007_3_2 (cas);
CREATE  INDEX kotelna_v2_2007_4_2_cas ON kotelna_v2_2007_4_2 (cas);
CREATE  INDEX kotelna_v2_2007_5_2_cas ON kotelna_v2_2007_5_2 (cas);
CREATE  INDEX kotelna_v2_2007_6_2_cas ON kotelna_v2_2007_6_2 (cas);
CREATE  INDEX kotelna_v2_2007_7_2_cas ON kotelna_v2_2007_7_2 (cas);
CREATE  INDEX kotelna_v2_2007_8_2_cas ON kotelna_v2_2007_8_2 (cas);
CREATE  INDEX kotelna_v2_2007_9_2_cas ON kotelna_v2_2007_9_2 (cas);
CREATE  INDEX kotelna_v2_2007_10_2_cas ON kotelna_v2_2007_10_2 (cas);
CREATE  INDEX kotelna_v2_2007_11_2_cas ON kotelna_v2_2007_11_2 (cas);
CREATE  INDEX kotelna_v2_2007_12_2_cas ON kotelna_v2_2007_12_2 (cas);


CREATE  INDEX kotelna_v2_2008_1_1_cas ON kotelna_v2_2008_1_1 (cas);
CREATE  INDEX kotelna_v2_2008_2_1_cas ON kotelna_v2_2008_2_1 (cas);
CREATE  INDEX kotelna_v2_2008_3_1_cas ON kotelna_v2_2008_3_1 (cas);
CREATE  INDEX kotelna_v2_2008_4_1_cas ON kotelna_v2_2008_4_1 (cas);
CREATE  INDEX kotelna_v2_2008_5_1_cas ON kotelna_v2_2008_5_1 (cas);
CREATE  INDEX kotelna_v2_2008_6_1_cas ON kotelna_v2_2008_6_1 (cas);
CREATE  INDEX kotelna_v2_2008_7_1_cas ON kotelna_v2_2008_7_1 (cas);
CREATE  INDEX kotelna_v2_2008_8_1_cas ON kotelna_v2_2008_8_1 (cas);
CREATE  INDEX kotelna_v2_2008_9_1_cas ON kotelna_v2_2008_9_1 (cas);
CREATE  INDEX kotelna_v2_2008_10_1_cas ON kotelna_v2_2008_10_1 (cas);
CREATE  INDEX kotelna_v2_2008_11_1_cas ON kotelna_v2_2008_11_1 (cas);
CREATE  INDEX kotelna_v2_2008_12_1_cas ON kotelna_v2_2008_12_1 (cas);
CREATE  INDEX kotelna_v2_2008_1_2_cas ON kotelna_v2_2008_1_2 (cas);
CREATE  INDEX kotelna_v2_2008_2_2_cas ON kotelna_v2_2008_2_2 (cas);
CREATE  INDEX kotelna_v2_2008_3_2_cas ON kotelna_v2_2008_3_2 (cas);
CREATE  INDEX kotelna_v2_2008_4_2_cas ON kotelna_v2_2008_4_2 (cas);
CREATE  INDEX kotelna_v2_2008_5_2_cas ON kotelna_v2_2008_5_2 (cas);
CREATE  INDEX kotelna_v2_2008_6_2_cas ON kotelna_v2_2008_6_2 (cas);
CREATE  INDEX kotelna_v2_2008_7_2_cas ON kotelna_v2_2008_7_2 (cas);
CREATE  INDEX kotelna_v2_2008_8_2_cas ON kotelna_v2_2008_8_2 (cas);
CREATE  INDEX kotelna_v2_2008_9_2_cas ON kotelna_v2_2008_9_2 (cas);
CREATE  INDEX kotelna_v2_2008_10_2_cas ON kotelna_v2_2008_10_2 (cas);
CREATE  INDEX kotelna_v2_2008_11_2_cas ON kotelna_v2_2008_11_2 (cas);
CREATE  INDEX kotelna_v2_2008_12_2_cas ON kotelna_v2_2008_12_2 (cas);


CREATE  INDEX kotelna_v2_2009_1_1_cas ON kotelna_v2_2009_1_1 (cas);
CREATE  INDEX kotelna_v2_2009_2_1_cas ON kotelna_v2_2009_2_1 (cas);
CREATE  INDEX kotelna_v2_2009_3_1_cas ON kotelna_v2_2009_3_1 (cas);
CREATE  INDEX kotelna_v2_2009_4_1_cas ON kotelna_v2_2009_4_1 (cas);
CREATE  INDEX kotelna_v2_2009_5_1_cas ON kotelna_v2_2009_5_1 (cas);
CREATE  INDEX kotelna_v2_2009_6_1_cas ON kotelna_v2_2009_6_1 (cas);
CREATE  INDEX kotelna_v2_2009_7_1_cas ON kotelna_v2_2009_7_1 (cas);
CREATE  INDEX kotelna_v2_2009_8_1_cas ON kotelna_v2_2009_8_1 (cas);
CREATE  INDEX kotelna_v2_2009_9_1_cas ON kotelna_v2_2009_9_1 (cas);
CREATE  INDEX kotelna_v2_2009_10_1_cas ON kotelna_v2_2009_10_1 (cas);
CREATE  INDEX kotelna_v2_2009_11_1_cas ON kotelna_v2_2009_11_1 (cas);
CREATE  INDEX kotelna_v2_2009_12_1_cas ON kotelna_v2_2009_12_1 (cas);
CREATE  INDEX kotelna_v2_2009_1_2_cas ON kotelna_v2_2009_1_2 (cas);
CREATE  INDEX kotelna_v2_2009_2_2_cas ON kotelna_v2_2009_2_2 (cas);
CREATE  INDEX kotelna_v2_2009_3_2_cas ON kotelna_v2_2009_3_2 (cas);
CREATE  INDEX kotelna_v2_2009_4_2_cas ON kotelna_v2_2009_4_2 (cas);
CREATE  INDEX kotelna_v2_2009_5_2_cas ON kotelna_v2_2009_5_2 (cas);
CREATE  INDEX kotelna_v2_2009_6_2_cas ON kotelna_v2_2009_6_2 (cas);
CREATE  INDEX kotelna_v2_2009_7_2_cas ON kotelna_v2_2009_7_2 (cas);
CREATE  INDEX kotelna_v2_2009_8_2_cas ON kotelna_v2_2009_8_2 (cas);
CREATE  INDEX kotelna_v2_2009_9_2_cas ON kotelna_v2_2009_9_2 (cas);
CREATE  INDEX kotelna_v2_2009_10_2_cas ON kotelna_v2_2009_10_2 (cas);
CREATE  INDEX kotelna_v2_2009_11_2_cas ON kotelna_v2_2009_11_2 (cas);
CREATE  INDEX kotelna_v2_2009_12_2_cas ON kotelna_v2_2009_12_2 (cas);


CREATE  INDEX kotelna_v2_2010_1_1_cas ON kotelna_v2_2010_1_1 (cas);
CREATE  INDEX kotelna_v2_2010_2_1_cas ON kotelna_v2_2010_2_1 (cas);
CREATE  INDEX kotelna_v2_2010_3_1_cas ON kotelna_v2_2010_3_1 (cas);
CREATE  INDEX kotelna_v2_2010_4_1_cas ON kotelna_v2_2010_4_1 (cas);
CREATE  INDEX kotelna_v2_2010_5_1_cas ON kotelna_v2_2010_5_1 (cas);
CREATE  INDEX kotelna_v2_2010_6_1_cas ON kotelna_v2_2010_6_1 (cas);
CREATE  INDEX kotelna_v2_2010_7_1_cas ON kotelna_v2_2010_7_1 (cas);
CREATE  INDEX kotelna_v2_2010_8_1_cas ON kotelna_v2_2010_8_1 (cas);
CREATE  INDEX kotelna_v2_2010_9_1_cas ON kotelna_v2_2010_9_1 (cas);
CREATE  INDEX kotelna_v2_2010_10_1_cas ON kotelna_v2_2010_10_1 (cas);
CREATE  INDEX kotelna_v2_2010_11_1_cas ON kotelna_v2_2010_11_1 (cas);
CREATE  INDEX kotelna_v2_2010_12_1_cas ON kotelna_v2_2010_12_1 (cas);
CREATE  INDEX kotelna_v2_2010_1_2_cas ON kotelna_v2_2010_1_2 (cas);
CREATE  INDEX kotelna_v2_2010_2_2_cas ON kotelna_v2_2010_2_2 (cas);
CREATE  INDEX kotelna_v2_2010_3_2_cas ON kotelna_v2_2010_3_2 (cas);
CREATE  INDEX kotelna_v2_2010_4_2_cas ON kotelna_v2_2010_4_2 (cas);
CREATE  INDEX kotelna_v2_2010_5_2_cas ON kotelna_v2_2010_5_2 (cas);
CREATE  INDEX kotelna_v2_2010_6_2_cas ON kotelna_v2_2010_6_2 (cas);
CREATE  INDEX kotelna_v2_2010_7_2_cas ON kotelna_v2_2010_7_2 (cas);
CREATE  INDEX kotelna_v2_2010_8_2_cas ON kotelna_v2_2010_8_2 (cas);
CREATE  INDEX kotelna_v2_2010_9_2_cas ON kotelna_v2_2010_9_2 (cas);
CREATE  INDEX kotelna_v2_2010_10_2_cas ON kotelna_v2_2010_10_2 (cas);
CREATE  INDEX kotelna_v2_2010_11_2_cas ON kotelna_v2_2010_11_2 (cas);
CREATE  INDEX kotelna_v2_2010_12_2_cas ON kotelna_v2_2010_12_2 (cas);

------------------------------------------------------


CREATE  INDEX kotelna_v2_2006_1_1_stanice ON kotelna_v2_2006_1_1 (stanice);
CREATE  INDEX kotelna_v2_2006_2_1_stanice ON kotelna_v2_2006_2_1 (stanice);
CREATE  INDEX kotelna_v2_2006_3_1_stanice ON kotelna_v2_2006_3_1 (stanice);
CREATE  INDEX kotelna_v2_2006_4_1_stanice ON kotelna_v2_2006_4_1 (stanice);
CREATE  INDEX kotelna_v2_2006_5_1_stanice ON kotelna_v2_2006_5_1 (stanice);
CREATE  INDEX kotelna_v2_2006_6_1_stanice ON kotelna_v2_2006_6_1 (stanice);
CREATE  INDEX kotelna_v2_2006_7_1_stanice ON kotelna_v2_2006_7_1 (stanice);
CREATE  INDEX kotelna_v2_2006_8_1_stanice ON kotelna_v2_2006_8_1 (stanice);
CREATE  INDEX kotelna_v2_2006_9_1_stanice ON kotelna_v2_2006_9_1 (stanice);
CREATE  INDEX kotelna_v2_2006_10_1_stanice ON kotelna_v2_2006_10_1 (stanice);
CREATE  INDEX kotelna_v2_2006_11_1_stanice ON kotelna_v2_2006_11_1 (stanice);
CREATE  INDEX kotelna_v2_2006_12_1_stanice ON kotelna_v2_2006_12_1 (stanice);
CREATE  INDEX kotelna_v2_2006_1_2_stanice ON kotelna_v2_2006_1_2 (stanice);
CREATE  INDEX kotelna_v2_2006_2_2_stanice ON kotelna_v2_2006_2_2 (stanice);
CREATE  INDEX kotelna_v2_2006_3_2_stanice ON kotelna_v2_2006_3_2 (stanice);
CREATE  INDEX kotelna_v2_2006_4_2_stanice ON kotelna_v2_2006_4_2 (stanice);
CREATE  INDEX kotelna_v2_2006_5_2_stanice ON kotelna_v2_2006_5_2 (stanice);
CREATE  INDEX kotelna_v2_2006_6_2_stanice ON kotelna_v2_2006_6_2 (stanice);
CREATE  INDEX kotelna_v2_2006_7_2_stanice ON kotelna_v2_2006_7_2 (stanice);
CREATE  INDEX kotelna_v2_2006_8_2_stanice ON kotelna_v2_2006_8_2 (stanice);
CREATE  INDEX kotelna_v2_2006_9_2_stanice ON kotelna_v2_2006_9_2 (stanice);
CREATE  INDEX kotelna_v2_2006_10_2_stanice ON kotelna_v2_2006_10_2 (stanice);
CREATE  INDEX kotelna_v2_2006_11_2_stanice ON kotelna_v2_2006_11_2 (stanice);
CREATE  INDEX kotelna_v2_2006_12_2_stanice ON kotelna_v2_2006_12_2 (stanice);


CREATE  INDEX kotelna_v2_2007_1_1_stanice ON kotelna_v2_2007_1_1 (stanice);
CREATE  INDEX kotelna_v2_2007_2_1_stanice ON kotelna_v2_2007_2_1 (stanice);
CREATE  INDEX kotelna_v2_2007_3_1_stanice ON kotelna_v2_2007_3_1 (stanice);
CREATE  INDEX kotelna_v2_2007_4_1_stanice ON kotelna_v2_2007_4_1 (stanice);
CREATE  INDEX kotelna_v2_2007_5_1_stanice ON kotelna_v2_2007_5_1 (stanice);
CREATE  INDEX kotelna_v2_2007_6_1_stanice ON kotelna_v2_2007_6_1 (stanice);
CREATE  INDEX kotelna_v2_2007_7_1_stanice ON kotelna_v2_2007_7_1 (stanice);
CREATE  INDEX kotelna_v2_2007_8_1_stanice ON kotelna_v2_2007_8_1 (stanice);
CREATE  INDEX kotelna_v2_2007_9_1_stanice ON kotelna_v2_2007_9_1 (stanice);
CREATE  INDEX kotelna_v2_2007_10_1_stanice ON kotelna_v2_2007_10_1 (stanice);
CREATE  INDEX kotelna_v2_2007_11_1_stanice ON kotelna_v2_2007_11_1 (stanice);
CREATE  INDEX kotelna_v2_2007_12_1_stanice ON kotelna_v2_2007_12_1 (stanice);
CREATE  INDEX kotelna_v2_2007_1_2_stanice ON kotelna_v2_2007_1_2 (stanice);
CREATE  INDEX kotelna_v2_2007_2_2_stanice ON kotelna_v2_2007_2_2 (stanice);
CREATE  INDEX kotelna_v2_2007_3_2_stanice ON kotelna_v2_2007_3_2 (stanice);
CREATE  INDEX kotelna_v2_2007_4_2_stanice ON kotelna_v2_2007_4_2 (stanice);
CREATE  INDEX kotelna_v2_2007_5_2_stanice ON kotelna_v2_2007_5_2 (stanice);
CREATE  INDEX kotelna_v2_2007_6_2_stanice ON kotelna_v2_2007_6_2 (stanice);
CREATE  INDEX kotelna_v2_2007_7_2_stanice ON kotelna_v2_2007_7_2 (stanice);
CREATE  INDEX kotelna_v2_2007_8_2_stanice ON kotelna_v2_2007_8_2 (stanice);
CREATE  INDEX kotelna_v2_2007_9_2_stanice ON kotelna_v2_2007_9_2 (stanice);
CREATE  INDEX kotelna_v2_2007_10_2_stanice ON kotelna_v2_2007_10_2 (stanice);
CREATE  INDEX kotelna_v2_2007_11_2_stanice ON kotelna_v2_2007_11_2 (stanice);
CREATE  INDEX kotelna_v2_2007_12_2_stanice ON kotelna_v2_2007_12_2 (stanice);


CREATE  INDEX kotelna_v2_2008_1_1_stanice ON kotelna_v2_2008_1_1 (stanice);
CREATE  INDEX kotelna_v2_2008_2_1_stanice ON kotelna_v2_2008_2_1 (stanice);
CREATE  INDEX kotelna_v2_2008_3_1_stanice ON kotelna_v2_2008_3_1 (stanice);
CREATE  INDEX kotelna_v2_2008_4_1_stanice ON kotelna_v2_2008_4_1 (stanice);
CREATE  INDEX kotelna_v2_2008_5_1_stanice ON kotelna_v2_2008_5_1 (stanice);
CREATE  INDEX kotelna_v2_2008_6_1_stanice ON kotelna_v2_2008_6_1 (stanice);
CREATE  INDEX kotelna_v2_2008_7_1_stanice ON kotelna_v2_2008_7_1 (stanice);
CREATE  INDEX kotelna_v2_2008_8_1_stanice ON kotelna_v2_2008_8_1 (stanice);
CREATE  INDEX kotelna_v2_2008_9_1_stanice ON kotelna_v2_2008_9_1 (stanice);
CREATE  INDEX kotelna_v2_2008_10_1_stanice ON kotelna_v2_2008_10_1 (stanice);
CREATE  INDEX kotelna_v2_2008_11_1_stanice ON kotelna_v2_2008_11_1 (stanice);
CREATE  INDEX kotelna_v2_2008_12_1_stanice ON kotelna_v2_2008_12_1 (stanice);
CREATE  INDEX kotelna_v2_2008_1_2_stanice ON kotelna_v2_2008_1_2 (stanice);
CREATE  INDEX kotelna_v2_2008_2_2_stanice ON kotelna_v2_2008_2_2 (stanice);
CREATE  INDEX kotelna_v2_2008_3_2_stanice ON kotelna_v2_2008_3_2 (stanice);
CREATE  INDEX kotelna_v2_2008_4_2_stanice ON kotelna_v2_2008_4_2 (stanice);
CREATE  INDEX kotelna_v2_2008_5_2_stanice ON kotelna_v2_2008_5_2 (stanice);
CREATE  INDEX kotelna_v2_2008_6_2_stanice ON kotelna_v2_2008_6_2 (stanice);
CREATE  INDEX kotelna_v2_2008_7_2_stanice ON kotelna_v2_2008_7_2 (stanice);
CREATE  INDEX kotelna_v2_2008_8_2_stanice ON kotelna_v2_2008_8_2 (stanice);
CREATE  INDEX kotelna_v2_2008_9_2_stanice ON kotelna_v2_2008_9_2 (stanice);
CREATE  INDEX kotelna_v2_2008_10_2_stanice ON kotelna_v2_2008_10_2 (stanice);
CREATE  INDEX kotelna_v2_2008_11_2_stanice ON kotelna_v2_2008_11_2 (stanice);
CREATE  INDEX kotelna_v2_2008_12_2_stanice ON kotelna_v2_2008_12_2 (stanice);


CREATE  INDEX kotelna_v2_2009_1_1_stanice ON kotelna_v2_2009_1_1 (stanice);
CREATE  INDEX kotelna_v2_2009_2_1_stanice ON kotelna_v2_2009_2_1 (stanice);
CREATE  INDEX kotelna_v2_2009_3_1_stanice ON kotelna_v2_2009_3_1 (stanice);
CREATE  INDEX kotelna_v2_2009_4_1_stanice ON kotelna_v2_2009_4_1 (stanice);
CREATE  INDEX kotelna_v2_2009_5_1_stanice ON kotelna_v2_2009_5_1 (stanice);
CREATE  INDEX kotelna_v2_2009_6_1_stanice ON kotelna_v2_2009_6_1 (stanice);
CREATE  INDEX kotelna_v2_2009_7_1_stanice ON kotelna_v2_2009_7_1 (stanice);
CREATE  INDEX kotelna_v2_2009_8_1_stanice ON kotelna_v2_2009_8_1 (stanice);
CREATE  INDEX kotelna_v2_2009_9_1_stanice ON kotelna_v2_2009_9_1 (stanice);
CREATE  INDEX kotelna_v2_2009_10_1_stanice ON kotelna_v2_2009_10_1 (stanice);
CREATE  INDEX kotelna_v2_2009_11_1_stanice ON kotelna_v2_2009_11_1 (stanice);
CREATE  INDEX kotelna_v2_2009_12_1_stanice ON kotelna_v2_2009_12_1 (stanice);
CREATE  INDEX kotelna_v2_2009_1_2_stanice ON kotelna_v2_2009_1_2 (stanice);
CREATE  INDEX kotelna_v2_2009_2_2_stanice ON kotelna_v2_2009_2_2 (stanice);
CREATE  INDEX kotelna_v2_2009_3_2_stanice ON kotelna_v2_2009_3_2 (stanice);
CREATE  INDEX kotelna_v2_2009_4_2_stanice ON kotelna_v2_2009_4_2 (stanice);
CREATE  INDEX kotelna_v2_2009_5_2_stanice ON kotelna_v2_2009_5_2 (stanice);
CREATE  INDEX kotelna_v2_2009_6_2_stanice ON kotelna_v2_2009_6_2 (stanice);
CREATE  INDEX kotelna_v2_2009_7_2_stanice ON kotelna_v2_2009_7_2 (stanice);
CREATE  INDEX kotelna_v2_2009_8_2_stanice ON kotelna_v2_2009_8_2 (stanice);
CREATE  INDEX kotelna_v2_2009_9_2_stanice ON kotelna_v2_2009_9_2 (stanice);
CREATE  INDEX kotelna_v2_2009_10_2_stanice ON kotelna_v2_2009_10_2 (stanice);
CREATE  INDEX kotelna_v2_2009_11_2_stanice ON kotelna_v2_2009_11_2 (stanice);
CREATE  INDEX kotelna_v2_2009_12_2_stanice ON kotelna_v2_2009_12_2 (stanice);


CREATE  INDEX kotelna_v2_2010_1_1_stanice ON kotelna_v2_2010_1_1 (stanice);
CREATE  INDEX kotelna_v2_2010_2_1_stanice ON kotelna_v2_2010_2_1 (stanice);
CREATE  INDEX kotelna_v2_2010_3_1_stanice ON kotelna_v2_2010_3_1 (stanice);
CREATE  INDEX kotelna_v2_2010_4_1_stanice ON kotelna_v2_2010_4_1 (stanice);
CREATE  INDEX kotelna_v2_2010_5_1_stanice ON kotelna_v2_2010_5_1 (stanice);
CREATE  INDEX kotelna_v2_2010_6_1_stanice ON kotelna_v2_2010_6_1 (stanice);
CREATE  INDEX kotelna_v2_2010_7_1_stanice ON kotelna_v2_2010_7_1 (stanice);
CREATE  INDEX kotelna_v2_2010_8_1_stanice ON kotelna_v2_2010_8_1 (stanice);
CREATE  INDEX kotelna_v2_2010_9_1_stanice ON kotelna_v2_2010_9_1 (stanice);
CREATE  INDEX kotelna_v2_2010_10_1_stanice ON kotelna_v2_2010_10_1 (stanice);
CREATE  INDEX kotelna_v2_2010_11_1_stanice ON kotelna_v2_2010_11_1 (stanice);
CREATE  INDEX kotelna_v2_2010_12_1_stanice ON kotelna_v2_2010_12_1 (stanice);
CREATE  INDEX kotelna_v2_2010_1_2_stanice ON kotelna_v2_2010_1_2 (stanice);
CREATE  INDEX kotelna_v2_2010_2_2_stanice ON kotelna_v2_2010_2_2 (stanice);
CREATE  INDEX kotelna_v2_2010_3_2_stanice ON kotelna_v2_2010_3_2 (stanice);
CREATE  INDEX kotelna_v2_2010_4_2_stanice ON kotelna_v2_2010_4_2 (stanice);
CREATE  INDEX kotelna_v2_2010_5_2_stanice ON kotelna_v2_2010_5_2 (stanice);
CREATE  INDEX kotelna_v2_2010_6_2_stanice ON kotelna_v2_2010_6_2 (stanice);
CREATE  INDEX kotelna_v2_2010_7_2_stanice ON kotelna_v2_2010_7_2 (stanice);
CREATE  INDEX kotelna_v2_2010_8_2_stanice ON kotelna_v2_2010_8_2 (stanice);
CREATE  INDEX kotelna_v2_2010_9_2_stanice ON kotelna_v2_2010_9_2 (stanice);
CREATE  INDEX kotelna_v2_2010_10_2_stanice ON kotelna_v2_2010_10_2 (stanice);
CREATE  INDEX kotelna_v2_2010_11_2_stanice ON kotelna_v2_2010_11_2 (stanice);
CREATE  INDEX kotelna_v2_2010_12_2_stanice ON kotelna_v2_2010_12_2 (stanice);


priklad dat


kotelna=# SELECT * FROM kotelna_v2_2010_12_1 WHERE id=265528894;
    id     |         cas         | jazyk | stanice | adresa | dotaz_prikaz | dotaz_data | odpoved_status | odpoved_data 
-----------+---------------------+-------+---------+--------+--------------+------------+----------------+--------------
 265528894 | 14.12.2010 23:58:48 | B     |      20 | D      | TR           |            |              0 | 61.1
(1 řádka)

kotelna=# EXPLAIN ANALYZE SELECT * FROM kotelna_v2_2010_12_1 WHERE id=265528894;
                                                                    QUERY PLAN                                                                     
---------------------------------------------------------------------------------------------------------------------------------------------------
 Index Scan using kotelna_v2_2010_12_1_unique on kotelna_v2_2010_12_1  (cost=0.00..8.61 rows=1 width=85) (actual time=0.010..0.012 rows=1 loops=1)
   Index Cond: (id = 265528894)
 Total runtime: 0.055 ms
(3 rows)

kotelna=# 


explain 1

kotelna=# explain analyze SELECT id FROM kotelna_v2_2010_12_1 order by id desc limit 1;
                                                                                  QUERY PLAN                                                                                   
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.00..90.71 rows=1 width=4) (actual time=0.018..0.019 rows=1 loops=1)
   ->  Index Scan Backward using kotelna_v2_2010_12_1_unique on kotelna_v2_2010_12_1  (cost=0.00..282310394.91 rows=3112235 width=4) (actual time=0.016..0.016 rows=1 loops=1)
 Total runtime: 0.040 ms
(3 rows)

kotelna=# 





explain 2


kotelna=# explain analyze SELECT id FROM kotelna_v2 where id=11111;
                                                                               QUERY PLAN                                                                                
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Result  (cost=0.00..20868.28 rows=103 width=4) (actual time=0.672..0.672 rows=0 loops=1)
   ->  Append  (cost=0.00..20868.28 rows=103 width=4) (actual time=0.669..0.669 rows=0 loops=1)
         ->  Seq Scan on kotelna_v2  (cost=0.00..20001.55 rows=1 width=4) (actual time=0.034..0.034 rows=0 loops=1)
               Filter: (id = 11111)
         ->  Index Scan using kotelna_v2_2006_10_1_unique on kotelna_v2_2006_10_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2006_10_2_unique on kotelna_v2_2006_10_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2006_11_1_unique on kotelna_v2_2006_11_1 kotelna_v2  (cost=0.00..8.31 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2006_11_2_unique on kotelna_v2_2006_11_2 kotelna_v2  (cost=0.00..8.46 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2006_12_1_unique on kotelna_v2_2006_12_1 kotelna_v2  (cost=0.00..8.52 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2006_12_2_unique on kotelna_v2_2006_12_2 kotelna_v2  (cost=0.00..8.62 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_10_1_unique on kotelna_v2_2007_10_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_10_2_unique on kotelna_v2_2007_10_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_11_1_unique on kotelna_v2_2007_11_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_11_2_unique on kotelna_v2_2007_11_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_12_1_unique on kotelna_v2_2007_12_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_12_2_unique on kotelna_v2_2007_12_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_1_1_unique on kotelna_v2_2007_1_1 kotelna_v2  (cost=0.00..8.53 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_1_2_unique on kotelna_v2_2007_1_2 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_2_1_unique on kotelna_v2_2007_2_1 kotelna_v2  (cost=0.00..8.43 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_2_2_unique on kotelna_v2_2007_2_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_3_1_unique on kotelna_v2_2007_3_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_3_2_unique on kotelna_v2_2007_3_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_4_1_unique on kotelna_v2_2007_4_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_4_2_unique on kotelna_v2_2007_4_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_5_1_unique on kotelna_v2_2007_5_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_5_2_unique on kotelna_v2_2007_5_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_6_1_unique on kotelna_v2_2007_6_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_6_2_unique on kotelna_v2_2007_6_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_7_1_unique on kotelna_v2_2007_7_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_7_2_unique on kotelna_v2_2007_7_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_8_1_unique on kotelna_v2_2007_8_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_8_2_unique on kotelna_v2_2007_8_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_9_1_unique on kotelna_v2_2007_9_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2007_9_2_unique on kotelna_v2_2007_9_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_10_1_unique on kotelna_v2_2008_10_1 kotelna_v2  (cost=0.00..8.55 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_10_2_unique on kotelna_v2_2008_10_2 kotelna_v2  (cost=0.00..8.64 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_11_1_unique on kotelna_v2_2008_11_1 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_11_2_unique on kotelna_v2_2008_11_2 kotelna_v2  (cost=0.00..8.63 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_12_1_unique on kotelna_v2_2008_12_1 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_12_2_unique on kotelna_v2_2008_12_2 kotelna_v2  (cost=0.00..8.65 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_1_1_unique on kotelna_v2_2008_1_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_1_2_unique on kotelna_v2_2008_1_2 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_2_1_unique on kotelna_v2_2008_2_1 kotelna_v2  (cost=0.00..8.27 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_2_2_unique on kotelna_v2_2008_2_2 kotelna_v2  (cost=0.00..8.42 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_3_1_unique on kotelna_v2_2008_3_1 kotelna_v2  (cost=0.00..8.47 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_3_2_unique on kotelna_v2_2008_3_2 kotelna_v2  (cost=0.00..8.56 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_4_1_unique on kotelna_v2_2008_4_1 kotelna_v2  (cost=0.00..8.55 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_4_2_unique on kotelna_v2_2008_4_2 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_5_1_unique on kotelna_v2_2008_5_1 kotelna_v2  (cost=0.00..8.53 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_5_2_unique on kotelna_v2_2008_5_2 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_6_1_unique on kotelna_v2_2008_6_1 kotelna_v2  (cost=0.00..8.53 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_6_2_unique on kotelna_v2_2008_6_2 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_7_1_unique on kotelna_v2_2008_7_1 kotelna_v2  (cost=0.00..8.54 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_7_2_unique on kotelna_v2_2008_7_2 kotelna_v2  (cost=0.00..8.61 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_8_1_unique on kotelna_v2_2008_8_1 kotelna_v2  (cost=0.00..8.50 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_8_2_unique on kotelna_v2_2008_8_2 kotelna_v2  (cost=0.00..8.61 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_9_1_unique on kotelna_v2_2008_9_1 kotelna_v2  (cost=0.00..8.55 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2008_9_2_unique on kotelna_v2_2008_9_2 kotelna_v2  (cost=0.00..8.56 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_10_1_unique on kotelna_v2_2009_10_1 kotelna_v2  (cost=0.00..8.57 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_10_2_unique on kotelna_v2_2009_10_2 kotelna_v2  (cost=0.00..8.65 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_11_1_unique on kotelna_v2_2009_11_1 kotelna_v2  (cost=0.00..8.58 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_11_2_unique on kotelna_v2_2009_11_2 kotelna_v2  (cost=0.00..8.62 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_12_1_unique on kotelna_v2_2009_12_1 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_12_2_unique on kotelna_v2_2009_12_2 kotelna_v2  (cost=0.00..8.68 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_1_1_unique on kotelna_v2_2009_1_1 kotelna_v2  (cost=0.00..8.57 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_1_2_unique on kotelna_v2_2009_1_2 kotelna_v2  (cost=0.00..8.64 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_2_1_unique on kotelna_v2_2009_2_1 kotelna_v2  (cost=0.00..8.58 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_2_2_unique on kotelna_v2_2009_2_2 kotelna_v2  (cost=0.00..8.57 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_3_1_unique on kotelna_v2_2009_3_1 kotelna_v2  (cost=0.00..8.55 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_3_2_unique on kotelna_v2_2009_3_2 kotelna_v2  (cost=0.00..8.63 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_4_1_unique on kotelna_v2_2009_4_1 kotelna_v2  (cost=0.00..8.58 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_4_2_unique on kotelna_v2_2009_4_2 kotelna_v2  (cost=0.00..8.62 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_5_1_unique on kotelna_v2_2009_5_1 kotelna_v2  (cost=0.00..8.54 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_5_2_unique on kotelna_v2_2009_5_2 kotelna_v2  (cost=0.00..8.64 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_6_1_unique on kotelna_v2_2009_6_1 kotelna_v2  (cost=0.00..8.57 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_6_2_unique on kotelna_v2_2009_6_2 kotelna_v2  (cost=0.00..8.61 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_7_1_unique on kotelna_v2_2009_7_1 kotelna_v2  (cost=0.00..8.57 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_7_2_unique on kotelna_v2_2009_7_2 kotelna_v2  (cost=0.00..8.57 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_8_1_unique on kotelna_v2_2009_8_1 kotelna_v2  (cost=0.00..8.52 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_8_2_unique on kotelna_v2_2009_8_2 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_9_1_unique on kotelna_v2_2009_9_1 kotelna_v2  (cost=0.00..8.56 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2009_9_2_unique on kotelna_v2_2009_9_2 kotelna_v2  (cost=0.00..8.62 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_10_1_unique on kotelna_v2_2010_10_1 kotelna_v2  (cost=0.00..8.61 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_10_2_unique on kotelna_v2_2010_10_2 kotelna_v2  (cost=0.00..8.69 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_11_1_unique on kotelna_v2_2010_11_1 kotelna_v2  (cost=0.00..8.62 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_11_2_unique on kotelna_v2_2010_11_2 kotelna_v2  (cost=0.00..8.66 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_12_1_unique on kotelna_v2_2010_12_1 kotelna_v2  (cost=0.00..8.61 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_12_2_unique on kotelna_v2_2010_12_2 kotelna_v2  (cost=0.00..8.66 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_1_1_unique on kotelna_v2_2010_1_1 kotelna_v2  (cost=0.00..8.61 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_1_2_unique on kotelna_v2_2010_1_2 kotelna_v2  (cost=0.00..8.68 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_2_1_unique on kotelna_v2_2010_2_1 kotelna_v2  (cost=0.00..8.61 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_2_2_unique on kotelna_v2_2010_2_2 kotelna_v2  (cost=0.00..8.60 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_3_1_unique on kotelna_v2_2010_3_1 kotelna_v2  (cost=0.00..8.60 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_3_2_unique on kotelna_v2_2010_3_2 kotelna_v2  (cost=0.00..8.68 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_4_1_unique on kotelna_v2_2010_4_1 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_4_2_unique on kotelna_v2_2010_4_2 kotelna_v2  (cost=0.00..8.63 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_5_1_unique on kotelna_v2_2010_5_1 kotelna_v2  (cost=0.00..8.57 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_5_2_unique on kotelna_v2_2010_5_2 kotelna_v2  (cost=0.00..8.65 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_6_1_unique on kotelna_v2_2010_6_1 kotelna_v2  (cost=0.00..8.56 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_6_2_unique on kotelna_v2_2010_6_2 kotelna_v2  (cost=0.00..8.54 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_7_1_unique on kotelna_v2_2010_7_1 kotelna_v2  (cost=0.00..8.50 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_7_2_unique on kotelna_v2_2010_7_2 kotelna_v2  (cost=0.00..8.55 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_8_1_unique on kotelna_v2_2010_8_1 kotelna_v2  (cost=0.00..8.39 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_8_2_unique on kotelna_v2_2010_8_2 kotelna_v2  (cost=0.00..8.49 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_9_1_unique on kotelna_v2_2010_9_1 kotelna_v2  (cost=0.00..8.53 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
         ->  Index Scan using kotelna_v2_2010_9_2_unique on kotelna_v2_2010_9_2 kotelna_v2  (cost=0.00..8.59 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)
               Index Cond: (id = 11111)
 Total runtime: 2.157 ms
(209 rows)

kotelna=# 


explain 3




kotelna=# explain analyze SELECT id FROM kotelna_v2 order by id desc limit 1;
                                                                               QUERY PLAN                                                                                
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=19409225392.74..19409225392.74 rows=1 width=4) (actual time=1321043.047..1321043.048 rows=1 loops=1)
   ->  Sort  (cost=19409225392.74..19409759624.86 rows=213692849 width=4) (actual time=1321043.044..1321043.044 rows=1 loops=1)
         Sort Key: public.kotelna_v2.id
         Sort Method:  top-N heapsort  Memory: 25kB
         ->  Result  (cost=0.00..19408156928.49 rows=213692849 width=4) (actual time=0.013..1100125.292 rows=213684049 loops=1)
               ->  Append  (cost=0.00..19408156928.49 rows=213692849 width=4) (actual time=0.011..708859.833 rows=213684049 loops=1)
                     ->  Seq Scan on kotelna_v2  (cost=0.00..20001.24 rows=124 width=4) (actual time=0.009..0.146 rows=124 loops=1)
                     ->  Seq Scan on kotelna_v2_2006_10_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2006_10_2 kotelna_v2  (cost=0.00..30002.60 rows=260 width=4) (actual time=0.005..0.268 rows=260 loops=1)
                     ->  Seq Scan on kotelna_v2_2006_11_1 kotelna_v2  (cost=0.00..35143759.32 rows=375932 width=4) (actual time=0.006..409.636 rows=375932 loops=1)
                     ->  Seq Scan on kotelna_v2_2006_11_2 kotelna_v2  (cost=0.00..166947877.32 rows=1787732 width=4) (actual time=15.993..2200.440 rows=1787732 loops=1)
                     ->  Seq Scan on kotelna_v2_2006_12_1 kotelna_v2  (cost=0.00..218153352.27 rows=2335227 width=4) (actual time=7.003..2902.375 rows=2335227 loops=1)
                     ->  Seq Scan on kotelna_v2_2006_12_2 kotelna_v2  (cost=0.00..300802217.93 rows=3221793 width=4) (actual time=28.895..3907.272 rows=3221793 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_10_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_10_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_11_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_11_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_12_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_12_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_1_1 kotelna_v2  (cost=0.00..220683633.84 rows=2363384 width=4) (actual time=14.013..2907.498 rows=2363384 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_1_2 kotelna_v2  (cost=0.00..272889525.78 rows=2952578 width=4) (actual time=17.646..3562.091 rows=2952578 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_2_1 kotelna_v2  (cost=0.00..134194821.93 rows=1482193 width=4) (actual time=14.305..1760.148 rows=1482193 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_2_2 kotelna_v2  (cost=0.00..5540610.96 rows=61096 width=4) (actual time=0.005..64.543 rows=61096 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_3_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_3_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_4_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_4_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_5_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_5_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_6_1 kotelna_v2  (cost=0.00..1460158.69 rows=15869 width=4) (actual time=0.005..16.538 rows=15869 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_6_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_7_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_7_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_8_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_8_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_9_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2007_9_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_10_1 kotelna_v2  (cost=0.00..236105837.64 rows=2583764 width=4) (actual time=11.478..6961.089 rows=2583764 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_10_2 kotelna_v2  (cost=0.00..308934244.80 rows=3424480 width=4) (actual time=10.560..4283.673 rows=3424480 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_11_1 kotelna_v2  (cost=0.00..261949020.75 rows=2902075 width=4) (actual time=9.480..3751.600 rows=2902075 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_11_2 kotelna_v2  (cost=0.00..298713139.67 rows=3313967 width=4) (actual time=6.445..4235.461 rows=3313967 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_12_1 kotelna_v2  (cost=0.00..263569314.67 rows=2931467 width=4) (actual time=12.753..4735.466 rows=2931467 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_12_2 kotelna_v2  (cost=0.00..314284799.85 rows=3479985 width=4) (actual time=8.083..5816.575 rows=3479985 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_1_1 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_1_2 kotelna_v2  (cost=0.00..100004.00 rows=400 width=4) (actual time=0.002..0.002 rows=0 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_2_1 kotelna_v2  (cost=0.00..920101.10 rows=10110 width=4) (actual time=0.005..10.795 rows=10110 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_2_2 kotelna_v2  (cost=0.00..130624304.30 rows=1430430 width=4) (actual time=17.604..1865.302 rows=1430430 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_3_1 kotelna_v2  (cost=0.00..171078791.72 rows=1879172 width=4) (actual time=8.768..2297.855 rows=1879172 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_3_2 kotelna_v2  (cost=0.00..244626804.31 rows=2680431 width=4) (actual time=9.516..3216.319 rows=2680431 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_4_1 kotelna_v2  (cost=0.00..234685775.42 rows=2577542 width=4) (actual time=8.129..3095.335 rows=2577542 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_4_2 kotelna_v2  (cost=0.00..265149020.32 rows=2902032 width=4) (actual time=6.791..3613.081 rows=2902032 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_5_1 kotelna_v2  (cost=0.00..224284374.08 rows=2437408 width=4) (actual time=15.276..3017.181 rows=2437408 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_5_2 kotelna_v2  (cost=0.00..269699277.50 rows=2927750 width=4) (actual time=0.489..3939.537 rows=2927750 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_6_1 kotelna_v2  (cost=0.00..216303506.66 rows=2350666 width=4) (actual time=2.384..3099.710 rows=2350666 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_6_2 kotelna_v2  (cost=0.00..269399286.32 rows=2928632 width=4) (actual time=7.342..14550.119 rows=2928632 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_7_1 kotelna_v2  (cost=0.00..232665282.45 rows=2528245 width=4) (actual time=13.188..3481.806 rows=2528245 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_7_2 kotelna_v2  (cost=0.00..282800792.11 rows=3079211 width=4) (actual time=14.074..4258.484 rows=3079211 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_8_1 kotelna_v2  (cost=0.00..197881553.76 rows=2155376 width=4) (actual time=10.781..4076.212 rows=2155376 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_8_2 kotelna_v2  (cost=0.00..288221337.76 rows=3133776 width=4) (actual time=24.128..5107.006 rows=3133776 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_9_1 kotelna_v2  (cost=0.00..237495847.36 rows=2584736 width=4) (actual time=10.951..6734.715 rows=2584736 loops=1)
                     ->  Seq Scan on kotelna_v2_2008_9_2 kotelna_v2  (cost=0.00..245756857.87 rows=2685787 width=4) (actual time=16.729..4396.297 rows=2685787 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_10_1 kotelna_v2  (cost=0.00..250797686.02 rows=2768602 width=4) (actual time=12.601..4174.694 rows=2768602 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_10_2 kotelna_v2  (cost=0.00..312294672.44 rows=3467244 width=4) (actual time=19.246..5822.376 rows=3467244 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_11_1 kotelna_v2  (cost=0.00..255668457.22 rows=2845722 width=4) (actual time=15.713..4292.588 rows=2845722 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_11_2 kotelna_v2  (cost=0.00..293752535.61 rows=3253561 width=4) (actual time=15.656..5621.463 rows=3253561 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_12_1 kotelna_v2  (cost=0.00..264919490.57 rows=2949057 width=4) (actual time=20.932..4666.841 rows=2949057 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_12_2 kotelna_v2  (cost=0.00..340657735.89 rows=3773589 width=4) (actual time=17.941..4842.658 rows=3773589 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_1_1 kotelna_v2  (cost=0.00..248697281.93 rows=2728193 width=4) (actual time=17.558..5542.979 rows=2728193 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_1_2 kotelna_v2  (cost=0.00..310614389.07 rows=3438907 width=4) (actual time=12.804..4242.469 rows=3438907 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_2_1 kotelna_v2  (cost=0.00..255198271.02 rows=2827102 width=4) (actual time=10.850..3531.012 rows=2827102 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_2_2 kotelna_v2  (cost=0.00..250277691.74 rows=2769174 width=4) (actual time=4.200..3822.723 rows=2769174 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_3_1 kotelna_v2  (cost=0.00..232165842.22 rows=2584222 width=4) (actual time=11.975..3331.184 rows=2584222 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_3_2 kotelna_v2  (cost=0.00..301133496.18 rows=3349618 width=4) (actual time=7.439..4818.785 rows=3349618 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_4_1 kotelna_v2  (cost=0.00..254768092.76 rows=2809276 width=4) (actual time=12.721..5138.607 rows=2809276 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_4_2 kotelna_v2  (cost=0.00..289951949.07 rows=3194907 width=4) (actual time=12.145..7543.407 rows=3194907 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_5_1 kotelna_v2  (cost=0.00..225404819.59 rows=2481959 width=4) (actual time=12.995..4273.283 rows=2481959 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_5_2 kotelna_v2  (cost=0.00..307043768.65 rows=3376865 width=4) (actual time=20.715..5806.085 rows=3376865 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_6_1 kotelna_v2  (cost=0.00..246527247.28 rows=2724728 width=4) (actual time=17.513..3887.059 rows=2724728 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_6_2 kotelna_v2  (cost=0.00..279040873.74 rows=3087374 width=4) (actual time=18.228..4157.784 rows=3087374 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_7_1 kotelna_v2  (cost=0.00..245507215.33 rows=2721533 width=4) (actual time=17.685..3475.721 rows=2721533 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_7_2 kotelna_v2  (cost=0.00..250797791.42 rows=2779142 width=4) (actual time=15.863..3563.345 rows=2779142 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_8_1 kotelna_v2  (cost=0.00..203762590.16 rows=2259016 width=4) (actual time=10.950..2946.284 rows=2259016 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_8_2 kotelna_v2  (cost=0.00..263049155.25 rows=2915525 width=4) (actual time=7.522..4389.339 rows=2915525 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_9_1 kotelna_v2  (cost=0.00..239106426.74 rows=2642674 width=4) (actual time=15.754..3552.186 rows=2642674 loops=1)
                     ->  Seq Scan on kotelna_v2_2009_9_2 kotelna_v2  (cost=0.00..292882399.43 rows=3239943 width=4) (actual time=11.512..5244.111 rows=3239943 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_10_1 kotelna_v2  (cost=0.00..280080964.82 rows=3096482 width=4) (actual time=16.022..4417.081 rows=3096482 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_10_2 kotelna_v2  (cost=0.00..343468216.87 rows=3821687 width=4) (actual time=3.351..4598.134 rows=3821687 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_11_1 kotelna_v2  (cost=0.00..287911901.53 rows=3190153 width=4) (actual time=13.207..4310.409 rows=3190153 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_11_2 kotelna_v2  (cost=0.00..325486139.61 rows=3613961 width=4) (actual time=9.224..5615.591 rows=3613961 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_12_1 kotelna_v2  (cost=0.00..282271122.35 rows=3112235 width=4) (actual time=15.699..4749.073 rows=3112235 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_12_2 kotelna_v2  (cost=0.00..323485653.23 rows=3565323 width=4) (actual time=8.482..8027.527 rows=3565323 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_1_1 kotelna_v2  (cost=0.00..283221153.14 rows=3115314 width=4) (actual time=8.213..6185.197 rows=3115314 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_1_2 kotelna_v2  (cost=0.00..343707923.74 rows=3792374 width=4) (actual time=17.535..5208.984 rows=3792374 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_2_1 kotelna_v2  (cost=0.00..282751190.74 rows=3119074 width=4) (actual time=22.000..4322.341 rows=3119074 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_2_2 kotelna_v2  (cost=0.00..269529982.51 rows=2998251 width=4) (actual time=19.304..4052.547 rows=2998251 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_3_1 kotelna_v2  (cost=0.00..277040683.30 rows=3068330 width=4) (actual time=8.930..5166.933 rows=3068330 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_3_2 kotelna_v2  (cost=0.00..339017553.26 rows=3755326 width=4) (actual time=8.436..5460.939 rows=3755326 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_4_1 kotelna_v2  (cost=0.00..268789829.13 rows=2982913 width=4) (actual time=23.594..4438.624 rows=2982913 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_4_2 kotelna_v2  (cost=0.00..296092717.00 rows=3271700 width=4) (actual time=4.465..4155.684 rows=3271700 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_5_1 kotelna_v2  (cost=0.00..254267990.49 rows=2799049 width=4) (actual time=8.573..3349.121 rows=2799049 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_5_2 kotelna_v2  (cost=0.00..316124816.62 rows=3481662 width=4) (actual time=10.998..4633.817 rows=3481662 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_6_1 kotelna_v2  (cost=0.00..244756980.91 rows=2698091 width=4) (actual time=12.465..3304.284 rows=2698091 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_6_2 kotelna_v2  (cost=0.00..229075228.82 rows=2522882 width=4) (actual time=20.362..3316.975 rows=2522882 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_7_1 kotelna_v2  (cost=0.00..190371033.12 rows=2103312 width=4) (actual time=13.624..2757.171 rows=2103312 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_7_2 kotelna_v2  (cost=0.00..235445961.66 rows=2596166 width=4) (actual time=10.241..3445.904 rows=2596166 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_8_1 kotelna_v2  (cost=0.00..104541498.14 rows=1149814 width=4) (actual time=0.005..1227.342 rows=1149814 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_8_2 kotelna_v2  (cost=0.00..184980315.38 rows=2031538 width=4) (actual time=12.643..2945.104 rows=2031538 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_9_1 kotelna_v2  (cost=0.00..213593547.04 rows=2354704 width=4) (actual time=4.052..3674.174 rows=2354704 loops=1)
                     ->  Seq Scan on kotelna_v2_2010_9_2 kotelna_v2  (cost=0.00..264909325.45 rows=2932545 width=4) (actual time=20.033..4915.422 rows=2932545 loops=1)
 Total runtime: 1321068.159 ms
(110 rows)


konec souboru