> I assume 2TO is 2TB?
Yes. 2TB
> I don't understand why you're sharing just a part of the plan
As for the nested loop plan, what I shared is the full plan. Actually
it is repeated many times, since 2M batched by 500 rows. I add it
again:
Merge on goliath_23 ca (cost=2139.75..11077.17 rows=0 width=0)
-> Nested Loop Left Join (cost=2139.75..11077.17 rows=1000
width=575)
-> Limit (cost=2139.19..2495.67 rows=1000 width=569)
-> Index Scan using david_23_list_id_account_id_idx on
david_23 (cost=0.29..6794.16 rows=19058 width=569)
-> Index Scan using goliath_23_list_id_account_id_idx on
goliath_23 ca (cost=0.56..8.56 rows=1 width=14)
Index Cond: (list_id = david_23.list_id)
> Well, I kinda doubt you have 17023331531230 rows (not even physically
> possible with 2TB disk), so that's immediately suspicious.
Below is the full plan for the strategy 2.1 (Indeed the previous email
plan was truncated and wrong, sorry for that).
Note that both plan acome from the same partitioned by hash table with
100 parts, with a unique index on the list_id + hash_key. For strategy
2.1, I turned on enable_partitionwise_join, since david table has the
same partitioning scheme as goliath including unique indexe. In both
case the query is:
MERGE INTO "goliath" ca
USING (SELECT * FROM "david" ORDER BY "list_id") AS t
ON t."list_id" = ca."list_id"
WHEN MATCHED THEN
UPDATE SET ...
WHEN NOT MATCHED THEN
INSERT (...)
VALUES (...)
Except in strategy 3 david is split by limit/offset 500 on each part
tables such:
MERGE INTO "goliath_23" ca
USING (SELECT * FROM "david_23" ORDER BY "list_id" LIMIT 500 OFFSET 0)
AS t
ON t."list_id" = ca."list_id"
WHEN MATCHED THEN
UPDATE SET ...
WHEN NOT MATCHED THEN
INSERT (...)
VALUES (...)
Merge on goliath ca (cost=178016528.81..192778842.44 rows=0 width=0)
Merge on goliath_0 ca_1
Merge on goliath_1 ca_2
Merge on goliath_2 ca_3
Merge on goliath_3 ca_4
Merge on goliath_4 ca_5
Merge on goliath_5 ca_6
Merge on goliath_6 ca_7
Merge on goliath_7 ca_8
Merge on goliath_8 ca_9
Merge on goliath_9 ca_10
Merge on goliath_10 ca_11
Merge on goliath_11 ca_12
Merge on goliath_12 ca_13
Merge on goliath_13 ca_14
Merge on goliath_14 ca_15
Merge on goliath_15 ca_16
Merge on goliath_16 ca_17
Merge on goliath_17 ca_18
Merge on goliath_18 ca_19
Merge on goliath_19 ca_20
Merge on goliath_20 ca_21
Merge on goliath_21 ca_22
Merge on goliath_22 ca_23
Merge on goliath_23 ca_24
Merge on goliath_24 ca_25
Merge on goliath_25 ca_26
Merge on goliath_26 ca_27
Merge on goliath_27 ca_28
Merge on goliath_28 ca_29
Merge on goliath_29 ca_30
Merge on goliath_30 ca_31
Merge on goliath_31 ca_32
Merge on goliath_32 ca_33
Merge on goliath_33 ca_34
Merge on goliath_34 ca_35
Merge on goliath_35 ca_36
Merge on goliath_36 ca_37
Merge on goliath_37 ca_38
Merge on goliath_38 ca_39
Merge on goliath_39 ca_40
Merge on goliath_40 ca_41
Merge on goliath_41 ca_42
Merge on goliath_42 ca_43
Merge on goliath_43 ca_44
Merge on goliath_44 ca_45
Merge on goliath_45 ca_46
Merge on goliath_46 ca_47
Merge on goliath_47 ca_48
Merge on goliath_48 ca_49
Merge on goliath_49 ca_50
Merge on goliath_50 ca_51
Merge on goliath_51 ca_52
Merge on goliath_52 ca_53
Merge on goliath_53 ca_54
Merge on goliath_54 ca_55
Merge on goliath_55 ca_56
Merge on goliath_56 ca_57
Merge on goliath_57 ca_58
Merge on goliath_58 ca_59
Merge on goliath_59 ca_60
Merge on goliath_60 ca_61
Merge on goliath_61 ca_62
Merge on goliath_62 ca_63
Merge on goliath_63 ca_64
Merge on goliath_64 ca_65
Merge on goliath_65 ca_66
Merge on goliath_66 ca_67
Merge on goliath_67 ca_68
Merge on goliath_68 ca_69
Merge on goliath_69 ca_70
Merge on goliath_70 ca_71
Merge on goliath_71 ca_72
Merge on goliath_72 ca_73
Merge on goliath_73 ca_74
Merge on goliath_74 ca_75
Merge on goliath_75 ca_76
Merge on goliath_76 ca_77
Merge on goliath_77 ca_78
Merge on goliath_78 ca_79
Merge on goliath_79 ca_80
Merge on goliath_80 ca_81
Merge on goliath_81 ca_82
Merge on goliath_82 ca_83
Merge on goliath_83 ca_84
Merge on goliath_84 ca_85
Merge on goliath_85 ca_86
Merge on goliath_86 ca_87
Merge on goliath_87 ca_88
Merge on goliath_88 ca_89
Merge on goliath_89 ca_90
Merge on goliath_90 ca_91
Merge on goliath_91 ca_92
Merge on goliath_92 ca_93
Merge on goliath_93 ca_94
Merge on goliath_94 ca_95
Merge on goliath_95 ca_96
Merge on goliath_96 ca_97
Merge on goliath_97 ca_98
Merge on goliath_98 ca_99
Merge on goliath_99 ca_100
-> Hash Left Join (cost=178016528.81..192778842.44 rows=2187354 width=579)
Hash Cond: (david.list_id = ca.list_id)
-> Append (cost=0.00..201068.31 rows=2187354 width=569)
-> Seq Scan on david_0 david_1 (cost=0.00..1926.65 rows=22165 width=569)
-> Seq Scan on david_1 david_2 (cost=0.00..1809.13 rows=20813 width=569)
-> Seq Scan on david_2 david_3 (cost=0.00..1812.52 rows=20852 width=569)
-> Seq Scan on david_3 david_4 (cost=0.00..1648.67 rows=18967 width=569)
-> Seq Scan on david_4 david_5 (cost=0.00..1853.20 rows=21320 width=569)
-> Seq Scan on david_5 david_6 (cost=0.00..1735.68 rows=19968 width=569)
-> Seq Scan on david_6 david_7 (cost=0.00..1693.87 rows=19487 width=569)
-> Seq Scan on david_7 david_8 (cost=0.00..1872.41 rows=21541 width=569)
-> Seq Scan on david_8 david_9 (cost=0.00..1827.21 rows=21021 width=569)
-> Seq Scan on david_9 david_10 (cost=0.00..1815.91 rows=20891 width=569)
-> Seq Scan on david_10 david_11 (cost=0.00..1757.15 rows=20215 width=569)
-> Seq Scan on david_11 david_12 (cost=0.00..1624.94 rows=18694 width=569)
-> Seq Scan on david_12 david_13 (cost=0.00..1867.89 rows=21489 width=569)
-> Seq Scan on david_13 david_14 (cost=0.00..1979.76 rows=22776 width=569)
-> Seq Scan on david_14 david_15 (cost=0.00..1706.30 rows=19630 width=569)
-> Seq Scan on david_15 david_16 (cost=0.00..1828.34 rows=21034 width=569)
-> Seq Scan on david_16 david_17 (cost=0.00..1702.91 rows=19591 width=569)
-> Seq Scan on david_17 david_18 (cost=0.00..1805.74 rows=20774 width=569)
-> Seq Scan on david_18 david_19 (cost=0.00..3531.25 rows=40625 width=569)
-> Seq Scan on david_19 david_20 (cost=0.00..1522.11 rows=17511 width=569)
-> Seq Scan on david_20 david_21 (cost=0.00..1950.38 rows=22438 width=569)
-> Seq Scan on david_21 david_22 (cost=0.00..1957.16 rows=22516 width=569)
-> Seq Scan on david_22 david_23 (cost=0.00..1745.85 rows=20085 width=569)
-> Seq Scan on david_23 david_24 (cost=0.00..1730.03 rows=19903 width=569)
-> Seq Scan on david_24 david_25 (cost=0.00..1784.27 rows=20527 width=569)
-> Seq Scan on david_25 david_26 (cost=0.00..1698.39 rows=19539 width=569)
-> Seq Scan on david_26 david_27 (cost=0.00..1900.66 rows=21866 width=569)
-> Seq Scan on david_27 david_28 (cost=0.00..1813.65 rows=20865 width=569)
-> Seq Scan on david_28 david_29 (cost=0.00..2009.14 rows=23114 width=569)
-> Seq Scan on david_29 david_30 (cost=0.00..1778.62 rows=20462 width=569)
-> Seq Scan on david_30 david_31 (cost=0.00..1779.75 rows=20475 width=569)
-> Seq Scan on david_31 david_32 (cost=0.00..1892.75 rows=21775 width=569)
-> Seq Scan on david_32 david_33 (cost=0.00..1988.80 rows=22880 width=569)
-> Seq Scan on david_33 david_34 (cost=0.00..1804.61 rows=20761 width=569)
-> Seq Scan on david_34 david_35 (cost=0.00..1857.72 rows=21372 width=569)
-> Seq Scan on david_35 david_36 (cost=0.00..1782.01 rows=20501 width=569)
-> Seq Scan on david_36 david_37 (cost=0.00..2352.66 rows=27066 width=569)
-> Seq Scan on david_37 david_38 (cost=0.00..1962.81 rows=22581 width=569)
-> Seq Scan on david_38 david_39 (cost=0.00..2002.36 rows=23036 width=569)
-> Seq Scan on david_39 david_40 (cost=0.00..1852.07 rows=21307 width=569)
-> Seq Scan on david_40 david_41 (cost=0.00..2116.49 rows=24349 width=569)
-> Seq Scan on david_41 david_42 (cost=0.00..1785.40 rows=20540 width=569)
-> Seq Scan on david_42 david_43 (cost=0.00..1838.51 rows=21151 width=569)
-> Seq Scan on david_43 david_44 (cost=0.00..1931.17 rows=22217 width=569)
-> Seq Scan on david_44 david_45 (cost=0.00..1878.06 rows=21606 width=569)
-> Seq Scan on david_45 david_46 (cost=0.00..1859.98 rows=21398 width=569)
-> Seq Scan on david_46 david_47 (cost=0.00..1882.58 rows=21658 width=569)
-> Seq Scan on david_47 david_48 (cost=0.00..1791.05 rows=20605 width=569)
-> Seq Scan on david_48 david_49 (cost=0.00..1925.52 rows=22152 width=569)
-> Seq Scan on david_49 david_50 (cost=0.00..1953.77 rows=22477 width=569)
-> Seq Scan on david_50 david_51 (cost=0.00..1797.83 rows=20683 width=569)
-> Seq Scan on david_51 david_52 (cost=0.00..1680.31 rows=19331 width=569)
-> Seq Scan on david_52 david_53 (cost=0.00..1626.07 rows=18707 width=569)
-> Seq Scan on david_53 david_54 (cost=0.00..2003.49 rows=23049 width=569)
-> Seq Scan on david_54 david_55 (cost=0.00..1771.84 rows=20384 width=569)
-> Seq Scan on david_55 david_56 (cost=0.00..1700.65 rows=19565 width=569)
-> Seq Scan on david_56 david_57 (cost=0.00..1931.17 rows=22217 width=569)
-> Seq Scan on david_57 david_58 (cost=0.00..1833.99 rows=21099 width=569)
-> Seq Scan on david_58 david_59 (cost=0.00..1918.74 rows=22074 width=569)
-> Seq Scan on david_59 david_60 (cost=0.00..1885.97 rows=21697 width=569)
-> Seq Scan on david_60 david_61 (cost=0.00..4095.12 rows=47112 width=569)
-> Seq Scan on david_61 david_62 (cost=0.00..2076.94 rows=23894 width=569)
-> Seq Scan on david_62 david_63 (cost=0.00..2876.98 rows=33098 width=569)
-> Seq Scan on david_63 david_64 (cost=0.00..1647.54 rows=18954 width=569)
-> Seq Scan on david_64 david_65 (cost=0.00..1653.19 rows=19019 width=569)
-> Seq Scan on david_65 david_66 (cost=0.00..1684.83 rows=19383 width=569)
-> Seq Scan on david_66 david_67 (cost=0.00..1863.37 rows=21437 width=569)
-> Seq Scan on david_67 david_68 (cost=0.00..1717.60 rows=19760 width=569)
-> Seq Scan on david_68 david_69 (cost=0.00..1847.55 rows=21255 width=569)
-> Seq Scan on david_69 david_70 (cost=0.00..2235.14 rows=25714 width=569)
-> Seq Scan on david_70 david_71 (cost=0.00..2273.56 rows=26156 width=569)
-> Seq Scan on david_71 david_72 (cost=0.00..1745.85 rows=20085 width=569)
-> Seq Scan on david_72 david_73 (cost=0.00..1861.11 rows=21411 width=569)
-> Seq Scan on david_73 david_74 (cost=0.00..1856.59 rows=21359 width=569)
-> Seq Scan on david_74 david_75 (cost=0.00..1885.97 rows=21697 width=569)
-> Seq Scan on david_75 david_76 (cost=0.00..1665.62 rows=19162 width=569)
-> Seq Scan on david_76 david_77 (cost=0.00..1870.15 rows=21515 width=569)
-> Seq Scan on david_77 david_78 (cost=0.00..1776.36 rows=20436 width=569)
-> Seq Scan on david_78 david_79 (cost=0.00..1766.19 rows=20319 width=569)
-> Seq Scan on david_79 david_80 (cost=0.00..1812.52 rows=20852 width=569)
-> Seq Scan on david_80 david_81 (cost=0.00..1995.58 rows=22958 width=569)
-> Seq Scan on david_81 david_82 (cost=0.00..1701.78 rows=19578 width=569)
-> Seq Scan on david_82 david_83 (cost=0.00..1658.84 rows=19084 width=569)
-> Seq Scan on david_83 david_84 (cost=0.00..1840.77 rows=21177 width=569)
-> Seq Scan on david_84 david_85 (cost=0.00..1688.22 rows=19422 width=569)
-> Seq Scan on david_85 david_86 (cost=0.00..1918.74 rows=22074 width=569)
-> Seq Scan on david_86 david_87 (cost=0.00..2963.99 rows=34099 width=569)
-> Seq Scan on david_87 david_88 (cost=0.00..2075.81 rows=23881 width=569)
-> Seq Scan on david_88 david_89 (cost=0.00..1783.14 rows=20514 width=569)
-> Seq Scan on david_89 david_90 (cost=0.00..1765.06 rows=20306 width=569)
-> Seq Scan on david_90 david_91 (cost=0.00..1950.38 rows=22438 width=569)
-> Seq Scan on david_91 david_92 (cost=0.00..1840.77 rows=21177 width=569)
-> Seq Scan on david_92 david_93 (cost=0.00..1783.14 rows=20514 width=569)
-> Seq Scan on david_93 david_94 (cost=0.00..1705.17 rows=19617 width=569)
-> Seq Scan on david_94 david_95 (cost=0.00..1817.04 rows=20904 width=569)
-> Seq Scan on david_95 david_96 (cost=0.00..1977.50 rows=22750 width=569)
-> Seq Scan on david_96 david_97 (cost=0.00..1946.99 rows=22399 width=569)
-> Seq Scan on david_97 david_98 (cost=0.00..1814.78 rows=20878 width=569)
-> Seq Scan on david_98 david_99 (cost=0.00..1844.16 rows=21216 width=569)
-> Seq Scan on david_99 david_100 (cost=0.00..1769.58 rows=20358 width=569)
-> Hash (cost=147650973.90..147650973.90 rows=1653953593 width=18)
-> Append (cost=0.00..147650973.90 rows=1653953593 width=18)
-> Seq Scan on goliath_0 ca_1 (cost=0.00..11177255.56 rows=150300456 width=18)
-> Seq Scan on goliath_1 ca_2 (cost=0.00..1234238.22 rows=14780522 width=18)
-> Seq Scan on goliath_2 ca_3 (cost=0.00..1323160.42 rows=15336142 width=18)
-> Seq Scan on goliath_3 ca_4 (cost=0.00..1256666.46 rows=15029146 width=18)
-> Seq Scan on goliath_4 ca_5 (cost=0.00..1272324.75 rows=15157175 width=18)
-> Seq Scan on goliath_5 ca_6 (cost=0.00..1270349.37 rows=15044037 width=18)
-> Seq Scan on goliath_6 ca_7 (cost=0.00..1284810.74 rows=15261474 width=18)
-> Seq Scan on goliath_7 ca_8 (cost=0.00..1263715.41 rows=15020741 width=18)
-> Seq Scan on goliath_8 ca_9 (cost=0.00..1265121.73 rows=14953673 width=18)
-> Seq Scan on goliath_9 ca_10 (cost=0.00..1309331.70 rows=15314570 width=18)
-> Seq Scan on goliath_10 ca_11 (cost=0.00..1269041.02 rows=15086702 width=18)
-> Seq Scan on goliath_11 ca_12 (cost=0.00..1268299.98 rows=15042498 width=18)
-> Seq Scan on goliath_12 ca_13 (cost=0.00..1294069.08 rows=15206708 width=18)
-> Seq Scan on goliath_13 ca_14 (cost=0.00..1344155.97 rows=15480897 width=18)
-> Seq Scan on goliath_14 ca_15 (cost=0.00..1258529.41 rows=15007641 width=18)
-> Seq Scan on goliath_15 ca_16 (cost=0.00..1247612.99 rows=14801699 width=18)
-> Seq Scan on goliath_16 ca_17 (cost=0.00..1398973.15 rows=15833115 width=18)
-> Seq Scan on goliath_17 ca_18 (cost=0.00..1234430.89 rows=14907189 width=18)
-> Seq Scan on goliath_18 ca_19 (cost=0.00..1491068.89 rows=16395989 width=18)
-> Seq Scan on goliath_19 ca_20 (cost=0.00..1241254.74 rows=14743874 width=18)
-> Seq Scan on goliath_20 ca_21 (cost=0.00..1308537.31 rows=15139031 width=18)
-> Seq Scan on goliath_21 ca_22 (cost=0.00..1274257.03 rows=15133903 width=18)
-> Seq Scan on goliath_22 ca_23 (cost=0.00..1348582.00 rows=15415900 width=18)
-> Seq Scan on goliath_23 ca_24 (cost=0.00..1245613.99 rows=14770499 width=18)
-> Seq Scan on goliath_24 ca_25 (cost=0.00..1232552.90 rows=14592890 width=18)
-> Seq Scan on goliath_25 ca_26 (cost=0.00..1237272.86 rows=14785186 width=18)
-> Seq Scan on goliath_26 ca_27 (cost=0.00..1395925.80 rows=15794380 width=18)
-> Seq Scan on goliath_27 ca_28 (cost=0.00..1243112.59 rows=14888659 width=18)
-> Seq Scan on goliath_28 ca_29 (cost=0.00..1261176.05 rows=15014705 width=18)
-> Seq Scan on goliath_29 ca_30 (cost=0.00..1375287.81 rows=15912981 width=18)
-> Seq Scan on goliath_30 ca_31 (cost=0.00..1236320.19 rows=14789519 width=18)
-> Seq Scan on goliath_31 ca_32 (cost=0.00..1278375.97 rows=15203897 width=18)
-> Seq Scan on goliath_32 ca_33 (cost=0.00..1263550.43 rows=14860643 width=18)
-> Seq Scan on goliath_33 ca_34 (cost=0.00..1299830.39 rows=15186239 width=18)
-> Seq Scan on goliath_34 ca_35 (cost=0.00..1352761.61 rows=15664361 width=18)
-> Seq Scan on goliath_35 ca_36 (cost=0.00..1323724.61 rows=15543061 width=18)
-> Seq Scan on goliath_36 ca_37 (cost=0.00..1508080.05 rows=16098705 width=18)
-> Seq Scan on goliath_37 ca_38 (cost=0.00..1247180.20 rows=15092220 width=18)
-> Seq Scan on goliath_38 ca_39 (cost=0.00..1265121.63 rows=14913063 width=18)
-> Seq Scan on goliath_39 ca_40 (cost=0.00..1263161.74 rows=15008274 width=18)
-> Seq Scan on goliath_40 ca_41 (cost=0.00..1422028.56 rows=15874056 width=18)
-> Seq Scan on goliath_41 ca_42 (cost=0.00..1276259.24 rows=15052824 width=18)
-> Seq Scan on goliath_42 ca_43 (cost=0.00..1331700.23 rows=15499623 width=18)
-> Seq Scan on goliath_43 ca_44 (cost=0.00..1246053.10 rows=14665010 width=18)
-> Seq Scan on goliath_44 ca_45 (cost=0.00..1275255.85 rows=15143785 width=18)
-> Seq Scan on goliath_45 ca_46 (cost=0.00..1305362.83 rows=15361783 width=18)
-> Seq Scan on goliath_46 ca_47 (cost=0.00..1280577.37 rows=15247837 width=18)
-> Seq Scan on goliath_47 ca_48 (cost=0.00..1251285.15 rows=14806015 width=18)
-> Seq Scan on goliath_48 ca_49 (cost=0.00..1351232.48 rows=15433548 width=18)
-> Seq Scan on goliath_49 ca_50 (cost=0.00..1347924.50 rows=15296550 width=18)
-> Seq Scan on goliath_50 ca_51 (cost=0.00..1357086.54 rows=15541854 width=18)
-> Seq Scan on goliath_51 ca_52 (cost=0.00..1216370.11 rows=14562711 width=18)
-> Seq Scan on goliath_52 ca_53 (cost=0.00..1358864.91 rows=15543891 width=18)
-> Seq Scan on goliath_53 ca_54 (cost=0.00..1303103.21 rows=15233521 width=18)
-> Seq Scan on goliath_54 ca_55 (cost=0.00..1247450.04 rows=14984504 width=18)
-> Seq Scan on goliath_55 ca_56 (cost=0.00..1265316.35 rows=14879835 width=18)
-> Seq Scan on goliath_56 ca_57 (cost=0.00..1256864.72 rows=14942272 width=18)
-> Seq Scan on goliath_57 ca_58 (cost=0.00..1234443.50 rows=14857950 width=18)
-> Seq Scan on goliath_58 ca_59 (cost=0.00..1293245.96 rows=15297596 width=18)
-> Seq Scan on goliath_59 ca_60 (cost=0.00..1234137.56 rows=14820356 width=18)
-> Seq Scan on goliath_60 ca_61 (cost=0.00..1561333.77 rows=16903277 width=18)
-> Seq Scan on goliath_61 ca_62 (cost=0.00..1289386.58 rows=15273158 width=18)
-> Seq Scan on goliath_62 ca_63 (cost=0.00..1375996.18 rows=15783618 width=18)
-> Seq Scan on goliath_63 ca_64 (cost=0.00..1318835.42 rows=15393842 width=18)
-> Seq Scan on goliath_64 ca_65 (cost=0.00..1279811.42 rows=15025442 width=18)
-> Seq Scan on goliath_65 ca_66 (cost=0.00..1238623.43 rows=14795243 width=18)
-> Seq Scan on goliath_66 ca_67 (cost=0.00..1305470.50 rows=15230950 width=18)
-> Seq Scan on goliath_67 ca_68 (cost=0.00..1261104.19 rows=14894319 width=18)
-> Seq Scan on goliath_68 ca_69 (cost=0.00..1283365.18 rows=15239718 width=18)
-> Seq Scan on goliath_69 ca_70 (cost=0.00..1314101.63 rows=15292263 width=18)
-> Seq Scan on goliath_70 ca_71 (cost=0.00..1253906.46 rows=14978446 width=18)
-> Seq Scan on goliath_71 ca_72 (cost=0.00..1294493.71 rows=15331171 width=18)
-> Seq Scan on goliath_72 ca_73 (cost=0.00..1286198.09 rows=15418009 width=18)
-> Seq Scan on goliath_73 ca_74 (cost=0.00..1289391.43 rows=15229243 width=18)
-> Seq Scan on goliath_74 ca_75 (cost=0.00..1242385.13 rows=14670113 width=18)
-> Seq Scan on goliath_75 ca_76 (cost=0.00..1263916.51 rows=14982751 width=18)
-> Seq Scan on goliath_76 ca_77 (cost=0.00..1294899.69 rows=15200869 width=18)
-> Seq Scan on goliath_77 ca_78 (cost=0.00..1269406.36 rows=14930436 width=18)
-> Seq Scan on goliath_78 ca_79 (cost=0.00..1235383.65 rows=14800365 width=18)
-> Seq Scan on goliath_79 ca_80 (cost=0.00..1236916.73 rows=14710273 width=18)
-> Seq Scan on goliath_80 ca_81 (cost=0.00..1421834.11 rows=16753911 width=18)
-> Seq Scan on goliath_81 ca_82 (cost=0.00..1335250.54 rows=15351354 width=18)
-> Seq Scan on goliath_82 ca_83 (cost=0.00..1243153.05 rows=14688205 width=18)
-> Seq Scan on goliath_83 ca_84 (cost=0.00..1250345.33 rows=14741833 width=18)
-> Seq Scan on goliath_84 ca_85 (cost=0.00..1301004.00 rows=14956400 width=18)
-> Seq Scan on goliath_85 ca_86 (cost=0.00..1289135.50 rows=15009950 width=18)
-> Seq Scan on goliath_86 ca_87 (cost=0.00..1488060.65 rows=16380865 width=18)
-> Seq Scan on goliath_87 ca_88 (cost=0.00..1265255.27 rows=15004127 width=18)
-> Seq Scan on goliath_88 ca_89 (cost=0.00..1291141.46 rows=15112446 width=18)
-> Seq Scan on goliath_89 ca_90 (cost=0.00..1236365.37 rows=14733237 width=18)
-> Seq Scan on goliath_90 ca_91 (cost=0.00..1276548.94 rows=14938294 width=18)
-> Seq Scan on goliath_91 ca_92 (cost=0.00..1375334.48 rows=16060648 width=18)
-> Seq Scan on goliath_92 ca_93 (cost=0.00..1257210.14 rows=14934014 width=18)
-> Seq Scan on goliath_93 ca_94 (cost=0.00..1268048.19 rows=14998419 width=18)
-> Seq Scan on goliath_94 ca_95 (cost=0.00..1277075.92 rows=15219292 width=18)
-> Seq Scan on goliath_95 ca_96 (cost=0.00..1351108.41 rows=15454141 width=18)
-> Seq Scan on goliath_96 ca_97 (cost=0.00..1283608.49 rows=15091049 width=18)
-> Seq Scan on goliath_97 ca_98 (cost=0.00..1277019.32 rows=15265132 width=18)
-> Seq Scan on goliath_98 ca_99 (cost=0.00..1258056.96 rows=15006496 width=18)
-> Seq Scan on goliath_99 ca_100 (cost=0.00..1221325.89 rows=14612389 width=18)
