PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16163
PG Version12.1
OSLinux
Opened2019-12-12 15:20:47+00
Reported bySebastian Ćmak
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16163
Logged by:          Sebastian Ćmak
Email address:      (redacted)
PostgreSQL version: 12.1
Operating system:   Linux
Description:        

1. Create partitioned table:
CREATE TABLE dw.fact_registers_decret_date
(
    id bigserial,
    dim_date_decret_date_id integer NOT NULL,
    CONSTRAINT fact_registers_decret_date_pk PRIMARY KEY
(dim_date_decret_date_id, id),
) PARTITION BY LIST (dim_date_decret_date_id) ;

CREATE INDEX fact_registers_decret_date_i7
    ON dw.fact_registers_decret_date USING btree
    (dim_date_decret_date_id)
    ;


CREATE INDEX fact_registers_decret_date_i7
    ON dw.fact_registers_decret_date USING btree
    (dim_date_decret_date_id)
    ;

-- Partitions SQL

CREATE TABLE dw.fact_registers_decret_date_20171231 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20171231);

CREATE TABLE dw.fact_registers_decret_date_20180131 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180131);

CREATE TABLE dw.fact_registers_decret_date_20180228 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180228);

CREATE TABLE dw.fact_registers_decret_date_20180331 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180331);

CREATE TABLE dw.fact_registers_decret_date_20180430 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180430);

CREATE TABLE dw.fact_registers_decret_date_20180531 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180531);

CREATE TABLE dw.fact_registers_decret_date_20180630 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180630);

CREATE TABLE dw.fact_registers_decret_date_20180731 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180731);

CREATE TABLE dw.fact_registers_decret_date_20180831 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180831);

CREATE TABLE dw.fact_registers_decret_date_20180930 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20180930);

CREATE TABLE dw.fact_registers_decret_date_20181031 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20181031);

CREATE TABLE dw.fact_registers_decret_date_20181130 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20181130);

CREATE TABLE dw.fact_registers_decret_date_20181231 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20181231);

CREATE TABLE dw.fact_registers_decret_date_20190131 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190131);

CREATE TABLE dw.fact_registers_decret_date_20190228 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190228);

CREATE TABLE dw.fact_registers_decret_date_20190331 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190331);

CREATE TABLE dw.fact_registers_decret_date_20190430 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190430);

CREATE TABLE dw.fact_registers_decret_date_20190531 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190531);

CREATE TABLE dw.fact_registers_decret_date_20190630 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190630);

CREATE TABLE dw.fact_registers_decret_date_20190701 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190701);

CREATE TABLE dw.fact_registers_decret_date_20190702 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190702);

CREATE TABLE dw.fact_registers_decret_date_20190703 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190703);

CREATE TABLE dw.fact_registers_decret_date_20190704 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190704);

CREATE TABLE dw.fact_registers_decret_date_20190705 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190705);

CREATE TABLE dw.fact_registers_decret_date_20190706 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190706);

CREATE TABLE dw.fact_registers_decret_date_20190707 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190707);

CREATE TABLE dw.fact_registers_decret_date_20190708 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190708);

CREATE TABLE dw.fact_registers_decret_date_20190709 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190709);

CREATE TABLE dw.fact_registers_decret_date_20190710 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190710);

CREATE TABLE dw.fact_registers_decret_date_20190711 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190711);

CREATE TABLE dw.fact_registers_decret_date_20190712 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190712);

CREATE TABLE dw.fact_registers_decret_date_20190713 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190713);

CREATE TABLE dw.fact_registers_decret_date_20190714 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190714);

CREATE TABLE dw.fact_registers_decret_date_20190715 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190715);

CREATE TABLE dw.fact_registers_decret_date_20190716 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190716);

CREATE TABLE dw.fact_registers_decret_date_20190717 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190717);

CREATE TABLE dw.fact_registers_decret_date_20190718 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190718);

CREATE TABLE dw.fact_registers_decret_date_20190719 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190719);

CREATE TABLE dw.fact_registers_decret_date_20190720 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190720);

CREATE TABLE dw.fact_registers_decret_date_20190721 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190721);

CREATE TABLE dw.fact_registers_decret_date_20190722 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190722);

CREATE TABLE dw.fact_registers_decret_date_20190723 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190723);

CREATE TABLE dw.fact_registers_decret_date_20190724 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190724);

CREATE TABLE dw.fact_registers_decret_date_20190725 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190725);

CREATE TABLE dw.fact_registers_decret_date_20190726 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190726);

CREATE TABLE dw.fact_registers_decret_date_20190727 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190727);

CREATE TABLE dw.fact_registers_decret_date_20190728 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190728);

CREATE TABLE dw.fact_registers_decret_date_20190729 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190729);

CREATE TABLE dw.fact_registers_decret_date_20190730 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190730);

CREATE TABLE dw.fact_registers_decret_date_20190731 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190731);

CREATE TABLE dw.fact_registers_decret_date_20190801 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190801);

CREATE TABLE dw.fact_registers_decret_date_20190802 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190802);

CREATE TABLE dw.fact_registers_decret_date_20190803 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190803);

CREATE TABLE dw.fact_registers_decret_date_20190804 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190804);

CREATE TABLE dw.fact_registers_decret_date_20190805 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190805);

CREATE TABLE dw.fact_registers_decret_date_20190806 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190806);

CREATE TABLE dw.fact_registers_decret_date_20190807 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190807);

CREATE TABLE dw.fact_registers_decret_date_20190808 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190808);

CREATE TABLE dw.fact_registers_decret_date_20190809 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190809);

CREATE TABLE dw.fact_registers_decret_date_20190810 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190810);

CREATE TABLE dw.fact_registers_decret_date_20190811 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190811);

CREATE TABLE dw.fact_registers_decret_date_20190812 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190812);

CREATE TABLE dw.fact_registers_decret_date_20190813 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190813);

CREATE TABLE dw.fact_registers_decret_date_20190814 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190814);

CREATE TABLE dw.fact_registers_decret_date_20190815 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190815);

CREATE TABLE dw.fact_registers_decret_date_20190816 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190816);

CREATE TABLE dw.fact_registers_decret_date_20190817 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190817);

CREATE TABLE dw.fact_registers_decret_date_20190818 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190818);

CREATE TABLE dw.fact_registers_decret_date_20190819 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190819);

CREATE TABLE dw.fact_registers_decret_date_20190820 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190820);

CREATE TABLE dw.fact_registers_decret_date_20190821 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190821);

CREATE TABLE dw.fact_registers_decret_date_20190822 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190822);

CREATE TABLE dw.fact_registers_decret_date_20190823 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190823);

CREATE TABLE dw.fact_registers_decret_date_20190824 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190824);

CREATE TABLE dw.fact_registers_decret_date_20190825 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190825);

CREATE TABLE dw.fact_registers_decret_date_20190826 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190826);

CREATE TABLE dw.fact_registers_decret_date_20190827 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190827);

CREATE TABLE dw.fact_registers_decret_date_20190828 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190828);

CREATE TABLE dw.fact_registers_decret_date_20190829 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190829);

CREATE TABLE dw.fact_registers_decret_date_20190830 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190830);

CREATE TABLE dw.fact_registers_decret_date_20190831 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190831);

CREATE TABLE dw.fact_registers_decret_date_20190901 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190901);

CREATE TABLE dw.fact_registers_decret_date_20190902 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190902);

CREATE TABLE dw.fact_registers_decret_date_20190903 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190903);

CREATE TABLE dw.fact_registers_decret_date_20190904 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190904);

CREATE TABLE dw.fact_registers_decret_date_20190905 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190905);

CREATE TABLE dw.fact_registers_decret_date_20190906 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190906);

CREATE TABLE dw.fact_registers_decret_date_20190907 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190907);

CREATE TABLE dw.fact_registers_decret_date_20190908 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190908);

CREATE TABLE dw.fact_registers_decret_date_20190909 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190909);

CREATE TABLE dw.fact_registers_decret_date_20190910 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190910);

CREATE TABLE dw.fact_registers_decret_date_20190911 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190911);

CREATE TABLE dw.fact_registers_decret_date_20190912 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190912);

CREATE TABLE dw.fact_registers_decret_date_20190913 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190913);

CREATE TABLE dw.fact_registers_decret_date_20190914 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190914);

CREATE TABLE dw.fact_registers_decret_date_20190915 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190915);

CREATE TABLE dw.fact_registers_decret_date_20190916 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190916);

CREATE TABLE dw.fact_registers_decret_date_20190917 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190917);

CREATE TABLE dw.fact_registers_decret_date_20190918 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190918);

CREATE TABLE dw.fact_registers_decret_date_20190919 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190919);

CREATE TABLE dw.fact_registers_decret_date_20190920 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190920);

CREATE TABLE dw.fact_registers_decret_date_20190921 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190921);

CREATE TABLE dw.fact_registers_decret_date_20190922 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190922);

CREATE TABLE dw.fact_registers_decret_date_20190923 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190923);

CREATE TABLE dw.fact_registers_decret_date_20190924 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190924);

CREATE TABLE dw.fact_registers_decret_date_20190925 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190925);

CREATE TABLE dw.fact_registers_decret_date_20190926 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190926);

CREATE TABLE dw.fact_registers_decret_date_20190927 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190927);

CREATE TABLE dw.fact_registers_decret_date_20190928 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190928);

CREATE TABLE dw.fact_registers_decret_date_20190929 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190929);

CREATE TABLE dw.fact_registers_decret_date_20190930 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20190930);

CREATE TABLE dw.fact_registers_decret_date_20191001 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191001);

CREATE TABLE dw.fact_registers_decret_date_20191002 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191002);

CREATE TABLE dw.fact_registers_decret_date_20191003 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191003);

CREATE TABLE dw.fact_registers_decret_date_20191004 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191004);

CREATE TABLE dw.fact_registers_decret_date_20191005 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191005);

CREATE TABLE dw.fact_registers_decret_date_20191006 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191006);

CREATE TABLE dw.fact_registers_decret_date_20191007 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191007);

CREATE TABLE dw.fact_registers_decret_date_20191008 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191008);

CREATE TABLE dw.fact_registers_decret_date_20191009 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191009);

CREATE TABLE dw.fact_registers_decret_date_20191010 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191010);

CREATE TABLE dw.fact_registers_decret_date_20191011 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191011);

CREATE TABLE dw.fact_registers_decret_date_20191012 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191012);

CREATE TABLE dw.fact_registers_decret_date_20191013 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191013);

CREATE TABLE dw.fact_registers_decret_date_20191014 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191014);

CREATE TABLE dw.fact_registers_decret_date_20191015 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191015);

CREATE TABLE dw.fact_registers_decret_date_20191016 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191016);

CREATE TABLE dw.fact_registers_decret_date_20191017 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191017);

CREATE TABLE dw.fact_registers_decret_date_20191018 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191018);

CREATE TABLE dw.fact_registers_decret_date_20191019 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191019);

CREATE TABLE dw.fact_registers_decret_date_20191020 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191020);

CREATE TABLE dw.fact_registers_decret_date_20191021 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191021);

CREATE TABLE dw.fact_registers_decret_date_20191022 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191022);

CREATE TABLE dw.fact_registers_decret_date_20191023 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191023);

CREATE TABLE dw.fact_registers_decret_date_20191024 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191024);

CREATE TABLE dw.fact_registers_decret_date_20191025 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191025);

CREATE TABLE dw.fact_registers_decret_date_20191026 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191026);

CREATE TABLE dw.fact_registers_decret_date_20191027 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191027);

CREATE TABLE dw.fact_registers_decret_date_20191028 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191028);

CREATE TABLE dw.fact_registers_decret_date_20191029 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191029);

CREATE TABLE dw.fact_registers_decret_date_20191030 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191030);

CREATE TABLE dw.fact_registers_decret_date_20191031 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191031);

CREATE TABLE dw.fact_registers_decret_date_20191101 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191101);

CREATE TABLE dw.fact_registers_decret_date_20191102 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191102);

CREATE TABLE dw.fact_registers_decret_date_20191103 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191103);

CREATE TABLE dw.fact_registers_decret_date_20191104 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191104);

CREATE TABLE dw.fact_registers_decret_date_20191105 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191105);

CREATE TABLE dw.fact_registers_decret_date_20191106 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191106);

CREATE TABLE dw.fact_registers_decret_date_20191107 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191107);

CREATE TABLE dw.fact_registers_decret_date_20191108 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191108);

CREATE TABLE dw.fact_registers_decret_date_20191109 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191109);

CREATE TABLE dw.fact_registers_decret_date_20191110 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191110);

CREATE TABLE dw.fact_registers_decret_date_20191111 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191111);

CREATE TABLE dw.fact_registers_decret_date_20191112 PARTITION OF
dw.fact_registers_decret_date
    FOR VALUES IN (20191112);

CREATE TABLE temp.dim_dates
(
    id integer,
    date_val date
)
;

2. Fill dw.fact_registers_decret_date with approx. 20 mln records per
partition. Analyse the table.
3. Put 1 record to the table temp.dim_dates. Analyse the table.
Select statement:
select frdd.* from dw.fact_registers_decret_date frdd
    join temp.dim_dates dd on frdd.dim_date_decret_date_id=dd.id;

It does not use neither existing index on dw.fact_registers_decret_date nor
partition limitation. The query lasts hours.

Execution plan:
-----------------------------------------
QUERY PLAN DESCRIPTION
-----------------------------------------

