drop table if exists bigcol; drop table if exists somecol; drop table if exists manycol; drop table if exists insane; create table bigcol as select lpad('a', 1024, 'a')::text as txt from generate_series(1,100000); create table somecol as select 'aaaaaaaaaaaaaaaaaaaaaa'::text as txt, 1 as a, 'oaiudyvoaisuyvoaisvosaivhuaosivhoasivd'::text as b, 3 as c, 'zzzzzzzzzzzzzzzzzzasdasdada23452532'::text as txt2 from generate_series(1,1000000); create table manycol as select 0 as c0, 1 as c1, 2 as c2, 3 as c3, 4 as c4, 5 as c5, 6 as c6, 7 as c7, 8 as c8, 9 as c9, 10 as c10, 11 as c11, 12 as c12, 13 as c13, 14 as c14, 15 as c15, 16 as c16, 17 as c17, 18 as c18, 19 as c19, 20 as c20, 21 as c21, 22 as c22, 23 as c23, 24 as c24, 25 as c25, 26 as c26, 27 as c27, 28 as c28, 29 as c29, 30 as c30, 31 as c31, 32 as c32, 33 as c33, 34 as c34, 35 as c35, 36 as c36, 37 as c37, 38 as c38, 39 as c39 from generate_series(1,1000000); create table insane as select 1 as c000001, 2 as c000002, 3 as c000003, 4 as c000004, 5 as c000005, 6 as c000006, 7 as c000007, 8 as c000008, 9 as c000009, 10 as c000010, 11 as c000011, 12 as c000012, 13 as c000013, 14 as c000014, 15 as c000015, 16 as c000016, 17 as c000017, 18 as c000018, 19 as c000019, 20 as c000020, 21 as c000021, 22 as c000022, 23 as c000023, 24 as c000024, 25 as c000025, 26 as c000026, 27 as c000027, 28 as c000028, 29 as c000029, 30 as c000030, 31 as c000031, 32 as c000032, 33 as c000033, 34 as c000034, 35 as c000035, 36 as c000036, 37 as c000037, 38 as c000038, 39 as c000039, 40 as c000040, 41 as c000041, 42 as c000042, 43 as c000043, 44 as c000044, 45 as c000045, 46 as c000046, 47 as c000047, 48 as c000048, 49 as c000049, 50 as c000050, 51 as c000051, 52 as c000052, 53 as c000053, 54 as c000054, 55 as c000055, 56 as c000056, 57 as c000057, 58 as c000058, 59 as c000059, 60 as c000060, 61 as c000061, 62 as c000062, 63 as c000063, 64 as c000064, 65 as c000065, 66 as c000066, 67 as c000067, 68 as c000068, 69 as c000069, 70 as c000070, 71 as c000071, 72 as c000072, 73 as c000073, 74 as c000074, 75 as c000075, 76 as c000076, 77 as c000077, 78 as c000078, 79 as c000079, 80 as c000080, 81 as c000081, 82 as c000082, 83 as c000083, 84 as c000084, 85 as c000085, 86 as c000086, 87 as c000087, 88 as c000088, 89 as c000089, 90 as c000090, 91 as c000091, 92 as c000092, 93 as c000093, 94 as c000094, 95 as c000095, 96 as c000096, 97 as c000097, 98 as c000098, 99 as c000099, 100 as c000100, 101 as c000101, 102 as c000102, 103 as c000103, 104 as c000104, 105 as c000105, 106 as c000106, 107 as c000107, 108 as c000108, 109 as c000109, 110 as c000110, 111 as c000111, 112 as c000112, 113 as c000113, 114 as c000114, 115 as c000115, 116 as c000116, 117 as c000117, 118 as c000118, 119 as c000119, 120 as c000120, 121 as c000121, 122 as c000122, 123 as c000123, 124 as c000124, 125 as c000125, 126 as c000126, 127 as c000127, 128 as c000128, 129 as c000129, 130 as c000130, 131 as c000131, 132 as c000132, 133 as c000133, 134 as c000134, 135 as c000135, 136 as c000136, 137 as c000137, 138 as c000138, 139 as c000139, 140 as c000140, 141 as c000141, 142 as c000142, 143 as c000143, 144 as c000144, 145 as c000145, 146 as c000146, 147 as c000147, 148 as c000148, 149 as c000149, 150 as c000150, 151 as c000151, 152 as c000152, 153 as c000153, 154 as c000154, 155 as c000155, 156 as c000156, 157 as c000157, 158 as c000158, 159 as c000159, 160 as c000160, 161 as c000161, 162 as c000162, 163 as c000163, 164 as c000164, 165 as c000165, 166 as c000166, 167 as c000167, 168 as c000168, 169 as c000169, 170 as c000170, 171 as c000171, 172 as c000172, 173 as c000173, 174 as c000174, 175 as c000175, 176 as c000176, 177 as c000177, 178 as c000178, 179 as c000179, 180 as c000180, 181 as c000181, 182 as c000182, 183 as c000183, 184 as c000184, 185 as c000185, 186 as c000186, 187 as c000187, 188 as c000188, 189 as c000189, 190 as c000190, 191 as c000191, 192 as c000192, 193 as c000193, 194 as c000194, 195 as c000195, 196 as c000196, 197 as c000197, 198 as c000198, 199 as c000199, 200 as c000200, 201 as c000201, 202 as c000202, 203 as c000203, 204 as c000204, 205 as c000205, 206 as c000206, 207 as c000207, 208 as c000208, 209 as c000209, 210 as c000210, 211 as c000211, 212 as c000212, 213 as c000213, 214 as c000214, 215 as c000215, 216 as c000216, 217 as c000217, 218 as c000218, 219 as c000219, 220 as c000220, 221 as c000221, 222 as c000222, 223 as c000223, 224 as c000224, 225 as c000225, 226 as c000226, 227 as c000227, 228 as c000228, 229 as c000229, 230 as c000230, 231 as c000231, 232 as c000232, 233 as c000233, 234 as c000234, 235 as c000235, 236 as c000236, 237 as c000237, 238 as c000238, 239 as c000239, 240 as c000240, 241 as c000241, 242 as c000242, 243 as c000243, 244 as c000244, 245 as c000245, 246 as c000246, 247 as c000247, 248 as c000248, 249 as c000249, 250 as c000250, 251 as c000251, 252 as c000252, 253 as c000253, 254 as c000254, 255 as c000255, 256 as c000256, 257 as c000257, 258 as c000258, 259 as c000259, 260 as c000260, 261 as c000261, 262 as c000262, 263 as c000263, 264 as c000264, 265 as c000265, 266 as c000266, 267 as c000267, 268 as c000268, 269 as c000269, 270 as c000270, 271 as c000271, 272 as c000272, 273 as c000273, 274 as c000274, 275 as c000275, 276 as c000276, 277 as c000277, 278 as c000278, 279 as c000279, 280 as c000280, 281 as c000281, 282 as c000282, 283 as c000283, 284 as c000284, 285 as c000285, 286 as c000286, 287 as c000287, 288 as c000288, 289 as c000289, 290 as c000290, 291 as c000291, 292 as c000292, 293 as c000293, 294 as c000294, 295 as c000295, 296 as c000296, 297 as c000297, 298 as c000298, 299 as c000299, 300 as c000300, 301 as c000301, 302 as c000302, 303 as c000303, 304 as c000304, 305 as c000305, 306 as c000306, 307 as c000307, 308 as c000308, 309 as c000309, 310 as c000310, 311 as c000311, 312 as c000312, 313 as c000313, 314 as c000314, 315 as c000315, 316 as c000316, 317 as c000317, 318 as c000318, 319 as c000319, 320 as c000320, 321 as c000321, 322 as c000322, 323 as c000323, 324 as c000324, 325 as c000325, 326 as c000326, 327 as c000327, 328 as c000328, 329 as c000329, 330 as c000330, 331 as c000331, 332 as c000332, 333 as c000333, 334 as c000334, 335 as c000335, 336 as c000336, 337 as c000337, 338 as c000338, 339 as c000339, 340 as c000340, 341 as c000341, 342 as c000342, 343 as c000343, 344 as c000344, 345 as c000345, 346 as c000346, 347 as c000347, 348 as c000348, 349 as c000349, 350 as c000350, 351 as c000351, 352 as c000352, 353 as c000353, 354 as c000354, 355 as c000355, 356 as c000356, 357 as c000357, 358 as c000358, 359 as c000359, 360 as c000360, 361 as c000361, 362 as c000362, 363 as c000363, 364 as c000364, 365 as c000365, 366 as c000366, 367 as c000367, 368 as c000368, 369 as c000369, 370 as c000370, 371 as c000371, 372 as c000372, 373 as c000373, 374 as c000374, 375 as c000375, 376 as c000376, 377 as c000377, 378 as c000378, 379 as c000379, 380 as c000380, 381 as c000381, 382 as c000382, 383 as c000383, 384 as c000384, 385 as c000385, 386 as c000386, 387 as c000387, 388 as c000388, 389 as c000389, 390 as c000390, 391 as c000391, 392 as c000392, 393 as c000393, 394 as c000394, 395 as c000395, 396 as c000396, 397 as c000397, 398 as c000398, 399 as c000399, 400 as c000400, 401 as c000401, 402 as c000402, 403 as c000403, 404 as c000404, 405 as c000405, 406 as c000406, 407 as c000407, 408 as c000408, 409 as c000409, 410 as c000410, 411 as c000411, 412 as c000412, 413 as c000413, 414 as c000414, 415 as c000415, 416 as c000416, 417 as c000417, 418 as c000418, 419 as c000419, 420 as c000420, 421 as c000421, 422 as c000422, 423 as c000423, 424 as c000424, 425 as c000425, 426 as c000426, 427 as c000427, 428 as c000428, 429 as c000429, 430 as c000430, 431 as c000431, 432 as c000432, 433 as c000433, 434 as c000434, 435 as c000435, 436 as c000436, 437 as c000437, 438 as c000438, 439 as c000439, 440 as c000440, 441 as c000441, 442 as c000442, 443 as c000443, 444 as c000444, 445 as c000445, 446 as c000446, 447 as c000447, 448 as c000448, 449 as c000449, 450 as c000450, 451 as c000451, 452 as c000452, 453 as c000453, 454 as c000454, 455 as c000455, 456 as c000456, 457 as c000457, 458 as c000458, 459 as c000459, 460 as c000460, 461 as c000461, 462 as c000462, 463 as c000463, 464 as c000464, 465 as c000465, 466 as c000466, 467 as c000467, 468 as c000468, 469 as c000469, 470 as c000470, 471 as c000471, 472 as c000472, 473 as c000473, 474 as c000474, 475 as c000475, 476 as c000476, 477 as c000477, 478 as c000478, 479 as c000479, 480 as c000480, 481 as c000481, 482 as c000482, 483 as c000483, 484 as c000484, 485 as c000485, 486 as c000486, 487 as c000487, 488 as c000488, 489 as c000489, 490 as c000490, 491 as c000491, 492 as c000492, 493 as c000493, 494 as c000494, 495 as c000495, 496 as c000496, 497 as c000497, 498 as c000498, 499 as c000499, 500 as c000500, 501 as c000501, 502 as c000502, 503 as c000503, 504 as c000504, 505 as c000505, 506 as c000506, 507 as c000507, 508 as c000508, 509 as c000509, 510 as c000510, 511 as c000511, 512 as c000512, 513 as c000513, 514 as c000514, 515 as c000515, 516 as c000516, 517 as c000517, 518 as c000518, 519 as c000519, 520 as c000520, 521 as c000521, 522 as c000522, 523 as c000523, 524 as c000524, 525 as c000525, 526 as c000526, 527 as c000527, 528 as c000528, 529 as c000529, 530 as c000530, 531 as c000531, 532 as c000532, 533 as c000533, 534 as c000534, 535 as c000535, 536 as c000536, 537 as c000537, 538 as c000538, 539 as c000539, 540 as c000540, 541 as c000541, 542 as c000542, 543 as c000543, 544 as c000544, 545 as c000545, 546 as c000546, 547 as c000547, 548 as c000548, 549 as c000549, 550 as c000550, 551 as c000551, 552 as c000552, 553 as c000553, 554 as c000554, 555 as c000555, 556 as c000556, 557 as c000557, 558 as c000558, 559 as c000559, 560 as c000560, 561 as c000561, 562 as c000562, 563 as c000563, 564 as c000564, 565 as c000565, 566 as c000566, 567 as c000567, 568 as c000568, 569 as c000569, 570 as c000570, 571 as c000571, 572 as c000572, 573 as c000573, 574 as c000574, 575 as c000575, 576 as c000576, 577 as c000577, 578 as c000578, 579 as c000579, 580 as c000580, 581 as c000581, 582 as c000582, 583 as c000583, 584 as c000584, 585 as c000585, 586 as c000586, 587 as c000587, 588 as c000588, 589 as c000589, 590 as c000590, 591 as c000591, 592 as c000592, 593 as c000593, 594 as c000594, 595 as c000595, 596 as c000596, 597 as c000597, 598 as c000598, 599 as c000599, 600 as c000600, 601 as c000601, 602 as c000602, 603 as c000603, 604 as c000604, 605 as c000605, 606 as c000606, 607 as c000607, 608 as c000608, 609 as c000609, 610 as c000610, 611 as c000611, 612 as c000612, 613 as c000613, 614 as c000614, 615 as c000615, 616 as c000616, 617 as c000617, 618 as c000618, 619 as c000619, 620 as c000620, 621 as c000621, 622 as c000622, 623 as c000623, 624 as c000624, 625 as c000625, 626 as c000626, 627 as c000627, 628 as c000628, 629 as c000629, 630 as c000630, 631 as c000631, 632 as c000632, 633 as c000633, 634 as c000634, 635 as c000635, 636 as c000636, 637 as c000637, 638 as c000638, 639 as c000639, 640 as c000640, 641 as c000641, 642 as c000642, 643 as c000643, 644 as c000644, 645 as c000645, 646 as c000646, 647 as c000647, 648 as c000648, 649 as c000649, 650 as c000650, 651 as c000651, 652 as c000652, 653 as c000653, 654 as c000654, 655 as c000655, 656 as c000656, 657 as c000657, 658 as c000658, 659 as c000659, 660 as c000660, 661 as c000661, 662 as c000662, 663 as c000663, 664 as c000664, 665 as c000665, 666 as c000666, 667 as c000667, 668 as c000668, 669 as c000669, 670 as c000670, 671 as c000671, 672 as c000672, 673 as c000673, 674 as c000674, 675 as c000675, 676 as c000676, 677 as c000677, 678 as c000678, 679 as c000679, 680 as c000680, 681 as c000681, 682 as c000682, 683 as c000683, 684 as c000684, 685 as c000685, 686 as c000686, 687 as c000687, 688 as c000688, 689 as c000689, 690 as c000690, 691 as c000691, 692 as c000692, 693 as c000693, 694 as c000694, 695 as c000695, 696 as c000696, 697 as c000697, 698 as c000698, 699 as c000699, 700 as c000700, 701 as c000701, 702 as c000702, 703 as c000703, 704 as c000704, 705 as c000705, 706 as c000706, 707 as c000707, 708 as c000708, 709 as c000709, 710 as c000710, 711 as c000711, 712 as c000712, 713 as c000713, 714 as c000714, 715 as c000715, 716 as c000716, 717 as c000717, 718 as c000718, 719 as c000719, 720 as c000720, 721 as c000721, 722 as c000722, 723 as c000723, 724 as c000724, 725 as c000725, 726 as c000726, 727 as c000727, 728 as c000728, 729 as c000729, 730 as c000730, 731 as c000731, 732 as c000732, 733 as c000733, 734 as c000734, 735 as c000735, 736 as c000736, 737 as c000737, 738 as c000738, 739 as c000739, 740 as c000740, 741 as c000741, 742 as c000742, 743 as c000743, 744 as c000744, 745 as c000745, 746 as c000746, 747 as c000747, 748 as c000748, 749 as c000749, 750 as c000750, 751 as c000751, 752 as c000752, 753 as c000753, 754 as c000754, 755 as c000755, 756 as c000756, 757 as c000757, 758 as c000758, 759 as c000759, 760 as c000760, 761 as c000761, 762 as c000762, 763 as c000763, 764 as c000764, 765 as c000765, 766 as c000766, 767 as c000767, 768 as c000768, 769 as c000769, 770 as c000770, 771 as c000771, 772 as c000772, 773 as c000773, 774 as c000774, 775 as c000775, 776 as c000776, 777 as c000777, 778 as c000778, 779 as c000779, 780 as c000780, 781 as c000781, 782 as c000782, 783 as c000783, 784 as c000784, 785 as c000785, 786 as c000786, 787 as c000787, 788 as c000788, 789 as c000789, 790 as c000790, 791 as c000791, 792 as c000792, 793 as c000793, 794 as c000794, 795 as c000795, 796 as c000796, 797 as c000797, 798 as c000798, 799 as c000799, 800 as c000800, 801 as c000801, 802 as c000802, 803 as c000803, 804 as c000804, 805 as c000805, 806 as c000806, 807 as c000807, 808 as c000808, 809 as c000809, 810 as c000810, 811 as c000811, 812 as c000812, 813 as c000813, 814 as c000814, 815 as c000815, 816 as c000816, 817 as c000817, 818 as c000818, 819 as c000819, 820 as c000820, 821 as c000821, 822 as c000822, 823 as c000823, 824 as c000824, 825 as c000825, 826 as c000826, 827 as c000827, 828 as c000828, 829 as c000829, 830 as c000830, 831 as c000831, 832 as c000832, 833 as c000833, 834 as c000834, 835 as c000835, 836 as c000836, 837 as c000837, 838 as c000838, 839 as c000839, 840 as c000840, 841 as c000841, 842 as c000842, 843 as c000843, 844 as c000844, 845 as c000845, 846 as c000846, 847 as c000847, 848 as c000848, 849 as c000849, 850 as c000850, 851 as c000851, 852 as c000852, 853 as c000853, 854 as c000854, 855 as c000855, 856 as c000856, 857 as c000857, 858 as c000858, 859 as c000859, 860 as c000860, 861 as c000861, 862 as c000862, 863 as c000863, 864 as c000864, 865 as c000865, 866 as c000866, 867 as c000867, 868 as c000868, 869 as c000869, 870 as c000870, 871 as c000871, 872 as c000872, 873 as c000873, 874 as c000874, 875 as c000875, 876 as c000876, 877 as c000877, 878 as c000878, 879 as c000879, 880 as c000880, 881 as c000881, 882 as c000882, 883 as c000883, 884 as c000884, 885 as c000885, 886 as c000886, 887 as c000887, 888 as c000888, 889 as c000889, 890 as c000890, 891 as c000891, 892 as c000892, 893 as c000893, 894 as c000894, 895 as c000895, 896 as c000896, 897 as c000897, 898 as c000898, 899 as c000899, 900 as c000900, 901 as c000901, 902 as c000902, 903 as c000903, 904 as c000904, 905 as c000905, 906 as c000906, 907 as c000907, 908 as c000908, 909 as c000909, 910 as c000910, 911 as c000911, 912 as c000912, 913 as c000913, 914 as c000914, 915 as c000915, 916 as c000916, 917 as c000917, 918 as c000918, 919 as c000919, 920 as c000920, 921 as c000921, 922 as c000922, 923 as c000923, 924 as c000924, 925 as c000925, 926 as c000926, 927 as c000927, 928 as c000928, 929 as c000929, 930 as c000930, 931 as c000931, 932 as c000932, 933 as c000933, 934 as c000934, 935 as c000935, 936 as c000936, 937 as c000937, 938 as c000938, 939 as c000939, 940 as c000940, 941 as c000941, 942 as c000942, 943 as c000943, 944 as c000944, 945 as c000945, 946 as c000946, 947 as c000947, 948 as c000948, 949 as c000949, 950 as c000950, 951 as c000951, 952 as c000952, 953 as c000953, 954 as c000954, 955 as c000955, 956 as c000956, 957 as c000957, 958 as c000958, 959 as c000959, 960 as c000960, 961 as c000961, 962 as c000962, 963 as c000963, 964 as c000964, 965 as c000965, 966 as c000966, 967 as c000967, 968 as c000968, 969 as c000969, 970 as c000970, 971 as c000971, 972 as c000972, 973 as c000973, 974 as c000974, 975 as c000975, 976 as c000976, 977 as c000977, 978 as c000978, 979 as c000979, 980 as c000980, 981 as c000981, 982 as c000982, 983 as c000983, 984 as c000984, 985 as c000985, 986 as c000986, 987 as c000987, 988 as c000988, 989 as c000989, 990 as c000990, 991 as c000991, 992 as c000992, 993 as c000993, 994 as c000994, 995 as c000995, 996 as c000996, 997 as c000997, 998 as c000998, 999 as c000999, 1000 as c001000, 1001 as c001001, 1002 as c001002, 1003 as c001003, 1004 as c001004, 1005 as c001005, 1006 as c001006, 1007 as c001007, 1008 as c001008, 1009 as c001009, 1010 as c001010, 1011 as c001011, 1012 as c001012, 1013 as c001013, 1014 as c001014, 1015 as c001015, 1016 as c001016, 1017 as c001017, 1018 as c001018, 1019 as c001019, 1020 as c001020, 1021 as c001021, 1022 as c001022, 1023 as c001023, 1024 as c001024, x as id from generate_series(1,100000) x; analyze;