Thread: BUG #16163: Seq scan through all the partitions on a partitioned table when joined small, dictionary table.
BUG #16163: Seq scan through all the partitions on a partitioned table when joined small, dictionary table.
From
PG Bug reporting form
Date:
The following bug has been logged on the website:
Bug reference: 16163
Logged by: Sebastian Ćmak
Email address: seb55@op.pl
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
Re: BUG #16163: Seq scan through all the partitions on a partitionedtable when joined small, dictionary table.
From
Amit Langote
Date:
Hello, On Fri, Dec 13, 2019 at 12:21 AM PG Bug reporting form <noreply@postgresql.org> wrote: > The following bug has been logged on the website: > > Bug reference: 16163 > Logged by: Sebastian Ćmak > Email address: seb55@op.pl > 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 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) Hmm, I don't think there is any bug here. It's reasonable to expect partition pruning to eliminate unnecessary partition scans, but the above query needs to be rewritten for partition pruning to occur. In fact, didn't you mean to join using frdd.dim_date_decret_date_id= to_char(dd.date_val, 'YYYYMMDD')::integer. Also, partition pruning can only occur if nested loop join is used, not with hash or merge join. So, you will need to disable hash and merge join too. Maybe we'll need to make the planner smarter about this in the future though, that is, choose nested loop over hash/merge if the former can use partition pruning. Thanks, Amit