EXPLAIN (ANALYZE off, VERBOSE on, COSTS on, BUFFERS off, TIMING off) select
frdd.* from dw.fact_registers_decret_date frdd
    join temp.dim_dates dd on frdd.dim_date_decret_date_id=dd.id

Gather  (cost=1001.02..42013786.93 rows=11865543 width=120)
  Output: frdd.id, frdd.audit_cd, frdd.audit_cu, frdd.audit_ca,
frdd.contract_id, frdd.ct, frdd.dt, frdd.balance,
frdd.dim_date_decret_date_id, frdd.dim_register_id, frdd.dim_wallet_id,
frdd.dim_owner_type_id, frdd.dim_is_debt_id, frdd.dim_is_obsolete_id,
frdd.dim_is_current_id, frdd.nrb
  Workers Planned: 8
  ->  Hash Join  (cost=1.02..40826232.63 rows=1483193 width=120)
        Output: frdd.id, frdd.audit_cd, frdd.audit_cu, frdd.audit_ca,
frdd.contract_id, frdd.ct, frdd.dt, frdd.balance,
frdd.dim_date_decret_date_id, frdd.dim_register_id, frdd.dim_wallet_id,
frdd.dim_owner_type_id, frdd.dim_is_debt_id, frdd.dim_is_obsolete_id,
frdd.dim_is_current_id, frdd.nrb
        Hash Cond: (frdd.dim_date_decret_date_id = dd.id)
        ->  Parallel Append  (cost=0.00..39954855.78 rows=228411706
width=120)
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20171231 frdd  (cost=0.00..562254.37
rows=4472937 width=119)
                    Output: frdd.id, frdd.audit_cd, frdd.audit_cu,
frdd.audit_ca, frdd.contract_id, frdd.ct, frdd.dt, frdd.balance,
frdd.dim_date_decret_date_id, frdd.dim_register_id, frdd.dim_wallet_id,
frdd.dim_owner_type_id, frdd.dim_is_debt_id, frdd.dim_is_obsolete_id,
frdd.dim_is_current_id, frdd.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180331 frdd_3  (cost=0.00..445202.60
rows=3535360 width=119)
                    Output: frdd_3.id, frdd_3.audit_cd, frdd_3.audit_cu,
frdd_3.audit_ca, frdd_3.contract_id, frdd_3.ct, frdd_3.dt, frdd_3.balance,
frdd_3.dim_date_decret_date_id, frdd_3.dim_register_id,
frdd_3.dim_wallet_id, frdd_3.dim_owner_type_id, frdd_3.dim_is_debt_id,
frdd_3.dim_is_obsolete_id, frdd_3.dim_is_current_id, frdd_3.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180228 frdd_2  (cost=0.00..441483.15
rows=3504015 width=119)
                    Output: frdd_2.id, frdd_2.audit_cd, frdd_2.audit_cu,
frdd_2.audit_ca, frdd_2.contract_id, frdd_2.ct, frdd_2.dt, frdd_2.balance,
frdd_2.dim_date_decret_date_id, frdd_2.dim_register_id,
frdd_2.dim_wallet_id, frdd_2.dim_owner_type_id, frdd_2.dim_is_debt_id,
frdd_2.dim_is_obsolete_id, frdd_2.dim_is_current_id, frdd_2.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20181031 frdd_10  (cost=0.00..432604.13
rows=3434213 width=119)
                    Output: frdd_10.id, frdd_10.audit_cd, frdd_10.audit_cu,
frdd_10.audit_ca, frdd_10.contract_id, frdd_10.ct, frdd_10.dt,
frdd_10.balance, frdd_10.dim_date_decret_date_id, frdd_10.dim_register_id,
frdd_10.dim_wallet_id, frdd_10.dim_owner_type_id, frdd_10.dim_is_debt_id,
frdd_10.dim_is_obsolete_id, frdd_10.dim_is_current_id, frdd_10.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190131 frdd_13  (cost=0.00..431984.56
rows=3431056 width=119)
                    Output: frdd_13.id, frdd_13.audit_cd, frdd_13.audit_cu,
frdd_13.audit_ca, frdd_13.contract_id, frdd_13.ct, frdd_13.dt,
frdd_13.balance, frdd_13.dim_date_decret_date_id, frdd_13.dim_register_id,
frdd_13.dim_wallet_id, frdd_13.dim_owner_type_id, frdd_13.dim_is_debt_id,
frdd_13.dim_is_obsolete_id, frdd_13.dim_is_current_id, frdd_13.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20181130 frdd_11  (cost=0.00..431190.29
rows=3423229 width=119)
                    Output: frdd_11.id, frdd_11.audit_cd, frdd_11.audit_cu,
frdd_11.audit_ca, frdd_11.contract_id, frdd_11.ct, frdd_11.dt,
frdd_11.balance, frdd_11.dim_date_decret_date_id, frdd_11.dim_register_id,
frdd_11.dim_wallet_id, frdd_11.dim_owner_type_id, frdd_11.dim_is_debt_id,
frdd_11.dim_is_obsolete_id, frdd_11.dim_is_current_id, frdd_11.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180930 frdd_9  (cost=0.00..431024.11
rows=3420911 width=119)
                    Output: frdd_9.id, frdd_9.audit_cd, frdd_9.audit_cu,
frdd_9.audit_ca, frdd_9.contract_id, frdd_9.ct, frdd_9.dt, frdd_9.balance,
frdd_9.dim_date_decret_date_id, frdd_9.dim_register_id,
frdd_9.dim_wallet_id, frdd_9.dim_owner_type_id, frdd_9.dim_is_debt_id,
frdd_9.dim_is_obsolete_id, frdd_9.dim_is_current_id, frdd_9.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180531 frdd_5  (cost=0.00..429858.49
rows=3413049 width=119)
                    Output: frdd_5.id, frdd_5.audit_cd, frdd_5.audit_cu,
frdd_5.audit_ca, frdd_5.contract_id, frdd_5.ct, frdd_5.dt, frdd_5.balance,
frdd_5.dim_date_decret_date_id, frdd_5.dim_register_id,
frdd_5.dim_wallet_id, frdd_5.dim_owner_type_id, frdd_5.dim_is_debt_id,
frdd_5.dim_is_obsolete_id, frdd_5.dim_is_current_id, frdd_5.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180430 frdd_4  (cost=0.00..429681.24
rows=3410824 width=119)
                    Output: frdd_4.id, frdd_4.audit_cd, frdd_4.audit_cu,
frdd_4.audit_ca, frdd_4.contract_id, frdd_4.ct, frdd_4.dt, frdd_4.balance,
frdd_4.dim_date_decret_date_id, frdd_4.dim_register_id,
frdd_4.dim_wallet_id, frdd_4.dim_owner_type_id, frdd_4.dim_is_debt_id,
frdd_4.dim_is_obsolete_id, frdd_4.dim_is_current_id, frdd_4.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20181231 frdd_12  (cost=0.00..428440.20
rows=3401420 width=119)
                    Output: frdd_12.id, frdd_12.audit_cd, frdd_12.audit_cu,
frdd_12.audit_ca, frdd_12.contract_id, frdd_12.ct, frdd_12.dt,
frdd_12.balance, frdd_12.dim_date_decret_date_id, frdd_12.dim_register_id,
frdd_12.dim_wallet_id, frdd_12.dim_owner_type_id, frdd_12.dim_is_debt_id,
frdd_12.dim_is_obsolete_id, frdd_12.dim_is_current_id, frdd_12.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180831 frdd_8  (cost=0.00..427211.08
rows=3390608 width=119)
                    Output: frdd_8.id, frdd_8.audit_cd, frdd_8.audit_cu,
frdd_8.audit_ca, frdd_8.contract_id, frdd_8.ct, frdd_8.dt, frdd_8.balance,
frdd_8.dim_date_decret_date_id, frdd_8.dim_register_id,
frdd_8.dim_wallet_id, frdd_8.dim_owner_type_id, frdd_8.dim_is_debt_id,
frdd_8.dim_is_obsolete_id, frdd_8.dim_is_current_id, frdd_8.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180731 frdd_7  (cost=0.00..426780.96
rows=3387496 width=119)
                    Output: frdd_7.id, frdd_7.audit_cd, frdd_7.audit_cu,
frdd_7.audit_ca, frdd_7.contract_id, frdd_7.ct, frdd_7.dt, frdd_7.balance,
frdd_7.dim_date_decret_date_id, frdd_7.dim_register_id,
frdd_7.dim_wallet_id, frdd_7.dim_owner_type_id, frdd_7.dim_is_debt_id,
frdd_7.dim_is_obsolete_id, frdd_7.dim_is_current_id, frdd_7.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190228 frdd_14  (cost=0.00..418798.44
rows=3326544 width=119)
                    Output: frdd_14.id, frdd_14.audit_cd, frdd_14.audit_cu,
frdd_14.audit_ca, frdd_14.contract_id, frdd_14.ct, frdd_14.dt,
frdd_14.balance, frdd_14.dim_date_decret_date_id, frdd_14.dim_register_id,
frdd_14.dim_wallet_id, frdd_14.dim_owner_type_id, frdd_14.dim_is_debt_id,
frdd_14.dim_is_obsolete_id, frdd_14.dim_is_current_id, frdd_14.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190331 frdd_15  (cost=0.00..418112.49
rows=3321349 width=119)
                    Output: frdd_15.id, frdd_15.audit_cd, frdd_15.audit_cu,
frdd_15.audit_ca, frdd_15.contract_id, frdd_15.ct, frdd_15.dt,
frdd_15.balance, frdd_15.dim_date_decret_date_id, frdd_15.dim_register_id,
frdd_15.dim_wallet_id, frdd_15.dim_owner_type_id, frdd_15.dim_is_debt_id,
frdd_15.dim_is_obsolete_id, frdd_15.dim_is_current_id, frdd_15.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180630 frdd_6  (cost=0.00..415085.01
rows=3295001 width=120)
                    Output: frdd_6.id, frdd_6.audit_cd, frdd_6.audit_cu,
frdd_6.audit_ca, frdd_6.contract_id, frdd_6.ct, frdd_6.dt, frdd_6.balance,
frdd_6.dim_date_decret_date_id, frdd_6.dim_register_id,
frdd_6.dim_wallet_id, frdd_6.dim_owner_type_id, frdd_6.dim_is_debt_id,
frdd_6.dim_is_obsolete_id, frdd_6.dim_is_current_id, frdd_6.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20180131 frdd_1  (cost=0.00..411393.00
rows=3266000 width=119)
                    Output: frdd_1.id, frdd_1.audit_cd, frdd_1.audit_cu,
frdd_1.audit_ca, frdd_1.contract_id, frdd_1.ct, frdd_1.dt, frdd_1.balance,
frdd_1.dim_date_decret_date_id, frdd_1.dim_register_id,
frdd_1.dim_wallet_id, frdd_1.dim_owner_type_id, frdd_1.dim_is_debt_id,
frdd_1.dim_is_obsolete_id, frdd_1.dim_is_current_id, frdd_1.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190430 frdd_16  (cost=0.00..410710.33
rows=3264533 width=118)
                    Output: frdd_16.id, frdd_16.audit_cd, frdd_16.audit_cu,
frdd_16.audit_ca, frdd_16.contract_id, frdd_16.ct, frdd_16.dt,
frdd_16.balance, frdd_16.dim_date_decret_date_id, frdd_16.dim_register_id,
frdd_16.dim_wallet_id, frdd_16.dim_owner_type_id, frdd_16.dim_is_debt_id,
frdd_16.dim_is_obsolete_id, frdd_16.dim_is_current_id, frdd_16.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190531 frdd_17  (cost=0.00..266480.90
rows=2502490 width=118)
                    Output: frdd_17.id, frdd_17.audit_cd, frdd_17.audit_cu,
frdd_17.audit_ca, frdd_17.contract_id, frdd_17.ct, frdd_17.dt,
frdd_17.balance, frdd_17.dim_date_decret_date_id, frdd_17.dim_register_id,
frdd_17.dim_wallet_id, frdd_17.dim_owner_type_id, frdd_17.dim_is_debt_id,
frdd_17.dim_is_obsolete_id, frdd_17.dim_is_current_id, frdd_17.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190630 frdd_18  (cost=0.00..253750.56
rows=2381156 width=120)
                    Output: frdd_18.id, frdd_18.audit_cd, frdd_18.audit_cu,
frdd_18.audit_ca, frdd_18.contract_id, frdd_18.ct, frdd_18.dt,
frdd_18.balance, frdd_18.dim_date_decret_date_id, frdd_18.dim_register_id,
frdd_18.dim_wallet_id, frdd_18.dim_owner_type_id, frdd_18.dim_is_debt_id,
frdd_18.dim_is_obsolete_id, frdd_18.dim_is_current_id, frdd_18.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190701 frdd_19  (cost=0.00..249271.88
rows=2338688 width=120)
                    Output: frdd_19.id, frdd_19.audit_cd, frdd_19.audit_cu,
frdd_19.audit_ca, frdd_19.contract_id, frdd_19.ct, frdd_19.dt,
frdd_19.balance, frdd_19.dim_date_decret_date_id, frdd_19.dim_register_id,
frdd_19.dim_wallet_id, frdd_19.dim_owner_type_id, frdd_19.dim_is_debt_id,
frdd_19.dim_is_obsolete_id, frdd_19.dim_is_current_id, frdd_19.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190702 frdd_20  (cost=0.00..249195.25
rows=2337825 width=119)
                    Output: frdd_20.id, frdd_20.audit_cd, frdd_20.audit_cu,
