BUG #16163: Seq scan through all the partitions on a partitioned table when joined small, dictionary table.
От | PG Bug reporting form |
---|---|
Тема | BUG #16163: Seq scan through all the partitions on a partitioned table when joined small, dictionary table. |
Дата | |
Msg-id | 16163-11e09f001d35c137@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16163: Seq scan through all the partitions on a partitionedtable when joined small, dictionary table.
(Amit Langote <amitlangote09@gmail.com>)
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Tom LaneДата:
Сообщение: Re: BUG #16162: create index using gist_trgm_ops leads to panic