frdd_20.audit_ca, frdd_20.contract_id, frdd_20.ct, frdd_20.dt,
frdd_20.balance, frdd_20.dim_date_decret_date_id, frdd_20.dim_register_id,
frdd_20.dim_wallet_id, frdd_20.dim_owner_type_id, frdd_20.dim_is_debt_id,
frdd_20.dim_is_obsolete_id, frdd_20.dim_is_current_id, frdd_20.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190703 frdd_21  (cost=0.00..249135.97
rows=2337097 width=119)
                    Output: frdd_21.id, frdd_21.audit_cd, frdd_21.audit_cu,
frdd_21.audit_ca, frdd_21.contract_id, frdd_21.ct, frdd_21.dt,
frdd_21.balance, frdd_21.dim_date_decret_date_id, frdd_21.dim_register_id,
frdd_21.dim_wallet_id, frdd_21.dim_owner_type_id, frdd_21.dim_is_debt_id,
frdd_21.dim_is_obsolete_id, frdd_21.dim_is_current_id, frdd_21.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190704 frdd_22  (cost=0.00..249133.60
rows=2337360 width=119)
                    Output: frdd_22.id, frdd_22.audit_cd, frdd_22.audit_cu,
frdd_22.audit_ca, frdd_22.contract_id, frdd_22.ct, frdd_22.dt,
frdd_22.balance, frdd_22.dim_date_decret_date_id, frdd_22.dim_register_id,
frdd_22.dim_wallet_id, frdd_22.dim_owner_type_id, frdd_22.dim_is_debt_id,
frdd_22.dim_is_obsolete_id, frdd_22.dim_is_current_id, frdd_22.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190705 frdd_23  (cost=0.00..247068.42
rows=2317942 width=119)
                    Output: frdd_23.id, frdd_23.audit_cd, frdd_23.audit_cu,
frdd_23.audit_ca, frdd_23.contract_id, frdd_23.ct, frdd_23.dt,
frdd_23.balance, frdd_23.dim_date_decret_date_id, frdd_23.dim_register_id,
frdd_23.dim_wallet_id, frdd_23.dim_owner_type_id, frdd_23.dim_is_debt_id,
frdd_23.dim_is_obsolete_id, frdd_23.dim_is_current_id, frdd_23.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190706 frdd_24  (cost=0.00..245595.94
rows=2303894 width=119)
                    Output: frdd_24.id, frdd_24.audit_cd, frdd_24.audit_cu,
frdd_24.audit_ca, frdd_24.contract_id, frdd_24.ct, frdd_24.dt,
frdd_24.balance, frdd_24.dim_date_decret_date_id, frdd_24.dim_register_id,
frdd_24.dim_wallet_id, frdd_24.dim_owner_type_id, frdd_24.dim_is_debt_id,
frdd_24.dim_is_obsolete_id, frdd_24.dim_is_current_id, frdd_24.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190707 frdd_25  (cost=0.00..245383.22
rows=2301522 width=119)
                    Output: frdd_25.id, frdd_25.audit_cd, frdd_25.audit_cu,
frdd_25.audit_ca, frdd_25.contract_id, frdd_25.ct, frdd_25.dt,
frdd_25.balance, frdd_25.dim_date_decret_date_id, frdd_25.dim_register_id,
frdd_25.dim_wallet_id, frdd_25.dim_owner_type_id, frdd_25.dim_is_debt_id,
frdd_25.dim_is_obsolete_id, frdd_25.dim_is_current_id, frdd_25.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190708 frdd_26  (cost=0.00..245215.50
rows=2300450 width=119)
                    Output: frdd_26.id, frdd_26.audit_cd, frdd_26.audit_cu,
frdd_26.audit_ca, frdd_26.contract_id, frdd_26.ct, frdd_26.dt,
frdd_26.balance, frdd_26.dim_date_decret_date_id, frdd_26.dim_register_id,
frdd_26.dim_wallet_id, frdd_26.dim_owner_type_id, frdd_26.dim_is_debt_id,
frdd_26.dim_is_obsolete_id, frdd_26.dim_is_current_id, frdd_26.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190709 frdd_27  (cost=0.00..244920.63
rows=2297763 width=119)
                    Output: frdd_27.id, frdd_27.audit_cd, frdd_27.audit_cu,
frdd_27.audit_ca, frdd_27.contract_id, frdd_27.ct, frdd_27.dt,
frdd_27.balance, frdd_27.dim_date_decret_date_id, frdd_27.dim_register_id,
frdd_27.dim_wallet_id, frdd_27.dim_owner_type_id, frdd_27.dim_is_debt_id,
frdd_27.dim_is_obsolete_id, frdd_27.dim_is_current_id, frdd_27.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190710 frdd_28  (cost=0.00..241923.83
rows=2269783 width=120)
                    Output: frdd_28.id, frdd_28.audit_cd, frdd_28.audit_cu,
frdd_28.audit_ca, frdd_28.contract_id, frdd_28.ct, frdd_28.dt,
frdd_28.balance, frdd_28.dim_date_decret_date_id, frdd_28.dim_register_id,
frdd_28.dim_wallet_id, frdd_28.dim_owner_type_id, frdd_28.dim_is_debt_id,
frdd_28.dim_is_obsolete_id, frdd_28.dim_is_current_id, frdd_28.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190712 frdd_30  (cost=0.00..231554.09
rows=2173409 width=120)
                    Output: frdd_30.id, frdd_30.audit_cd, frdd_30.audit_cu,
frdd_30.audit_ca, frdd_30.contract_id, frdd_30.ct, frdd_30.dt,
frdd_30.balance, frdd_30.dim_date_decret_date_id, frdd_30.dim_register_id,
frdd_30.dim_wallet_id, frdd_30.dim_owner_type_id, frdd_30.dim_is_debt_id,
frdd_30.dim_is_obsolete_id, frdd_30.dim_is_current_id, frdd_30.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190717 frdd_35  (cost=0.00..231548.73
rows=2173573 width=120)
                    Output: frdd_35.id, frdd_35.audit_cd, frdd_35.audit_cu,
frdd_35.audit_ca, frdd_35.contract_id, frdd_35.ct, frdd_35.dt,
frdd_35.balance, frdd_35.dim_date_decret_date_id, frdd_35.dim_register_id,
frdd_35.dim_wallet_id, frdd_35.dim_owner_type_id, frdd_35.dim_is_debt_id,
frdd_35.dim_is_obsolete_id, frdd_35.dim_is_current_id, frdd_35.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190715 frdd_33  (cost=0.00..231527.48
rows=2173448 width=120)
                    Output: frdd_33.id, frdd_33.audit_cd, frdd_33.audit_cu,
frdd_33.audit_ca, frdd_33.contract_id, frdd_33.ct, frdd_33.dt,
frdd_33.balance, frdd_33.dim_date_decret_date_id, frdd_33.dim_register_id,
frdd_33.dim_wallet_id, frdd_33.dim_owner_type_id, frdd_33.dim_is_debt_id,
frdd_33.dim_is_obsolete_id, frdd_33.dim_is_current_id, frdd_33.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190711 frdd_29  (cost=0.00..231495.34
rows=2172834 width=120)
                    Output: frdd_29.id, frdd_29.audit_cd, frdd_29.audit_cu,
frdd_29.audit_ca, frdd_29.contract_id, frdd_29.ct, frdd_29.dt,
frdd_29.balance, frdd_29.dim_date_decret_date_id, frdd_29.dim_register_id,
frdd_29.dim_wallet_id, frdd_29.dim_owner_type_id, frdd_29.dim_is_debt_id,
frdd_29.dim_is_obsolete_id, frdd_29.dim_is_current_id, frdd_29.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190716 frdd_34  (cost=0.00..231477.84
rows=2172984 width=120)
                    Output: frdd_34.id, frdd_34.audit_cd, frdd_34.audit_cu,
frdd_34.audit_ca, frdd_34.contract_id, frdd_34.ct, frdd_34.dt,
frdd_34.balance, frdd_34.dim_date_decret_date_id, frdd_34.dim_register_id,
frdd_34.dim_wallet_id, frdd_34.dim_owner_type_id, frdd_34.dim_is_debt_id,
frdd_34.dim_is_obsolete_id, frdd_34.dim_is_current_id, frdd_34.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190713 frdd_31  (cost=0.00..231469.75
rows=2172875 width=120)
                    Output: frdd_31.id, frdd_31.audit_cd, frdd_31.audit_cu,
frdd_31.audit_ca, frdd_31.contract_id, frdd_31.ct, frdd_31.dt,
frdd_31.balance, frdd_31.dim_date_decret_date_id, frdd_31.dim_register_id,
frdd_31.dim_wallet_id, frdd_31.dim_owner_type_id, frdd_31.dim_is_debt_id,
frdd_31.dim_is_obsolete_id, frdd_31.dim_is_current_id, frdd_31.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190714 frdd_32  (cost=0.00..231468.76
rows=2172776 width=120)
                    Output: frdd_32.id, frdd_32.audit_cd, frdd_32.audit_cu,
frdd_32.audit_ca, frdd_32.contract_id, frdd_32.ct, frdd_32.dt,
frdd_32.balance, frdd_32.dim_date_decret_date_id, frdd_32.dim_register_id,
frdd_32.dim_wallet_id, frdd_32.dim_owner_type_id, frdd_32.dim_is_debt_id,
frdd_32.dim_is_obsolete_id, frdd_32.dim_is_current_id, frdd_32.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190718 frdd_36  (cost=0.00..231236.53
rows=2170553 width=120)
                    Output: frdd_36.id, frdd_36.audit_cd, frdd_36.audit_cu,
frdd_36.audit_ca, frdd_36.contract_id, frdd_36.ct, frdd_36.dt,
frdd_36.balance, frdd_36.dim_date_decret_date_id, frdd_36.dim_register_id,
frdd_36.dim_wallet_id, frdd_36.dim_owner_type_id, frdd_36.dim_is_debt_id,
frdd_36.dim_is_obsolete_id, frdd_36.dim_is_current_id, frdd_36.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190719 frdd_37  (cost=0.00..231225.31
rows=2170731 width=120)
                    Output: frdd_37.id, frdd_37.audit_cd, frdd_37.audit_cu,
frdd_37.audit_ca, frdd_37.contract_id, frdd_37.ct, frdd_37.dt,
frdd_37.balance, frdd_37.dim_date_decret_date_id, frdd_37.dim_register_id,
frdd_37.dim_wallet_id, frdd_37.dim_owner_type_id, frdd_37.dim_is_debt_id,
frdd_37.dim_is_obsolete_id, frdd_37.dim_is_current_id, frdd_37.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190722 frdd_40  (cost=0.00..231149.48
rows=2169848 width=120)
                    Output: frdd_40.id, frdd_40.audit_cd, frdd_40.audit_cu,
frdd_40.audit_ca, frdd_40.contract_id, frdd_40.ct, frdd_40.dt,
frdd_40.balance, frdd_40.dim_date_decret_date_id, frdd_40.dim_register_id,
frdd_40.dim_wallet_id, frdd_40.dim_owner_type_id, frdd_40.dim_is_debt_id,
frdd_40.dim_is_obsolete_id, frdd_40.dim_is_current_id, frdd_40.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190723 frdd_41  (cost=0.00..231120.82
rows=2169482 width=120)
                    Output: frdd_41.id, frdd_41.audit_cd, frdd_41.audit_cu,
frdd_41.audit_ca, frdd_41.contract_id, frdd_41.ct, frdd_41.dt,
frdd_41.balance, frdd_41.dim_date_decret_date_id, frdd_41.dim_register_id,
frdd_41.dim_wallet_id, frdd_41.dim_owner_type_id, frdd_41.dim_is_debt_id,
frdd_41.dim_is_obsolete_id, frdd_41.dim_is_current_id, frdd_41.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190721 frdd_39  (cost=0.00..231103.84
rows=2169684 width=120)
                    Output: frdd_39.id, frdd_39.audit_cd, frdd_39.audit_cu,
frdd_39.audit_ca, frdd_39.contract_id, frdd_39.ct, frdd_39.dt,
frdd_39.balance, frdd_39.dim_date_decret_date_id, frdd_39.dim_register_id,
frdd_39.dim_wallet_id, frdd_39.dim_owner_type_id, frdd_39.dim_is_debt_id,
frdd_39.dim_is_obsolete_id, frdd_39.dim_is_current_id, frdd_39.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190720 frdd_38  (cost=0.00..231099.16
rows=2169416 width=120)
                    Output: frdd_38.id, frdd_38.audit_cd, frdd_38.audit_cu,
frdd_38.audit_ca, frdd_38.contract_id, frdd_38.ct, frdd_38.dt,
frdd_38.balance, frdd_38.dim_date_decret_date_id, frdd_38.dim_register_id,
frdd_38.dim_wallet_id, frdd_38.dim_owner_type_id, frdd_38.dim_is_debt_id,
frdd_38.dim_is_obsolete_id, frdd_38.dim_is_current_id, frdd_38.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190724 frdd_42  (cost=0.00..230957.30
rows=2168030 width=120)
                    Output: frdd_42.id, frdd_42.audit_cd, frdd_42.audit_cu,
frdd_42.audit_ca, frdd_42.contract_id, frdd_42.ct, frdd_42.dt,
frdd_42.balance, frdd_42.dim_date_decret_date_id, frdd_42.dim_register_id,
frdd_42.dim_wallet_id, frdd_42.dim_owner_type_id, frdd_42.dim_is_debt_id,
frdd_42.dim_is_obsolete_id, frdd_42.dim_is_current_id, frdd_42.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190725 frdd_43  (cost=0.00..230901.58
rows=2167358 width=120)
                    Output: frdd_43.id, frdd_43.audit_cd, frdd_43.audit_cu,
frdd_43.audit_ca, frdd_43.contract_id, frdd_43.ct, frdd_43.dt,
frdd_43.balance, frdd_43.dim_date_decret_date_id, frdd_43.dim_register_id,
frdd_43.dim_wallet_id, frdd_43.dim_owner_type_id, frdd_43.dim_is_debt_id,
frdd_43.dim_is_obsolete_id, frdd_43.dim_is_current_id, frdd_43.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190730 frdd_48  (cost=0.00..230825.71
rows=2166771 width=120)
                    Output: frdd_48.id, frdd_48.audit_cd, frdd_48.audit_cu,
frdd_48.audit_ca, frdd_48.contract_id, frdd_48.ct, frdd_48.dt,
frdd_48.balance, frdd_48.dim_date_decret_date_id, frdd_48.dim_register_id,
frdd_48.dim_wallet_id, frdd_48.dim_owner_type_id, frdd_48.dim_is_debt_id,
frdd_48.dim_is_obsolete_id, frdd_48.dim_is_current_id, frdd_48.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190726 frdd_44  (cost=0.00..230818.77
rows=2166477 width=120)
                    Output: frdd_44.id, frdd_44.audit_cd, frdd_44.audit_cu,
frdd_44.audit_ca, frdd_44.contract_id, frdd_44.ct, frdd_44.dt,
frdd_44.balance, frdd_44.dim_date_decret_date_id, frdd_44.dim_register_id,
frdd_44.dim_wallet_id, frdd_44.dim_owner_type_id, frdd_44.dim_is_debt_id,
frdd_44.dim_is_obsolete_id, frdd_44.dim_is_current_id, frdd_44.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190731 frdd_49  (cost=0.00..230799.61
rows=2166661 width=120)
                    Output: frdd_49.id, frdd_49.audit_cd, frdd_49.audit_cu,
frdd_49.audit_ca, frdd_49.contract_id, frdd_49.ct, frdd_49.dt,
frdd_49.balance, frdd_49.dim_date_decret_date_id, frdd_49.dim_register_id,
frdd_49.dim_wallet_id, frdd_49.dim_owner_type_id, frdd_49.dim_is_debt_id,
frdd_49.dim_is_obsolete_id, frdd_49.dim_is_current_id, frdd_49.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190729 frdd_47  (cost=0.00..230786.95
rows=2166195 width=120)
                    Output: frdd_47.id, frdd_47.audit_cd, frdd_47.audit_cu,
frdd_47.audit_ca, frdd_47.contract_id, frdd_47.ct, frdd_47.dt,
frdd_47.balance, frdd_47.dim_date_decret_date_id, frdd_47.dim_register_id,
frdd_47.dim_wallet_id, frdd_47.dim_owner_type_id, frdd_47.dim_is_debt_id,
frdd_47.dim_is_obsolete_id, frdd_47.dim_is_current_id, frdd_47.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190727 frdd_45  (cost=0.00..230764.65
rows=2166065 width=120)
                    Output: frdd_45.id, frdd_45.audit_cd, frdd_45.audit_cu,
frdd_45.audit_ca, frdd_45.contract_id, frdd_45.ct, frdd_45.dt,
frdd_45.balance, frdd_45.dim_date_decret_date_id, frdd_45.dim_register_id,
frdd_45.dim_wallet_id, frdd_45.dim_owner_type_id, frdd_45.dim_is_debt_id,
frdd_45.dim_is_obsolete_id, frdd_45.dim_is_current_id, frdd_45.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190728 frdd_46  (cost=0.00..230763.34
rows=2166134 width=120)
                    Output: frdd_46.id, frdd_46.audit_cd, frdd_46.audit_cu,
frdd_46.audit_ca, frdd_46.contract_id, frdd_46.ct, frdd_46.dt,
frdd_46.balance, frdd_46.dim_date_decret_date_id, frdd_46.dim_register_id,
frdd_46.dim_wallet_id, frdd_46.dim_owner_type_id, frdd_46.dim_is_debt_id,
frdd_46.dim_is_obsolete_id, frdd_46.dim_is_current_id, frdd_46.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190801 frdd_50  (cost=0.00..230259.64
rows=2161564 width=120)
                    Output: frdd_50.id, frdd_50.audit_cd, frdd_50.audit_cu,
frdd_50.audit_ca, frdd_50.contract_id, frdd_50.ct, frdd_50.dt,
frdd_50.balance, frdd_50.dim_date_decret_date_id, frdd_50.dim_register_id,
frdd_50.dim_wallet_id, frdd_50.dim_owner_type_id, frdd_50.dim_is_debt_id,
frdd_50.dim_is_obsolete_id, frdd_50.dim_is_current_id, frdd_50.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190902 frdd_82  (cost=0.00..229640.00
rows=2156200 width=120)
                    Output: frdd_82.id, frdd_82.audit_cd, frdd_82.audit_cu,
frdd_82.audit_ca, frdd_82.contract_id, frdd_82.ct, frdd_82.dt,
frdd_82.balance, frdd_82.dim_date_decret_date_id, frdd_82.dim_register_id,
frdd_82.dim_wallet_id, frdd_82.dim_owner_type_id, frdd_82.dim_is_debt_id,
frdd_82.dim_is_obsolete_id, frdd_82.dim_is_current_id, frdd_82.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190903 frdd_83  (cost=0.00..229570.64
rows=2155764 width=120)
                    Output: frdd_83.id, frdd_83.audit_cd, frdd_83.audit_cu,
frdd_83.audit_ca, frdd_83.contract_id, frdd_83.ct, frdd_83.dt,
frdd_83.balance, frdd_83.dim_date_decret_date_id, frdd_83.dim_register_id,
frdd_83.dim_wallet_id, frdd_83.dim_owner_type_id, frdd_83.dim_is_debt_id,
frdd_83.dim_is_obsolete_id, frdd_83.dim_is_current_id, frdd_83.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190904 frdd_84  (cost=0.00..229548.76
rows=2155576 width=120)
                    Output: frdd_84.id, frdd_84.audit_cd, frdd_84.audit_cu,
frdd_84.audit_ca, frdd_84.contract_id, frdd_84.ct, frdd_84.dt,
frdd_84.balance, frdd_84.dim_date_decret_date_id, frdd_84.dim_register_id,
frdd_84.dim_wallet_id, frdd_84.dim_owner_type_id, frdd_84.dim_is_debt_id,
frdd_84.dim_is_obsolete_id, frdd_84.dim_is_current_id, frdd_84.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190905 frdd_85  (cost=0.00..229535.58
rows=2155658 width=120)
                    Output: frdd_85.id, frdd_85.audit_cd, frdd_85.audit_cu,
frdd_85.audit_ca, frdd_85.contract_id, frdd_85.ct, frdd_85.dt,
frdd_85.balance, frdd_85.dim_date_decret_date_id, frdd_85.dim_register_id,
frdd_85.dim_wallet_id, frdd_85.dim_owner_type_id, frdd_85.dim_is_debt_id,
frdd_85.dim_is_obsolete_id, frdd_85.dim_is_current_id, frdd_85.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190906 frdd_86  (cost=0.00..229469.62
rows=2154962 width=120)
                    Output: frdd_86.id, frdd_86.audit_cd, frdd_86.audit_cu,
frdd_86.audit_ca, frdd_86.contract_id, frdd_86.ct, frdd_86.dt,
frdd_86.balance, frdd_86.dim_date_decret_date_id, frdd_86.dim_register_id,
frdd_86.dim_wallet_id, frdd_86.dim_owner_type_id, frdd_86.dim_is_debt_id,
frdd_86.dim_is_obsolete_id, frdd_86.dim_is_current_id, frdd_86.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190909 frdd_89  (cost=0.00..229439.30
rows=2154230 width=120)
                    Output: frdd_89.id, frdd_89.audit_cd, frdd_89.audit_cu,
frdd_89.audit_ca, frdd_89.contract_id, frdd_89.ct, frdd_89.dt,
frdd_89.balance, frdd_89.dim_date_decret_date_id, frdd_89.dim_register_id,
frdd_89.dim_wallet_id, frdd_89.dim_owner_type_id, frdd_89.dim_is_debt_id,
frdd_89.dim_is_obsolete_id, frdd_89.dim_is_current_id, frdd_89.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190908 frdd_88  (cost=0.00..229419.47
rows=2154647 width=120)
                    Output: frdd_88.id, frdd_88.audit_cd, frdd_88.audit_cu,
frdd_88.audit_ca, frdd_88.contract_id, frdd_88.ct, frdd_88.dt,
frdd_88.balance, frdd_88.dim_date_decret_date_id, frdd_88.dim_register_id,
frdd_88.dim_wallet_id, frdd_88.dim_owner_type_id, frdd_88.dim_is_debt_id,
frdd_88.dim_is_obsolete_id, frdd_88.dim_is_current_id, frdd_88.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190907 frdd_87  (cost=0.00..229414.01
rows=2154101 width=120)
                    Output: frdd_87.id, frdd_87.audit_cd, frdd_87.audit_cu,
frdd_87.audit_ca, frdd_87.contract_id, frdd_87.ct, frdd_87.dt,
frdd_87.balance, frdd_87.dim_date_decret_date_id, frdd_87.dim_register_id,
frdd_87.dim_wallet_id, frdd_87.dim_owner_type_id, frdd_87.dim_is_debt_id,
frdd_87.dim_is_obsolete_id, frdd_87.dim_is_current_id, frdd_87.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190910 frdd_90  (cost=0.00..229395.72
rows=2154372 width=120)
                    Output: frdd_90.id, frdd_90.audit_cd, frdd_90.audit_cu,
frdd_90.audit_ca, frdd_90.contract_id, frdd_90.ct, frdd_90.dt,
frdd_90.balance, frdd_90.dim_date_decret_date_id, frdd_90.dim_register_id,
frdd_90.dim_wallet_id, frdd_90.dim_owner_type_id, frdd_90.dim_is_debt_id,
frdd_90.dim_is_obsolete_id, frdd_90.dim_is_current_id, frdd_90.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190911 frdd_91  (cost=0.00..229369.55
rows=2154155 width=120)
                    Output: frdd_91.id, frdd_91.audit_cd, frdd_91.audit_cu,
frdd_91.audit_ca, frdd_91.contract_id, frdd_91.ct, frdd_91.dt,
frdd_91.balance, frdd_91.dim_date_decret_date_id, frdd_91.dim_register_id,
frdd_91.dim_wallet_id, frdd_91.dim_owner_type_id, frdd_91.dim_is_debt_id,
frdd_91.dim_is_obsolete_id, frdd_91.dim_is_current_id, frdd_91.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190912 frdd_92  (cost=0.00..229330.19
rows=2153419 width=120)
                    Output: frdd_92.id, frdd_92.audit_cd, frdd_92.audit_cu,
frdd_92.audit_ca, frdd_92.contract_id, frdd_92.ct, frdd_92.dt,
frdd_92.balance, frdd_92.dim_date_decret_date_id, frdd_92.dim_register_id,
frdd_92.dim_wallet_id, frdd_92.dim_owner_type_id, frdd_92.dim_is_debt_id,
frdd_92.dim_is_obsolete_id, frdd_92.dim_is_current_id, frdd_92.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190913 frdd_93  (cost=0.00..229215.62
rows=2152462 width=120)
                    Output: frdd_93.id, frdd_93.audit_cd, frdd_93.audit_cu,
frdd_93.audit_ca, frdd_93.contract_id, frdd_93.ct, frdd_93.dt,
frdd_93.balance, frdd_93.dim_date_decret_date_id, frdd_93.dim_register_id,
frdd_93.dim_wallet_id, frdd_93.dim_owner_type_id, frdd_93.dim_is_debt_id,
frdd_93.dim_is_obsolete_id, frdd_93.dim_is_current_id, frdd_93.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190915 frdd_95  (cost=0.00..229164.01
rows=2152201 width=120)
                    Output: frdd_95.id, frdd_95.audit_cd, frdd_95.audit_cu,
frdd_95.audit_ca, frdd_95.contract_id, frdd_95.ct, frdd_95.dt,
frdd_95.balance, frdd_95.dim_date_decret_date_id, frdd_95.dim_register_id,
frdd_95.dim_wallet_id, frdd_95.dim_owner_type_id, frdd_95.dim_is_debt_id,
frdd_95.dim_is_obsolete_id, frdd_95.dim_is_current_id, frdd_95.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190914 frdd_94  (cost=0.00..229161.55
rows=2152155 width=120)
                    Output: frdd_94.id, frdd_94.audit_cd, frdd_94.audit_cu,
frdd_94.audit_ca, frdd_94.contract_id, frdd_94.ct, frdd_94.dt,
frdd_94.balance, frdd_94.dim_date_decret_date_id, frdd_94.dim_register_id,
frdd_94.dim_wallet_id, frdd_94.dim_owner_type_id, frdd_94.dim_is_debt_id,
frdd_94.dim_is_obsolete_id, frdd_94.dim_is_current_id, frdd_94.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190916 frdd_96  (cost=0.00..229121.94
rows=2151594 width=120)
                    Output: frdd_96.id, frdd_96.audit_cd, frdd_96.audit_cu,
frdd_96.audit_ca, frdd_96.contract_id, frdd_96.ct, frdd_96.dt,
frdd_96.balance, frdd_96.dim_date_decret_date_id, frdd_96.dim_register_id,
frdd_96.dim_wallet_id, frdd_96.dim_owner_type_id, frdd_96.dim_is_debt_id,
frdd_96.dim_is_obsolete_id, frdd_96.dim_is_current_id, frdd_96.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190918 frdd_98  (cost=0.00..229096.61
rows=2151361 width=120)
                    Output: frdd_98.id, frdd_98.audit_cd, frdd_98.audit_cu,
frdd_98.audit_ca, frdd_98.contract_id, frdd_98.ct, frdd_98.dt,
frdd_98.balance, frdd_98.dim_date_decret_date_id, frdd_98.dim_register_id,
frdd_98.dim_wallet_id, frdd_98.dim_owner_type_id, frdd_98.dim_is_debt_id,
frdd_98.dim_is_obsolete_id, frdd_98.dim_is_current_id, frdd_98.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190917 frdd_97  (cost=0.00..229062.00
rows=2151000 width=120)
                    Output: frdd_97.id, frdd_97.audit_cd, frdd_97.audit_cu,
frdd_97.audit_ca, frdd_97.contract_id, frdd_97.ct, frdd_97.dt,
frdd_97.balance, frdd_97.dim_date_decret_date_id, frdd_97.dim_register_id,
frdd_97.dim_wallet_id, frdd_97.dim_owner_type_id, frdd_97.dim_is_debt_id,
frdd_97.dim_is_obsolete_id, frdd_97.dim_is_current_id, frdd_97.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190805 frdd_54  (cost=0.00..228809.83
rows=2148083 width=120)
                    Output: frdd_54.id, frdd_54.audit_cd, frdd_54.audit_cu,
frdd_54.audit_ca, frdd_54.contract_id, frdd_54.ct, frdd_54.dt,
frdd_54.balance, frdd_54.dim_date_decret_date_id, frdd_54.dim_register_id,
frdd_54.dim_wallet_id, frdd_54.dim_owner_type_id, frdd_54.dim_is_debt_id,
frdd_54.dim_is_obsolete_id, frdd_54.dim_is_current_id, frdd_54.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190802 frdd_51  (cost=0.00..228772.81
rows=2147781 width=120)
                    Output: frdd_51.id, frdd_51.audit_cd, frdd_51.audit_cu,
frdd_51.audit_ca, frdd_51.contract_id, frdd_51.ct, frdd_51.dt,
frdd_51.balance, frdd_51.dim_date_decret_date_id, frdd_51.dim_register_id,
frdd_51.dim_wallet_id, frdd_51.dim_owner_type_id, frdd_51.dim_is_debt_id,
frdd_51.dim_is_obsolete_id, frdd_51.dim_is_current_id, frdd_51.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190919 frdd_99  (cost=0.00..228743.45
rows=2147945 width=120)
                    Output: frdd_99.id, frdd_99.audit_cd, frdd_99.audit_cu,
frdd_99.audit_ca, frdd_99.contract_id, frdd_99.ct, frdd_99.dt,
frdd_99.balance, frdd_99.dim_date_decret_date_id, frdd_99.dim_register_id,
frdd_99.dim_wallet_id, frdd_99.dim_owner_type_id, frdd_99.dim_is_debt_id,
frdd_99.dim_is_obsolete_id, frdd_99.dim_is_current_id, frdd_99.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190804 frdd_53  (cost=0.00..228704.64
rows=2147464 width=120)
                    Output: frdd_53.id, frdd_53.audit_cd, frdd_53.audit_cu,
frdd_53.audit_ca, frdd_53.contract_id, frdd_53.ct, frdd_53.dt,
frdd_53.balance, frdd_53.dim_date_decret_date_id, frdd_53.dim_register_id,
frdd_53.dim_wallet_id, frdd_53.dim_owner_type_id, frdd_53.dim_is_debt_id,
frdd_53.dim_is_obsolete_id, frdd_53.dim_is_current_id, frdd_53.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190920 frdd_100  (cost=0.00..228703.59
rows=2147859 width=120)
                    Output: frdd_100.id, frdd_100.audit_cd,
frdd_100.audit_cu, frdd_100.audit_ca, frdd_100.contract_id, frdd_100.ct,
frdd_100.dt, frdd_100.balance, frdd_100.dim_date_decret_date_id,
frdd_100.dim_register_id, frdd_100.dim_wallet_id,
frdd_100.dim_owner_type_id, frdd_100.dim_is_debt_id,
frdd_100.dim_is_obsolete_id, frdd_100.dim_is_current_id, frdd_100.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190803 frdd_52  (cost=0.00..228702.98
rows=2147398 width=120)
                    Output: frdd_52.id, frdd_52.audit_cd, frdd_52.audit_cu,
frdd_52.audit_ca, frdd_52.contract_id, frdd_52.ct, frdd_52.dt,
frdd_52.balance, frdd_52.dim_date_decret_date_id, frdd_52.dim_register_id,
frdd_52.dim_wallet_id, frdd_52.dim_owner_type_id, frdd_52.dim_is_debt_id,
frdd_52.dim_is_obsolete_id, frdd_52.dim_is_current_id, frdd_52.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190806 frdd_55  (cost=0.00..228675.48
rows=2146848 width=120)
                    Output: frdd_55.id, frdd_55.audit_cd, frdd_55.audit_cu,
frdd_55.audit_ca, frdd_55.contract_id, frdd_55.ct, frdd_55.dt,
frdd_55.balance, frdd_55.dim_date_decret_date_id, frdd_55.dim_register_id,
frdd_55.dim_wallet_id, frdd_55.dim_owner_type_id, frdd_55.dim_is_debt_id,
frdd_55.dim_is_obsolete_id, frdd_55.dim_is_current_id, frdd_55.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190923 frdd_103  (cost=0.00..228670.53
rows=2147553 width=120)
                    Output: frdd_103.id, frdd_103.audit_cd,
frdd_103.audit_cu, frdd_103.audit_ca, frdd_103.contract_id, frdd_103.ct,
frdd_103.dt, frdd_103.balance, frdd_103.dim_date_decret_date_id,
frdd_103.dim_register_id, frdd_103.dim_wallet_id,
frdd_103.dim_owner_type_id, frdd_103.dim_is_debt_id,
frdd_103.dim_is_obsolete_id, frdd_103.dim_is_current_id, frdd_103.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190922 frdd_102  (cost=0.00..228662.70
rows=2147470 width=120)
                    Output: frdd_102.id, frdd_102.audit_cd,
frdd_102.audit_cu, frdd_102.audit_ca, frdd_102.contract_id, frdd_102.ct,
frdd_102.dt, frdd_102.balance, frdd_102.dim_date_decret_date_id,
frdd_102.dim_register_id, frdd_102.dim_wallet_id,
frdd_102.dim_owner_type_id, frdd_102.dim_is_debt_id,
frdd_102.dim_is_obsolete_id, frdd_102.dim_is_current_id, frdd_102.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190921 frdd_101  (cost=0.00..228660.58
rows=2147458 width=120)
                    Output: frdd_101.id, frdd_101.audit_cd,
frdd_101.audit_cu, frdd_101.audit_ca, frdd_101.contract_id, frdd_101.ct,
frdd_101.dt, frdd_101.balance, frdd_101.dim_date_decret_date_id,
frdd_101.dim_register_id, frdd_101.dim_wallet_id,
frdd_101.dim_owner_type_id, frdd_101.dim_is_debt_id,
frdd_101.dim_is_obsolete_id, frdd_101.dim_is_current_id, frdd_101.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190924 frdd_104  (cost=0.00..228644.80
rows=2147580 width=120)
                    Output: frdd_104.id, frdd_104.audit_cd,
frdd_104.audit_cu, frdd_104.audit_ca, frdd_104.contract_id, frdd_104.ct,
frdd_104.dt, frdd_104.balance, frdd_104.dim_date_decret_date_id,
frdd_104.dim_register_id, frdd_104.dim_wallet_id,
frdd_104.dim_owner_type_id, frdd_104.dim_is_debt_id,
frdd_104.dim_is_obsolete_id, frdd_104.dim_is_current_id, frdd_104.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190807 frdd_56  (cost=0.00..228629.60
rows=2146360 width=120)
                    Output: frdd_56.id, frdd_56.audit_cd, frdd_56.audit_cu,
frdd_56.audit_ca, frdd_56.contract_id, frdd_56.ct, frdd_56.dt,
frdd_56.balance, frdd_56.dim_date_decret_date_id, frdd_56.dim_register_id,
frdd_56.dim_wallet_id, frdd_56.dim_owner_type_id, frdd_56.dim_is_debt_id,
frdd_56.dim_is_obsolete_id, frdd_56.dim_is_current_id, frdd_56.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190925 frdd_105  (cost=0.00..228625.15
rows=2147215 width=120)
                    Output: frdd_105.id, frdd_105.audit_cd,
frdd_105.audit_cu, frdd_105.audit_ca, frdd_105.contract_id, frdd_105.ct,
frdd_105.dt, frdd_105.balance, frdd_105.dim_date_decret_date_id,
frdd_105.dim_register_id, frdd_105.dim_wallet_id,
frdd_105.dim_owner_type_id, frdd_105.dim_is_debt_id,
frdd_105.dim_is_obsolete_id, frdd_105.dim_is_current_id, frdd_105.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190926 frdd_106  (cost=0.00..228588.77
rows=2146777 width=120)
                    Output: frdd_106.id, frdd_106.audit_cd,
frdd_106.audit_cu, frdd_106.audit_ca, frdd_106.contract_id, frdd_106.ct,
frdd_106.dt, frdd_106.balance, frdd_106.dim_date_decret_date_id,
frdd_106.dim_register_id, frdd_106.dim_wallet_id,
frdd_106.dim_owner_type_id, frdd_106.dim_is_debt_id,
frdd_106.dim_is_obsolete_id, frdd_106.dim_is_current_id, frdd_106.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190808 frdd_57  (cost=0.00..228502.10
rows=2145110 width=120)
                    Output: frdd_57.id, frdd_57.audit_cd, frdd_57.audit_cu,
frdd_57.audit_ca, frdd_57.contract_id, frdd_57.ct, frdd_57.dt,
frdd_57.balance, frdd_57.dim_date_decret_date_id, frdd_57.dim_register_id,
frdd_57.dim_wallet_id, frdd_57.dim_owner_type_id, frdd_57.dim_is_debt_id,
frdd_57.dim_is_obsolete_id, frdd_57.dim_is_current_id, frdd_57.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190809 frdd_58  (cost=0.00..228479.73
rows=2145273 width=120)
                    Output: frdd_58.id, frdd_58.audit_cd, frdd_58.audit_cu,
frdd_58.audit_ca, frdd_58.contract_id, frdd_58.ct, frdd_58.dt,
frdd_58.balance, frdd_58.dim_date_decret_date_id, frdd_58.dim_register_id,
frdd_58.dim_wallet_id, frdd_58.dim_owner_type_id, frdd_58.dim_is_debt_id,
frdd_58.dim_is_obsolete_id, frdd_58.dim_is_current_id, frdd_58.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190812 frdd_61  (cost=0.00..228440.36
rows=2144636 width=120)
                    Output: frdd_61.id, frdd_61.audit_cd, frdd_61.audit_cu,
frdd_61.audit_ca, frdd_61.contract_id, frdd_61.ct, frdd_61.dt,
frdd_61.balance, frdd_61.dim_date_decret_date_id, frdd_61.dim_register_id,
frdd_61.dim_wallet_id, frdd_61.dim_owner_type_id, frdd_61.dim_is_debt_id,
frdd_61.dim_is_obsolete_id, frdd_61.dim_is_current_id, frdd_61.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190811 frdd_60  (cost=0.00..228403.72
rows=2144472 width=120)
                    Output: frdd_60.id, frdd_60.audit_cd, frdd_60.audit_cu,
frdd_60.audit_ca, frdd_60.contract_id, frdd_60.ct, frdd_60.dt,
frdd_60.balance, frdd_60.dim_date_decret_date_id, frdd_60.dim_register_id,
frdd_60.dim_wallet_id, frdd_60.dim_owner_type_id, frdd_60.dim_is_debt_id,
frdd_60.dim_is_obsolete_id, frdd_60.dim_is_current_id, frdd_60.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190810 frdd_59  (cost=0.00..228403.19
rows=2144419 width=120)
                    Output: frdd_59.id, frdd_59.audit_cd, frdd_59.audit_cu,
frdd_59.audit_ca, frdd_59.contract_id, frdd_59.ct, frdd_59.dt,
frdd_59.balance, frdd_59.dim_date_decret_date_id, frdd_59.dim_register_id,
frdd_59.dim_wallet_id, frdd_59.dim_owner_type_id, frdd_59.dim_is_debt_id,
frdd_59.dim_is_obsolete_id, frdd_59.dim_is_current_id, frdd_59.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190927 frdd_107  (cost=0.00..228372.90
rows=2144690 width=120)
                    Output: frdd_107.id, frdd_107.audit_cd,
frdd_107.audit_cu, frdd_107.audit_ca, frdd_107.contract_id, frdd_107.ct,
frdd_107.dt, frdd_107.balance, frdd_107.dim_date_decret_date_id,
frdd_107.dim_register_id, frdd_107.dim_wallet_id,
frdd_107.dim_owner_type_id, frdd_107.dim_is_debt_id,
frdd_107.dim_is_obsolete_id, frdd_107.dim_is_current_id, frdd_107.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190820 frdd_69  (cost=0.00..228303.94
rows=2143394 width=120)
                    Output: frdd_69.id, frdd_69.audit_cd, frdd_69.audit_cu,
frdd_69.audit_ca, frdd_69.contract_id, frdd_69.ct, frdd_69.dt,
frdd_69.balance, frdd_69.dim_date_decret_date_id, frdd_69.dim_register_id,
frdd_69.dim_wallet_id, frdd_69.dim_owner_type_id, frdd_69.dim_is_debt_id,
frdd_69.dim_is_obsolete_id, frdd_69.dim_is_current_id, frdd_69.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190930 frdd_110  (cost=0.00..228198.25
rows=2143125 width=120)
                    Output: frdd_110.id, frdd_110.audit_cd,
frdd_110.audit_cu, frdd_110.audit_ca, frdd_110.contract_id, frdd_110.ct,
frdd_110.dt, frdd_110.balance, frdd_110.dim_date_decret_date_id,
frdd_110.dim_register_id, frdd_110.dim_wallet_id,
frdd_110.dim_owner_type_id, frdd_110.dim_is_debt_id,
frdd_110.dim_is_obsolete_id, frdd_110.dim_is_current_id, frdd_110.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190819 frdd_68  (cost=0.00..228161.29
rows=2142429 width=120)
                    Output: frdd_68.id, frdd_68.audit_cd, frdd_68.audit_cu,
frdd_68.audit_ca, frdd_68.contract_id, frdd_68.ct, frdd_68.dt,
frdd_68.balance, frdd_68.dim_date_decret_date_id, frdd_68.dim_register_id,
frdd_68.dim_wallet_id, frdd_68.dim_owner_type_id, frdd_68.dim_is_debt_id,
frdd_68.dim_is_obsolete_id, frdd_68.dim_is_current_id, frdd_68.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190813 frdd_62  (cost=0.00..228155.65
rows=2142365 width=120)
                    Output: frdd_62.id, frdd_62.audit_cd, frdd_62.audit_cu,
frdd_62.audit_ca, frdd_62.contract_id, frdd_62.ct, frdd_62.dt,
frdd_62.balance, frdd_62.dim_date_decret_date_id, frdd_62.dim_register_id,
frdd_62.dim_wallet_id, frdd_62.dim_owner_type_id, frdd_62.dim_is_debt_id,
frdd_62.dim_is_obsolete_id, frdd_62.dim_is_current_id, frdd_62.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190929 frdd_109  (cost=0.00..228153.48
rows=2142948 width=120)
                    Output: frdd_109.id, frdd_109.audit_cd,
frdd_109.audit_cu, frdd_109.audit_ca, frdd_109.contract_id, frdd_109.ct,
frdd_109.dt, frdd_109.balance, frdd_109.dim_date_decret_date_id,
frdd_109.dim_register_id, frdd_109.dim_wallet_id,
frdd_109.dim_owner_type_id, frdd_109.dim_is_debt_id,
frdd_109.dim_is_obsolete_id, frdd_109.dim_is_current_id, frdd_109.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190928 frdd_108  (cost=0.00..228148.54
rows=2142854 width=120)
                    Output: frdd_108.id, frdd_108.audit_cd,
frdd_108.audit_cu, frdd_108.audit_ca, frdd_108.contract_id, frdd_108.ct,
frdd_108.dt, frdd_108.balance, frdd_108.dim_date_decret_date_id,
frdd_108.dim_register_id, frdd_108.dim_wallet_id,
frdd_108.dim_owner_type_id, frdd_108.dim_is_debt_id,
frdd_108.dim_is_obsolete_id, frdd_108.dim_is_current_id, frdd_108.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190814 frdd_63  (cost=0.00..228117.27
rows=2141927 width=120)
                    Output: frdd_63.id, frdd_63.audit_cd, frdd_63.audit_cu,
frdd_63.audit_ca, frdd_63.contract_id, frdd_63.ct, frdd_63.dt,
frdd_63.balance, frdd_63.dim_date_decret_date_id, frdd_63.dim_register_id,
frdd_63.dim_wallet_id, frdd_63.dim_owner_type_id, frdd_63.dim_is_debt_id,
frdd_63.dim_is_obsolete_id, frdd_63.dim_is_current_id, frdd_63.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190816 frdd_65  (cost=0.00..228109.51
rows=2141751 width=120)
                    Output: frdd_65.id, frdd_65.audit_cd, frdd_65.audit_cu,
frdd_65.audit_ca, frdd_65.contract_id, frdd_65.ct, frdd_65.dt,
frdd_65.balance, frdd_65.dim_date_decret_date_id, frdd_65.dim_register_id,
frdd_65.dim_wallet_id, frdd_65.dim_owner_type_id, frdd_65.dim_is_debt_id,
frdd_65.dim_is_obsolete_id, frdd_65.dim_is_current_id, frdd_65.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190817 frdd_66  (cost=0.00..228065.43
rows=2141443 width=120)
                    Output: frdd_66.id, frdd_66.audit_cd, frdd_66.audit_cu,
frdd_66.audit_ca, frdd_66.contract_id, frdd_66.ct, frdd_66.dt,
frdd_66.balance, frdd_66.dim_date_decret_date_id, frdd_66.dim_register_id,
frdd_66.dim_wallet_id, frdd_66.dim_owner_type_id, frdd_66.dim_is_debt_id,
frdd_66.dim_is_obsolete_id, frdd_66.dim_is_current_id, frdd_66.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190818 frdd_67  (cost=0.00..228062.95
rows=2141095 width=120)
                    Output: frdd_67.id, frdd_67.audit_cd, frdd_67.audit_cu,
frdd_67.audit_ca, frdd_67.contract_id, frdd_67.ct, frdd_67.dt,
frdd_67.balance, frdd_67.dim_date_decret_date_id, frdd_67.dim_register_id,
frdd_67.dim_wallet_id, frdd_67.dim_owner_type_id, frdd_67.dim_is_debt_id,
frdd_67.dim_is_obsolete_id, frdd_67.dim_is_current_id, frdd_67.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190815 frdd_64  (cost=0.00..228058.87
rows=2141287 width=120)
                    Output: frdd_64.id, frdd_64.audit_cd, frdd_64.audit_cu,
frdd_64.audit_ca, frdd_64.contract_id, frdd_64.ct, frdd_64.dt,
frdd_64.balance, frdd_64.dim_date_decret_date_id, frdd_64.dim_register_id,
frdd_64.dim_wallet_id, frdd_64.dim_owner_type_id, frdd_64.dim_is_debt_id,
frdd_64.dim_is_obsolete_id, frdd_64.dim_is_current_id, frdd_64.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190821 frdd_70  (cost=0.00..227813.05
rows=2139005 width=120)
                    Output: frdd_70.id, frdd_70.audit_cd, frdd_70.audit_cu,
frdd_70.audit_ca, frdd_70.contract_id, frdd_70.ct, frdd_70.dt,
frdd_70.balance, frdd_70.dim_date_decret_date_id, frdd_70.dim_register_id,
frdd_70.dim_wallet_id, frdd_70.dim_owner_type_id, frdd_70.dim_is_debt_id,
frdd_70.dim_is_obsolete_id, frdd_70.dim_is_current_id, frdd_70.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190822 frdd_71  (cost=0.00..227765.35
rows=2138435 width=120)
                    Output: frdd_71.id, frdd_71.audit_cd, frdd_71.audit_cu,
frdd_71.audit_ca, frdd_71.contract_id, frdd_71.ct, frdd_71.dt,
frdd_71.balance, frdd_71.dim_date_decret_date_id, frdd_71.dim_register_id,
frdd_71.dim_wallet_id, frdd_71.dim_owner_type_id, frdd_71.dim_is_debt_id,
frdd_71.dim_is_obsolete_id, frdd_71.dim_is_current_id, frdd_71.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190823 frdd_72  (cost=0.00..227747.15
rows=2138415 width=120)
                    Output: frdd_72.id, frdd_72.audit_cd, frdd_72.audit_cu,
frdd_72.audit_ca, frdd_72.contract_id, frdd_72.ct, frdd_72.dt,
frdd_72.balance, frdd_72.dim_date_decret_date_id, frdd_72.dim_register_id,
frdd_72.dim_wallet_id, frdd_72.dim_owner_type_id, frdd_72.dim_is_debt_id,
frdd_72.dim_is_obsolete_id, frdd_72.dim_is_current_id, frdd_72.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190824 frdd_73  (cost=0.00..227704.74
rows=2138074 width=120)
                    Output: frdd_73.id, frdd_73.audit_cd, frdd_73.audit_cu,
frdd_73.audit_ca, frdd_73.contract_id, frdd_73.ct, frdd_73.dt,
frdd_73.balance, frdd_73.dim_date_decret_date_id, frdd_73.dim_register_id,
frdd_73.dim_wallet_id, frdd_73.dim_owner_type_id, frdd_73.dim_is_debt_id,
frdd_73.dim_is_obsolete_id, frdd_73.dim_is_current_id, frdd_73.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190826 frdd_75  (cost=0.00..227704.37
rows=2138037 width=120)
                    Output: frdd_75.id, frdd_75.audit_cd, frdd_75.audit_cu,
frdd_75.audit_ca, frdd_75.contract_id, frdd_75.ct, frdd_75.dt,
frdd_75.balance, frdd_75.dim_date_decret_date_id, frdd_75.dim_register_id,
frdd_75.dim_wallet_id, frdd_75.dim_owner_type_id, frdd_75.dim_is_debt_id,
frdd_75.dim_is_obsolete_id, frdd_75.dim_is_current_id, frdd_75.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190825 frdd_74  (cost=0.00..227702.53
rows=2138053 width=120)
                    Output: frdd_74.id, frdd_74.audit_cd, frdd_74.audit_cu,
frdd_74.audit_ca, frdd_74.contract_id, frdd_74.ct, frdd_74.dt,
frdd_74.balance, frdd_74.dim_date_decret_date_id, frdd_74.dim_register_id,
frdd_74.dim_wallet_id, frdd_74.dim_owner_type_id, frdd_74.dim_is_debt_id,
frdd_74.dim_is_obsolete_id, frdd_74.dim_is_current_id, frdd_74.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190827 frdd_76  (cost=0.00..227656.94
rows=2137394 width=120)
                    Output: frdd_76.id, frdd_76.audit_cd, frdd_76.audit_cu,
frdd_76.audit_ca, frdd_76.contract_id, frdd_76.ct, frdd_76.dt,
frdd_76.balance, frdd_76.dim_date_decret_date_id, frdd_76.dim_register_id,
frdd_76.dim_wallet_id, frdd_76.dim_owner_type_id, frdd_76.dim_is_debt_id,
frdd_76.dim_is_obsolete_id, frdd_76.dim_is_current_id, frdd_76.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190828 frdd_77  (cost=0.00..227616.88
rows=2137188 width=120)
                    Output: frdd_77.id, frdd_77.audit_cd, frdd_77.audit_cu,
frdd_77.audit_ca, frdd_77.contract_id, frdd_77.ct, frdd_77.dt,
frdd_77.balance, frdd_77.dim_date_decret_date_id, frdd_77.dim_register_id,
frdd_77.dim_wallet_id, frdd_77.dim_owner_type_id, frdd_77.dim_is_debt_id,
frdd_77.dim_is_obsolete_id, frdd_77.dim_is_current_id, frdd_77.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190829 frdd_78  (cost=0.00..227601.25
rows=2137225 width=120)
                    Output: frdd_78.id, frdd_78.audit_cd, frdd_78.audit_cu,
frdd_78.audit_ca, frdd_78.contract_id, frdd_78.ct, frdd_78.dt,
frdd_78.balance, frdd_78.dim_date_decret_date_id, frdd_78.dim_register_id,
frdd_78.dim_wallet_id, frdd_78.dim_owner_type_id, frdd_78.dim_is_debt_id,
frdd_78.dim_is_obsolete_id, frdd_78.dim_is_current_id, frdd_78.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190830 frdd_79  (cost=0.00..227529.99
rows=2136099 width=120)
                    Output: frdd_79.id, frdd_79.audit_cd, frdd_79.audit_cu,
frdd_79.audit_ca, frdd_79.contract_id, frdd_79.ct, frdd_79.dt,
frdd_79.balance, frdd_79.dim_date_decret_date_id, frdd_79.dim_register_id,
frdd_79.dim_wallet_id, frdd_79.dim_owner_type_id, frdd_79.dim_is_debt_id,
frdd_79.dim_is_obsolete_id, frdd_79.dim_is_current_id, frdd_79.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190831 frdd_80  (cost=0.00..227492.91
rows=2135991 width=120)
                    Output: frdd_80.id, frdd_80.audit_cd, frdd_80.audit_cu,
frdd_80.audit_ca, frdd_80.contract_id, frdd_80.ct, frdd_80.dt,
frdd_80.balance, frdd_80.dim_date_decret_date_id, frdd_80.dim_register_id,
frdd_80.dim_wallet_id, frdd_80.dim_owner_type_id, frdd_80.dim_is_debt_id,
frdd_80.dim_is_obsolete_id, frdd_80.dim_is_current_id, frdd_80.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20190901 frdd_81  (cost=0.00..227488.21
rows=2135721 width=120)
                    Output: frdd_81.id, frdd_81.audit_cd, frdd_81.audit_cu,
frdd_81.audit_ca, frdd_81.contract_id, frdd_81.ct, frdd_81.dt,
frdd_81.balance, frdd_81.dim_date_decret_date_id, frdd_81.dim_register_id,
frdd_81.dim_wallet_id, frdd_81.dim_owner_type_id, frdd_81.dim_is_debt_id,
frdd_81.dim_is_obsolete_id, frdd_81.dim_is_current_id, frdd_81.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191001 frdd_111  (cost=0.00..226435.71
rows=2126771 width=120)
                    Output: frdd_111.id, frdd_111.audit_cd,
frdd_111.audit_cu, frdd_111.audit_ca, frdd_111.contract_id, frdd_111.ct,
frdd_111.dt, frdd_111.balance, frdd_111.dim_date_decret_date_id,
frdd_111.dim_register_id, frdd_111.dim_wallet_id,
frdd_111.dim_owner_type_id, frdd_111.dim_is_debt_id,
frdd_111.dim_is_obsolete_id, frdd_111.dim_is_current_id, frdd_111.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191002 frdd_112  (cost=0.00..226387.52
rows=2125952 width=120)
                    Output: frdd_112.id, frdd_112.audit_cd,
frdd_112.audit_cu, frdd_112.audit_ca, frdd_112.contract_id, frdd_112.ct,
frdd_112.dt, frdd_112.balance, frdd_112.dim_date_decret_date_id,
frdd_112.dim_register_id, frdd_112.dim_wallet_id,
frdd_112.dim_owner_type_id, frdd_112.dim_is_debt_id,
frdd_112.dim_is_obsolete_id, frdd_112.dim_is_current_id, frdd_112.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191003 frdd_113  (cost=0.00..226312.92
rows=2125092 width=120)
                    Output: frdd_113.id, frdd_113.audit_cd,
frdd_113.audit_cu, frdd_113.audit_ca, frdd_113.contract_id, frdd_113.ct,
frdd_113.dt, frdd_113.balance, frdd_113.dim_date_decret_date_id,
frdd_113.dim_register_id, frdd_113.dim_wallet_id,
frdd_113.dim_owner_type_id, frdd_113.dim_is_debt_id,
frdd_113.dim_is_obsolete_id, frdd_113.dim_is_current_id, frdd_113.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191004 frdd_114  (cost=0.00..226256.64
rows=2124864 width=120)
                    Output: frdd_114.id, frdd_114.audit_cd,
frdd_114.audit_cu, frdd_114.audit_ca, frdd_114.contract_id, frdd_114.ct,
frdd_114.dt, frdd_114.balance, frdd_114.dim_date_decret_date_id,
frdd_114.dim_register_id, frdd_114.dim_wallet_id,
frdd_114.dim_owner_type_id, frdd_114.dim_is_debt_id,
frdd_114.dim_is_obsolete_id, frdd_114.dim_is_current_id, frdd_114.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191007 frdd_117  (cost=0.00..226135.61
rows=2123661 width=120)
                    Output: frdd_117.id, frdd_117.audit_cd,
frdd_117.audit_cu, frdd_117.audit_ca, frdd_117.contract_id, frdd_117.ct,
frdd_117.dt, frdd_117.balance, frdd_117.dim_date_decret_date_id,
frdd_117.dim_register_id, frdd_117.dim_wallet_id,
frdd_117.dim_owner_type_id, frdd_117.dim_is_debt_id,
frdd_117.dim_is_obsolete_id, frdd_117.dim_is_current_id, frdd_117.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191005 frdd_115  (cost=0.00..226133.72
rows=2123872 width=120)
                    Output: frdd_115.id, frdd_115.audit_cd,
frdd_115.audit_cu, frdd_115.audit_ca, frdd_115.contract_id, frdd_115.ct,
frdd_115.dt, frdd_115.balance, frdd_115.dim_date_decret_date_id,
frdd_115.dim_register_id, frdd_115.dim_wallet_id,
frdd_115.dim_owner_type_id, frdd_115.dim_is_debt_id,
frdd_115.dim_is_obsolete_id, frdd_115.dim_is_current_id, frdd_115.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191006 frdd_116  (cost=0.00..226131.30
rows=2123630 width=120)
                    Output: frdd_116.id, frdd_116.audit_cd,
frdd_116.audit_cu, frdd_116.audit_ca, frdd_116.contract_id, frdd_116.ct,
frdd_116.dt, frdd_116.balance, frdd_116.dim_date_decret_date_id,
frdd_116.dim_register_id, frdd_116.dim_wallet_id,
frdd_116.dim_owner_type_id, frdd_116.dim_is_debt_id,
frdd_116.dim_is_obsolete_id, frdd_116.dim_is_current_id, frdd_116.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191008 frdd_118  (cost=0.00..226091.96
rows=2123496 width=120)
                    Output: frdd_118.id, frdd_118.audit_cd,
frdd_118.audit_cu, frdd_118.audit_ca, frdd_118.contract_id, frdd_118.ct,
frdd_118.dt, frdd_118.balance, frdd_118.dim_date_decret_date_id,
frdd_118.dim_register_id, frdd_118.dim_wallet_id,
frdd_118.dim_owner_type_id, frdd_118.dim_is_debt_id,
frdd_118.dim_is_obsolete_id, frdd_118.dim_is_current_id, frdd_118.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191009 frdd_119  (cost=0.00..225967.58
rows=2122258 width=120)
                    Output: frdd_119.id, frdd_119.audit_cd,
frdd_119.audit_cu, frdd_119.audit_ca, frdd_119.contract_id, frdd_119.ct,
frdd_119.dt, frdd_119.balance, frdd_119.dim_date_decret_date_id,
frdd_119.dim_register_id, frdd_119.dim_wallet_id,
frdd_119.dim_owner_type_id, frdd_119.dim_is_debt_id,
frdd_119.dim_is_obsolete_id, frdd_119.dim_is_current_id, frdd_119.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191010 frdd_120  (cost=0.00..225905.38
rows=2121638 width=120)
                    Output: frdd_120.id, frdd_120.audit_cd,
frdd_120.audit_cu, frdd_120.audit_ca, frdd_120.contract_id, frdd_120.ct,
frdd_120.dt, frdd_120.balance, frdd_120.dim_date_decret_date_id,
frdd_120.dim_register_id, frdd_120.dim_wallet_id,
frdd_120.dim_owner_type_id, frdd_120.dim_is_debt_id,
frdd_120.dim_is_obsolete_id, frdd_120.dim_is_current_id, frdd_120.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191011 frdd_121  (cost=0.00..225839.48
rows=2120548 width=120)
                    Output: frdd_121.id, frdd_121.audit_cd,
frdd_121.audit_cu, frdd_121.audit_ca, frdd_121.contract_id, frdd_121.ct,
frdd_121.dt, frdd_121.balance, frdd_121.dim_date_decret_date_id,
frdd_121.dim_register_id, frdd_121.dim_wallet_id,
frdd_121.dim_owner_type_id, frdd_121.dim_is_debt_id,
frdd_121.dim_is_obsolete_id, frdd_121.dim_is_current_id, frdd_121.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191014 frdd_124  (cost=0.00..225716.20
rows=2120020 width=120)
                    Output: frdd_124.id, frdd_124.audit_cd,
frdd_124.audit_cu, frdd_124.audit_ca, frdd_124.contract_id, frdd_124.ct,
frdd_124.dt, frdd_124.balance, frdd_124.dim_date_decret_date_id,
frdd_124.dim_register_id, frdd_124.dim_wallet_id,
frdd_124.dim_owner_type_id, frdd_124.dim_is_debt_id,
frdd_124.dim_is_obsolete_id, frdd_124.dim_is_current_id, frdd_124.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191012 frdd_122  (cost=0.00..225706.98
rows=2119598 width=120)
                    Output: frdd_122.id, frdd_122.audit_cd,
frdd_122.audit_cu, frdd_122.audit_ca, frdd_122.contract_id, frdd_122.ct,
frdd_122.dt, frdd_122.balance, frdd_122.dim_date_decret_date_id,
frdd_122.dim_register_id, frdd_122.dim_wallet_id,
frdd_122.dim_owner_type_id, frdd_122.dim_is_debt_id,
frdd_122.dim_is_obsolete_id, frdd_122.dim_is_current_id, frdd_122.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191013 frdd_123  (cost=0.00..225704.29
rows=2119829 width=120)
                    Output: frdd_123.id, frdd_123.audit_cd,
frdd_123.audit_cu, frdd_123.audit_ca, frdd_123.contract_id, frdd_123.ct,
frdd_123.dt, frdd_123.balance, frdd_123.dim_date_decret_date_id,
frdd_123.dim_register_id, frdd_123.dim_wallet_id,
frdd_123.dim_owner_type_id, frdd_123.dim_is_debt_id,
frdd_123.dim_is_obsolete_id, frdd_123.dim_is_current_id, frdd_123.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191015 frdd_125  (cost=0.00..225565.43
rows=2118343 width=120)
                    Output: frdd_125.id, frdd_125.audit_cd,
frdd_125.audit_cu, frdd_125.audit_ca, frdd_125.contract_id, frdd_125.ct,
frdd_125.dt, frdd_125.balance, frdd_125.dim_date_decret_date_id,
frdd_125.dim_register_id, frdd_125.dim_wallet_id,
frdd_125.dim_owner_type_id, frdd_125.dim_is_debt_id,
frdd_125.dim_is_obsolete_id, frdd_125.dim_is_current_id, frdd_125.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191016 frdd_126  (cost=0.00..225478.22
rows=2117722 width=120)
                    Output: frdd_126.id, frdd_126.audit_cd,
frdd_126.audit_cu, frdd_126.audit_ca, frdd_126.contract_id, frdd_126.ct,
frdd_126.dt, frdd_126.balance, frdd_126.dim_date_decret_date_id,
frdd_126.dim_register_id, frdd_126.dim_wallet_id,
frdd_126.dim_owner_type_id, frdd_126.dim_is_debt_id,
frdd_126.dim_is_obsolete_id, frdd_126.dim_is_current_id, frdd_126.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191017 frdd_127  (cost=0.00..225245.15
rows=2115415 width=120)
                    Output: frdd_127.id, frdd_127.audit_cd,
frdd_127.audit_cu, frdd_127.audit_ca, frdd_127.contract_id, frdd_127.ct,
frdd_127.dt, frdd_127.balance, frdd_127.dim_date_decret_date_id,
frdd_127.dim_register_id, frdd_127.dim_wallet_id,
frdd_127.dim_owner_type_id, frdd_127.dim_is_debt_id,
frdd_127.dim_is_obsolete_id, frdd_127.dim_is_current_id, frdd_127.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191018 frdd_128  (cost=0.00..225112.15
rows=2114015 width=120)
                    Output: frdd_128.id, frdd_128.audit_cd,
frdd_128.audit_cu, frdd_128.audit_ca, frdd_128.contract_id, frdd_128.ct,
frdd_128.dt, frdd_128.balance, frdd_128.dim_date_decret_date_id,
frdd_128.dim_register_id, frdd_128.dim_wallet_id,
frdd_128.dim_owner_type_id, frdd_128.dim_is_debt_id,
frdd_128.dim_is_obsolete_id, frdd_128.dim_is_current_id, frdd_128.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191021 frdd_131  (cost=0.00..224967.44
rows=2112844 width=120)
                    Output: frdd_131.id, frdd_131.audit_cd,
frdd_131.audit_cu, frdd_131.audit_ca, frdd_131.contract_id, frdd_131.ct,
frdd_131.dt, frdd_131.balance, frdd_131.dim_date_decret_date_id,
frdd_131.dim_register_id, frdd_131.dim_wallet_id,
frdd_131.dim_owner_type_id, frdd_131.dim_is_debt_id,
frdd_131.dim_is_obsolete_id, frdd_131.dim_is_current_id, frdd_131.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191020 frdd_130  (cost=0.00..224957.04
rows=2112404 width=120)
                    Output: frdd_130.id, frdd_130.audit_cd,
frdd_130.audit_cu, frdd_130.audit_ca, frdd_130.contract_id, frdd_130.ct,
frdd_130.dt, frdd_130.balance, frdd_130.dim_date_decret_date_id,
frdd_130.dim_register_id, frdd_130.dim_wallet_id,
frdd_130.dim_owner_type_id, frdd_130.dim_is_debt_id,
frdd_130.dim_is_obsolete_id, frdd_130.dim_is_current_id, frdd_130.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191019 frdd_129  (cost=0.00..224954.53
rows=2112453 width=120)
                    Output: frdd_129.id, frdd_129.audit_cd,
frdd_129.audit_cu, frdd_129.audit_ca, frdd_129.contract_id, frdd_129.ct,
frdd_129.dt, frdd_129.balance, frdd_129.dim_date_decret_date_id,
frdd_129.dim_register_id, frdd_129.dim_wallet_id,
frdd_129.dim_owner_type_id, frdd_129.dim_is_debt_id,
frdd_129.dim_is_obsolete_id, frdd_129.dim_is_current_id, frdd_129.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191022 frdd_132  (cost=0.00..224829.48
rows=2111448 width=120)
                    Output: frdd_132.id, frdd_132.audit_cd,
frdd_132.audit_cu, frdd_132.audit_ca, frdd_132.contract_id, frdd_132.ct,
frdd_132.dt, frdd_132.balance, frdd_132.dim_date_decret_date_id,
frdd_132.dim_register_id, frdd_132.dim_wallet_id,
frdd_132.dim_owner_type_id, frdd_132.dim_is_debt_id,
frdd_132.dim_is_obsolete_id, frdd_132.dim_is_current_id, frdd_132.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191023 frdd_133  (cost=0.00..224742.75
rows=2110875 width=120)
                    Output: frdd_133.id, frdd_133.audit_cd,
frdd_133.audit_cu, frdd_133.audit_ca, frdd_133.contract_id, frdd_133.ct,
frdd_133.dt, frdd_133.balance, frdd_133.dim_date_decret_date_id,
frdd_133.dim_register_id, frdd_133.dim_wallet_id,
frdd_133.dim_owner_type_id, frdd_133.dim_is_debt_id,
frdd_133.dim_is_obsolete_id, frdd_133.dim_is_current_id, frdd_133.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191024 frdd_134  (cost=0.00..224606.42
rows=2109342 width=120)
                    Output: frdd_134.id, frdd_134.audit_cd,
frdd_134.audit_cu, frdd_134.audit_ca, frdd_134.contract_id, frdd_134.ct,
frdd_134.dt, frdd_134.balance, frdd_134.dim_date_decret_date_id,
frdd_134.dim_register_id, frdd_134.dim_wallet_id,
frdd_134.dim_owner_type_id, frdd_134.dim_is_debt_id,
frdd_134.dim_is_obsolete_id, frdd_134.dim_is_current_id, frdd_134.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191025 frdd_135  (cost=0.00..224493.53
rows=2108253 width=120)
                    Output: frdd_135.id, frdd_135.audit_cd,
frdd_135.audit_cu, frdd_135.audit_ca, frdd_135.contract_id, frdd_135.ct,
frdd_135.dt, frdd_135.balance, frdd_135.dim_date_decret_date_id,
frdd_135.dim_register_id, frdd_135.dim_wallet_id,
frdd_135.dim_owner_type_id, frdd_135.dim_is_debt_id,
frdd_135.dim_is_obsolete_id, frdd_135.dim_is_current_id, frdd_135.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191028 frdd_138  (cost=0.00..224370.23
rows=2107223 width=120)
                    Output: frdd_138.id, frdd_138.audit_cd,
frdd_138.audit_cu, frdd_138.audit_ca, frdd_138.contract_id, frdd_138.ct,
frdd_138.dt, frdd_138.balance, frdd_138.dim_date_decret_date_id,
frdd_138.dim_register_id, frdd_138.dim_wallet_id,
frdd_138.dim_owner_type_id, frdd_138.dim_is_debt_id,
frdd_138.dim_is_obsolete_id, frdd_138.dim_is_current_id, frdd_138.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191031 frdd_141  (cost=0.00..224352.73
rows=2107173 width=120)
                    Output: frdd_141.id, frdd_141.audit_cd,
frdd_141.audit_cu, frdd_141.audit_ca, frdd_141.contract_id, frdd_141.ct,
frdd_141.dt, frdd_141.balance, frdd_141.dim_date_decret_date_id,
frdd_141.dim_register_id, frdd_141.dim_wallet_id,
frdd_141.dim_owner_type_id, frdd_141.dim_is_debt_id,
frdd_141.dim_is_obsolete_id, frdd_141.dim_is_current_id, frdd_141.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191026 frdd_136  (cost=0.00..224345.79
rows=2106879 width=120)
                    Output: frdd_136.id, frdd_136.audit_cd,
frdd_136.audit_cu, frdd_136.audit_ca, frdd_136.contract_id, frdd_136.ct,
frdd_136.dt, frdd_136.balance, frdd_136.dim_date_decret_date_id,
frdd_136.dim_register_id, frdd_136.dim_wallet_id,
frdd_136.dim_owner_type_id, frdd_136.dim_is_debt_id,
frdd_136.dim_is_obsolete_id, frdd_136.dim_is_current_id, frdd_136.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191027 frdd_137  (cost=0.00..224342.08
rows=2106808 width=120)
                    Output: frdd_137.id, frdd_137.audit_cd,
frdd_137.audit_cu, frdd_137.audit_ca, frdd_137.contract_id, frdd_137.ct,
frdd_137.dt, frdd_137.balance, frdd_137.dim_date_decret_date_id,
frdd_137.dim_register_id, frdd_137.dim_wallet_id,
frdd_137.dim_owner_type_id, frdd_137.dim_is_debt_id,
frdd_137.dim_is_obsolete_id, frdd_137.dim_is_current_id, frdd_137.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191029 frdd_139  (cost=0.00..224280.11
rows=2106611 width=120)
                    Output: frdd_139.id, frdd_139.audit_cd,
frdd_139.audit_cu, frdd_139.audit_ca, frdd_139.contract_id, frdd_139.ct,
frdd_139.dt, frdd_139.balance, frdd_139.dim_date_decret_date_id,
frdd_139.dim_register_id, frdd_139.dim_wallet_id,
frdd_139.dim_owner_type_id, frdd_139.dim_is_debt_id,
frdd_139.dim_is_obsolete_id, frdd_139.dim_is_current_id, frdd_139.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191030 frdd_140  (cost=0.00..224212.02
rows=2105802 width=120)
                    Output: frdd_140.id, frdd_140.audit_cd,
frdd_140.audit_cu, frdd_140.audit_ca, frdd_140.contract_id, frdd_140.ct,
frdd_140.dt, frdd_140.balance, frdd_140.dim_date_decret_date_id,
frdd_140.dim_register_id, frdd_140.dim_wallet_id,
frdd_140.dim_owner_type_id, frdd_140.dim_is_debt_id,
frdd_140.dim_is_obsolete_id, frdd_140.dim_is_current_id, frdd_140.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191103 frdd_144  (cost=0.00..221415.54
rows=2079454 width=120)
                    Output: frdd_144.id, frdd_144.audit_cd,
frdd_144.audit_cu, frdd_144.audit_ca, frdd_144.contract_id, frdd_144.ct,
frdd_144.dt, frdd_144.balance, frdd_144.dim_date_decret_date_id,
frdd_144.dim_register_id, frdd_144.dim_wallet_id,
frdd_144.dim_owner_type_id, frdd_144.dim_is_debt_id,
frdd_144.dim_is_obsolete_id, frdd_144.dim_is_current_id, frdd_144.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191101 frdd_142  (cost=0.00..221409.47
rows=2079547 width=120)
                    Output: frdd_142.id, frdd_142.audit_cd,
frdd_142.audit_cu, frdd_142.audit_ca, frdd_142.contract_id, frdd_142.ct,
frdd_142.dt, frdd_142.balance, frdd_142.dim_date_decret_date_id,
frdd_142.dim_register_id, frdd_142.dim_wallet_id,
frdd_142.dim_owner_type_id, frdd_142.dim_is_debt_id,
frdd_142.dim_is_obsolete_id, frdd_142.dim_is_current_id, frdd_142.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191105 frdd_146  (cost=0.00..221352.55
rows=2079055 width=120)
                    Output: frdd_146.id, frdd_146.audit_cd,
frdd_146.audit_cu, frdd_146.audit_ca, frdd_146.contract_id, frdd_146.ct,
frdd_146.dt, frdd_146.balance, frdd_146.dim_date_decret_date_id,
frdd_146.dim_register_id, frdd_146.dim_wallet_id,
frdd_146.dim_owner_type_id, frdd_146.dim_is_debt_id,
frdd_146.dim_is_obsolete_id, frdd_146.dim_is_current_id, frdd_146.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191102 frdd_143  (cost=0.00..221345.98
rows=2078598 width=120)
                    Output: frdd_143.id, frdd_143.audit_cd,
frdd_143.audit_cu, frdd_143.audit_ca, frdd_143.contract_id, frdd_143.ct,
frdd_143.dt, frdd_143.balance, frdd_143.dim_date_decret_date_id,
frdd_143.dim_register_id, frdd_143.dim_wallet_id,
frdd_143.dim_owner_type_id, frdd_143.dim_is_debt_id,
frdd_143.dim_is_obsolete_id, frdd_143.dim_is_current_id, frdd_143.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191104 frdd_145  (cost=0.00..221251.60
rows=2077860 width=120)
                    Output: frdd_145.id, frdd_145.audit_cd,
frdd_145.audit_cu, frdd_145.audit_ca, frdd_145.contract_id, frdd_145.ct,
frdd_145.dt, frdd_145.balance, frdd_145.dim_date_decret_date_id,
frdd_145.dim_register_id, frdd_145.dim_wallet_id,
frdd_145.dim_owner_type_id, frdd_145.dim_is_debt_id,
frdd_145.dim_is_obsolete_id, frdd_145.dim_is_current_id, frdd_145.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191106 frdd_147  (cost=0.00..221246.36
rows=2077836 width=120)
                    Output: frdd_147.id, frdd_147.audit_cd,
frdd_147.audit_cu, frdd_147.audit_ca, frdd_147.contract_id, frdd_147.ct,
frdd_147.dt, frdd_147.balance, frdd_147.dim_date_decret_date_id,
frdd_147.dim_register_id, frdd_147.dim_wallet_id,
frdd_147.dim_owner_type_id, frdd_147.dim_is_debt_id,
frdd_147.dim_is_obsolete_id, frdd_147.dim_is_current_id, frdd_147.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191107 frdd_148  (cost=0.00..221154.03
rows=2077203 width=120)
                    Output: frdd_148.id, frdd_148.audit_cd,
frdd_148.audit_cu, frdd_148.audit_ca, frdd_148.contract_id, frdd_148.ct,
frdd_148.dt, frdd_148.balance, frdd_148.dim_date_decret_date_id,
frdd_148.dim_register_id, frdd_148.dim_wallet_id,
frdd_148.dim_owner_type_id, frdd_148.dim_is_debt_id,
frdd_148.dim_is_obsolete_id, frdd_148.dim_is_current_id, frdd_148.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191108 frdd_149  (cost=0.00..221052.93
rows=2076093 width=120)
                    Output: frdd_149.id, frdd_149.audit_cd,
frdd_149.audit_cu, frdd_149.audit_ca, frdd_149.contract_id, frdd_149.ct,
frdd_149.dt, frdd_149.balance, frdd_149.dim_date_decret_date_id,
frdd_149.dim_register_id, frdd_149.dim_wallet_id,
frdd_149.dim_owner_type_id, frdd_149.dim_is_debt_id,
frdd_149.dim_is_obsolete_id, frdd_149.dim_is_current_id, frdd_149.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191109 frdd_150  (cost=0.00..220311.04
rows=2069304 width=120)
                    Output: frdd_150.id, frdd_150.audit_cd,
frdd_150.audit_cu, frdd_150.audit_ca, frdd_150.contract_id, frdd_150.ct,
frdd_150.dt, frdd_150.balance, frdd_150.dim_date_decret_date_id,
frdd_150.dim_register_id, frdd_150.dim_wallet_id,
frdd_150.dim_owner_type_id, frdd_150.dim_is_debt_id,
frdd_150.dim_is_obsolete_id, frdd_150.dim_is_current_id, frdd_150.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191110 frdd_151  (cost=0.00..220310.50
rows=2069250 width=120)
                    Output: frdd_151.id, frdd_151.audit_cd,
frdd_151.audit_cu, frdd_151.audit_ca, frdd_151.contract_id, frdd_151.ct,
frdd_151.dt, frdd_151.balance, frdd_151.dim_date_decret_date_id,
frdd_151.dim_register_id, frdd_151.dim_wallet_id,
frdd_151.dim_owner_type_id, frdd_151.dim_is_debt_id,
frdd_151.dim_is_obsolete_id, frdd_151.dim_is_current_id, frdd_151.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191111 frdd_152  (cost=0.00..220307.66
rows=2069166 width=120)
                    Output: frdd_152.id, frdd_152.audit_cd,
frdd_152.audit_cu, frdd_152.audit_ca, frdd_152.contract_id, frdd_152.ct,
frdd_152.dt, frdd_152.balance, frdd_152.dim_date_decret_date_id,
frdd_152.dim_register_id, frdd_152.dim_wallet_id,
frdd_152.dim_owner_type_id, frdd_152.dim_is_debt_id,
frdd_152.dim_is_obsolete_id, frdd_152.dim_is_current_id, frdd_152.nrb
              ->  Parallel Seq Scan on
dw.fact_registers_decret_date_20191112 frdd_153  (cost=0.00..220304.32
rows=2068932 width=120)
                    Output: frdd_153.id, frdd_153.audit_cd,
frdd_153.audit_cu, frdd_153.audit_ca, frdd_153.contract_id, frdd_153.ct,
frdd_153.dt, frdd_153.balance, frdd_153.dim_date_decret_date_id,
frdd_153.dim_register_id, frdd_153.dim_wallet_id,
frdd_153.dim_owner_type_id, frdd_153.dim_is_debt_id,
frdd_153.dim_is_obsolete_id, frdd_153.dim_is_current_id, frdd_153.nrb
        ->  Hash  (cost=1.01..1.01 rows=1 width=4)
              Output: dd.id
              ->  Seq Scan on temp.dim_dates dd  (cost=0.00..1.01 rows=1
width=4)
                    Output: dd.id
JIT:
  Functions: 7
  Options: Inlining true, Optimization true, Expressions true, Deforming
true

Messages

DateAuthorSubject
2019-12-12 15:20:47+00PG Bug reporting formBUG #16163: Seq scan through all the partitions on a partitioned table when joined small, dictionary table.
2019-12-18 01:34:53+00Amit LangoteRe: BUG #16163: Seq scan through all the partitions on a partitioned table when joined small, dictionary table.