github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join3.ref.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 SELECT 6 NULL 7 AS table_cat, 8 n.nspname 9 AS table_schem, 10 ct.relname 11 AS table_name, 12 NOT 13 i.indisunique 14 AS non_unique, 15 NULL 16 AS index_qualifier, 17 ci.relname 18 AS index_name, 19 CASE i.indisclustered 20 WHEN true 21 THEN 1 22 ELSE CASE am.amname 23 WHEN 'hash' 24 THEN 2 25 ELSE 3 26 END 27 END 28 AS type, 29 (i.keys).n 30 AS ordinal_position, 31 btrim( 32 pg_catalog.pg_get_indexdef( 33 ci.oid, 34 (i.keys).n, 35 false 36 ), 37 '"' 38 ) 39 AS column_name, 40 CASE am.amcanorder 41 WHEN true 42 THEN CASE i.indoption[(i.keys).n - 1] 43 & 1 44 WHEN 1 45 THEN 'D' 46 ELSE 'A' 47 END 48 ELSE NULL 49 END 50 AS asc_or_desc, 51 ci.reltuples 52 AS cardinality, 53 ci.relpages 54 AS pages, 55 pg_catalog.pg_get_expr( 56 i.indpred, 57 i.indrelid 58 ) 59 AS filter_condition 60 FROM 61 pg_catalog.pg_class 62 AS ct 63 JOIN pg_catalog.pg_namespace 64 AS n ON 65 ct.relnamespace 66 = n.oid 67 JOIN ( 68 SELECT 69 i.indexrelid, 70 i.indrelid, 71 i.indoption, 72 i.indisunique, 73 i.indisclustered, 74 i.indpred, 75 i.indexprs, 76 information_schema._pg_expandarray( 77 i.indkey 78 ) 79 AS keys 80 FROM 81 pg_catalog.pg_index 82 AS i 83 ) 84 AS i ON 85 ct.oid 86 = i.indrelid 87 JOIN pg_catalog.pg_class 88 AS ci ON 89 ci.oid 90 = i.indexrelid 91 JOIN pg_catalog.pg_am 92 AS am ON 93 ci.relam 94 = am.oid 95 WHERE 96 true 97 AND n.nspname 98 = 'public' 99 AND ct.relname 100 = 'j' 101 ORDER BY 102 non_unique, 103 type, 104 index_name, 105 ordinal_position 106 107 19: 108 ------------------- 109 SELECT 110 NULL 111 AS table_cat, 112 n.nspname 113 AS table_schem, 114 ct.relname 115 AS table_name, 116 NOT 117 i.indisunique 118 AS non_unique, 119 NULL 120 AS index_qualifier, 121 ci.relname 122 AS index_name, 123 CASE i.indisclustered 124 WHEN true 125 THEN 1 126 ELSE CASE am.amname 127 WHEN 'hash' 128 THEN 2 129 ELSE 3 130 END 131 END 132 AS type, 133 (i.keys).n 134 AS ordinal_position, 135 btrim( 136 pg_catalog.pg_get_indexdef( 137 ci.oid, 138 (i.keys).n, 139 false 140 ), 141 '"' 142 ) 143 AS column_name, 144 CASE am.amcanorder 145 WHEN true 146 THEN CASE i.indoption[(i.keys).n - 1] 147 & 1 148 WHEN 1 THEN 'D' 149 ELSE 'A' 150 END 151 ELSE NULL 152 END 153 AS asc_or_desc, 154 ci.reltuples 155 AS cardinality, 156 ci.relpages 157 AS pages, 158 pg_catalog.pg_get_expr( 159 i.indpred, 160 i.indrelid 161 ) 162 AS filter_condition 163 FROM 164 pg_catalog.pg_class 165 AS ct 166 JOIN pg_catalog.pg_namespace 167 AS n ON 168 ct.relnamespace 169 = n.oid 170 JOIN ( 171 SELECT 172 i.indexrelid, 173 i.indrelid, 174 i.indoption, 175 i.indisunique, 176 i.indisclustered, 177 i.indpred, 178 i.indexprs, 179 information_schema._pg_expandarray( 180 i.indkey 181 ) 182 AS keys 183 FROM 184 pg_catalog.pg_index 185 AS i 186 ) 187 AS i ON 188 ct.oid 189 = i.indrelid 190 JOIN pg_catalog.pg_class 191 AS ci ON 192 ci.oid 193 = i.indexrelid 194 JOIN pg_catalog.pg_am 195 AS am ON 196 ci.relam 197 = am.oid 198 WHERE 199 true 200 AND n.nspname 201 = 'public' 202 AND ct.relname 203 = 'j' 204 ORDER BY 205 non_unique, 206 type, 207 index_name, 208 ordinal_position 209 210 20: 211 -------------------- 212 SELECT 213 NULL 214 AS table_cat, 215 n.nspname 216 AS table_schem, 217 ct.relname 218 AS table_name, 219 NOT 220 i.indisunique 221 AS non_unique, 222 NULL 223 AS index_qualifier, 224 ci.relname 225 AS index_name, 226 CASE i.indisclustered 227 WHEN true THEN 1 228 ELSE CASE am.amname 229 WHEN 'hash' 230 THEN 2 231 ELSE 3 232 END 233 END 234 AS type, 235 (i.keys).n 236 AS ordinal_position, 237 btrim( 238 pg_catalog.pg_get_indexdef( 239 ci.oid, 240 (i.keys).n, 241 false 242 ), 243 '"' 244 ) 245 AS column_name, 246 CASE am.amcanorder 247 WHEN true 248 THEN CASE i.indoption[(i.keys).n - 1] 249 & 1 250 WHEN 1 THEN 'D' 251 ELSE 'A' 252 END 253 ELSE NULL 254 END 255 AS asc_or_desc, 256 ci.reltuples 257 AS cardinality, 258 ci.relpages 259 AS pages, 260 pg_catalog.pg_get_expr( 261 i.indpred, 262 i.indrelid 263 ) 264 AS filter_condition 265 FROM 266 pg_catalog.pg_class 267 AS ct 268 JOIN pg_catalog.pg_namespace 269 AS n ON 270 ct.relnamespace 271 = n.oid 272 JOIN ( 273 SELECT 274 i.indexrelid, 275 i.indrelid, 276 i.indoption, 277 i.indisunique, 278 i.indisclustered, 279 i.indpred, 280 i.indexprs, 281 information_schema._pg_expandarray( 282 i.indkey 283 ) 284 AS keys 285 FROM 286 pg_catalog.pg_index 287 AS i 288 ) 289 AS i ON 290 ct.oid 291 = i.indrelid 292 JOIN pg_catalog.pg_class 293 AS ci ON 294 ci.oid 295 = i.indexrelid 296 JOIN pg_catalog.pg_am 297 AS am ON 298 ci.relam 299 = am.oid 300 WHERE 301 true 302 AND n.nspname 303 = 'public' 304 AND ct.relname 305 = 'j' 306 ORDER BY 307 non_unique, 308 type, 309 index_name, 310 ordinal_position 311 312 21: 313 --------------------- 314 SELECT 315 NULL 316 AS table_cat, 317 n.nspname 318 AS table_schem, 319 ct.relname 320 AS table_name, 321 NOT i.indisunique 322 AS non_unique, 323 NULL 324 AS index_qualifier, 325 ci.relname 326 AS index_name, 327 CASE i.indisclustered 328 WHEN true THEN 1 329 ELSE CASE am.amname 330 WHEN 'hash' 331 THEN 2 332 ELSE 3 333 END 334 END 335 AS type, 336 (i.keys).n 337 AS ordinal_position, 338 btrim( 339 pg_catalog.pg_get_indexdef( 340 ci.oid, 341 (i.keys).n, 342 false 343 ), 344 '"' 345 ) 346 AS column_name, 347 CASE am.amcanorder 348 WHEN true 349 THEN CASE i.indoption[(i.keys).n - 1] 350 & 1 351 WHEN 1 THEN 'D' 352 ELSE 'A' 353 END 354 ELSE NULL 355 END 356 AS asc_or_desc, 357 ci.reltuples 358 AS cardinality, 359 ci.relpages 360 AS pages, 361 pg_catalog.pg_get_expr( 362 i.indpred, 363 i.indrelid 364 ) 365 AS filter_condition 366 FROM 367 pg_catalog.pg_class 368 AS ct 369 JOIN pg_catalog.pg_namespace 370 AS n ON 371 ct.relnamespace 372 = n.oid 373 JOIN ( 374 SELECT 375 i.indexrelid, 376 i.indrelid, 377 i.indoption, 378 i.indisunique, 379 i.indisclustered, 380 i.indpred, 381 i.indexprs, 382 information_schema._pg_expandarray( 383 i.indkey 384 ) 385 AS keys 386 FROM 387 pg_catalog.pg_index 388 AS i 389 ) 390 AS i ON 391 ct.oid 392 = i.indrelid 393 JOIN pg_catalog.pg_class 394 AS ci ON 395 ci.oid 396 = i.indexrelid 397 JOIN pg_catalog.pg_am 398 AS am ON 399 ci.relam 400 = am.oid 401 WHERE 402 true 403 AND n.nspname 404 = 'public' 405 AND ct.relname 406 = 'j' 407 ORDER BY 408 non_unique, 409 type, 410 index_name, 411 ordinal_position 412 413 22: 414 ---------------------- 415 SELECT 416 NULL AS table_cat, 417 n.nspname 418 AS table_schem, 419 ct.relname 420 AS table_name, 421 NOT i.indisunique 422 AS non_unique, 423 NULL 424 AS index_qualifier, 425 ci.relname 426 AS index_name, 427 CASE i.indisclustered 428 WHEN true THEN 1 429 ELSE CASE am.amname 430 WHEN 'hash' THEN 2 431 ELSE 3 432 END 433 END 434 AS type, 435 (i.keys).n 436 AS ordinal_position, 437 btrim( 438 pg_catalog.pg_get_indexdef( 439 ci.oid, 440 (i.keys).n, 441 false 442 ), 443 '"' 444 ) 445 AS column_name, 446 CASE am.amcanorder 447 WHEN true 448 THEN CASE i.indoption[(i.keys).n - 1] 449 & 1 450 WHEN 1 THEN 'D' 451 ELSE 'A' 452 END 453 ELSE NULL 454 END 455 AS asc_or_desc, 456 ci.reltuples 457 AS cardinality, 458 ci.relpages 459 AS pages, 460 pg_catalog.pg_get_expr( 461 i.indpred, 462 i.indrelid 463 ) 464 AS filter_condition 465 FROM 466 pg_catalog.pg_class 467 AS ct 468 JOIN pg_catalog.pg_namespace 469 AS n ON 470 ct.relnamespace 471 = n.oid 472 JOIN ( 473 SELECT 474 i.indexrelid, 475 i.indrelid, 476 i.indoption, 477 i.indisunique, 478 i.indisclustered, 479 i.indpred, 480 i.indexprs, 481 information_schema._pg_expandarray( 482 i.indkey 483 ) 484 AS keys 485 FROM 486 pg_catalog.pg_index 487 AS i 488 ) 489 AS i ON 490 ct.oid 491 = i.indrelid 492 JOIN pg_catalog.pg_class 493 AS ci ON 494 ci.oid 495 = i.indexrelid 496 JOIN pg_catalog.pg_am 497 AS am ON 498 ci.relam 499 = am.oid 500 WHERE 501 true 502 AND n.nspname 503 = 'public' 504 AND ct.relname 505 = 'j' 506 ORDER BY 507 non_unique, 508 type, 509 index_name, 510 ordinal_position 511 512 24: 513 ------------------------ 514 SELECT 515 NULL AS table_cat, 516 n.nspname 517 AS table_schem, 518 ct.relname 519 AS table_name, 520 NOT i.indisunique 521 AS non_unique, 522 NULL 523 AS index_qualifier, 524 ci.relname 525 AS index_name, 526 CASE i.indisclustered 527 WHEN true THEN 1 528 ELSE CASE am.amname 529 WHEN 'hash' THEN 2 530 ELSE 3 531 END 532 END 533 AS type, 534 (i.keys).n 535 AS ordinal_position, 536 btrim( 537 pg_catalog.pg_get_indexdef( 538 ci.oid, 539 (i.keys).n, 540 false 541 ), 542 '"' 543 ) 544 AS column_name, 545 CASE am.amcanorder 546 WHEN true 547 THEN CASE i.indoption[(i.keys).n - 1] 548 & 1 549 WHEN 1 THEN 'D' 550 ELSE 'A' 551 END 552 ELSE NULL 553 END 554 AS asc_or_desc, 555 ci.reltuples 556 AS cardinality, 557 ci.relpages 558 AS pages, 559 pg_catalog.pg_get_expr( 560 i.indpred, 561 i.indrelid 562 ) 563 AS filter_condition 564 FROM 565 pg_catalog.pg_class 566 AS ct 567 JOIN pg_catalog.pg_namespace 568 AS n ON 569 ct.relnamespace 570 = n.oid 571 JOIN ( 572 SELECT 573 i.indexrelid, 574 i.indrelid, 575 i.indoption, 576 i.indisunique, 577 i.indisclustered, 578 i.indpred, 579 i.indexprs, 580 information_schema._pg_expandarray( 581 i.indkey 582 ) 583 AS keys 584 FROM 585 pg_catalog.pg_index 586 AS i 587 ) 588 AS i ON 589 ct.oid 590 = i.indrelid 591 JOIN pg_catalog.pg_class 592 AS ci ON 593 ci.oid 594 = i.indexrelid 595 JOIN pg_catalog.pg_am 596 AS am ON 597 ci.relam 598 = am.oid 599 WHERE 600 true 601 AND n.nspname 602 = 'public' 603 AND ct.relname = 'j' 604 ORDER BY 605 non_unique, 606 type, 607 index_name, 608 ordinal_position 609 610 25: 611 ------------------------- 612 SELECT 613 NULL AS table_cat, 614 n.nspname 615 AS table_schem, 616 ct.relname 617 AS table_name, 618 NOT i.indisunique 619 AS non_unique, 620 NULL 621 AS index_qualifier, 622 ci.relname 623 AS index_name, 624 CASE i.indisclustered 625 WHEN true THEN 1 626 ELSE CASE am.amname 627 WHEN 'hash' THEN 2 628 ELSE 3 629 END 630 END 631 AS type, 632 (i.keys).n 633 AS ordinal_position, 634 btrim( 635 pg_catalog.pg_get_indexdef( 636 ci.oid, 637 (i.keys).n, 638 false 639 ), 640 '"' 641 ) 642 AS column_name, 643 CASE am.amcanorder 644 WHEN true 645 THEN CASE i.indoption[(i.keys).n - 1] 646 & 1 647 WHEN 1 THEN 'D' 648 ELSE 'A' 649 END 650 ELSE NULL 651 END 652 AS asc_or_desc, 653 ci.reltuples 654 AS cardinality, 655 ci.relpages AS pages, 656 pg_catalog.pg_get_expr( 657 i.indpred, 658 i.indrelid 659 ) 660 AS filter_condition 661 FROM 662 pg_catalog.pg_class 663 AS ct 664 JOIN pg_catalog.pg_namespace 665 AS n ON 666 ct.relnamespace 667 = n.oid 668 JOIN ( 669 SELECT 670 i.indexrelid, 671 i.indrelid, 672 i.indoption, 673 i.indisunique, 674 i.indisclustered, 675 i.indpred, 676 i.indexprs, 677 information_schema._pg_expandarray( 678 i.indkey 679 ) 680 AS keys 681 FROM 682 pg_catalog.pg_index 683 AS i 684 ) 685 AS i ON 686 ct.oid 687 = i.indrelid 688 JOIN pg_catalog.pg_class 689 AS ci ON 690 ci.oid 691 = i.indexrelid 692 JOIN pg_catalog.pg_am 693 AS am ON 694 ci.relam 695 = am.oid 696 WHERE 697 true 698 AND n.nspname 699 = 'public' 700 AND ct.relname = 'j' 701 ORDER BY 702 non_unique, 703 type, 704 index_name, 705 ordinal_position 706 707 28: 708 ---------------------------- 709 SELECT 710 NULL AS table_cat, 711 n.nspname 712 AS table_schem, 713 ct.relname 714 AS table_name, 715 NOT i.indisunique 716 AS non_unique, 717 NULL AS index_qualifier, 718 ci.relname 719 AS index_name, 720 CASE i.indisclustered 721 WHEN true THEN 1 722 ELSE CASE am.amname 723 WHEN 'hash' THEN 2 724 ELSE 3 725 END 726 END 727 AS type, 728 (i.keys).n 729 AS ordinal_position, 730 btrim( 731 pg_catalog.pg_get_indexdef( 732 ci.oid, 733 (i.keys).n, 734 false 735 ), 736 '"' 737 ) 738 AS column_name, 739 CASE am.amcanorder 740 WHEN true 741 THEN CASE i.indoption[(i.keys).n - 1] 742 & 1 743 WHEN 1 THEN 'D' 744 ELSE 'A' 745 END 746 ELSE NULL 747 END 748 AS asc_or_desc, 749 ci.reltuples 750 AS cardinality, 751 ci.relpages AS pages, 752 pg_catalog.pg_get_expr( 753 i.indpred, 754 i.indrelid 755 ) 756 AS filter_condition 757 FROM 758 pg_catalog.pg_class 759 AS ct 760 JOIN pg_catalog.pg_namespace 761 AS n ON 762 ct.relnamespace 763 = n.oid 764 JOIN ( 765 SELECT 766 i.indexrelid, 767 i.indrelid, 768 i.indoption, 769 i.indisunique, 770 i.indisclustered, 771 i.indpred, 772 i.indexprs, 773 information_schema._pg_expandarray( 774 i.indkey 775 ) 776 AS keys 777 FROM 778 pg_catalog.pg_index 779 AS i 780 ) 781 AS i ON 782 ct.oid 783 = i.indrelid 784 JOIN pg_catalog.pg_class 785 AS ci ON 786 ci.oid 787 = i.indexrelid 788 JOIN pg_catalog.pg_am 789 AS am ON 790 ci.relam 791 = am.oid 792 WHERE 793 true 794 AND n.nspname = 'public' 795 AND ct.relname = 'j' 796 ORDER BY 797 non_unique, 798 type, 799 index_name, 800 ordinal_position 801 802 29: 803 ----------------------------- 804 SELECT 805 NULL AS table_cat, 806 n.nspname AS table_schem, 807 ct.relname AS table_name, 808 NOT i.indisunique 809 AS non_unique, 810 NULL AS index_qualifier, 811 ci.relname AS index_name, 812 CASE i.indisclustered 813 WHEN true THEN 1 814 ELSE CASE am.amname 815 WHEN 'hash' THEN 2 816 ELSE 3 817 END 818 END 819 AS type, 820 (i.keys).n 821 AS ordinal_position, 822 btrim( 823 pg_catalog.pg_get_indexdef( 824 ci.oid, 825 (i.keys).n, 826 false 827 ), 828 '"' 829 ) 830 AS column_name, 831 CASE am.amcanorder 832 WHEN true 833 THEN CASE i.indoption[(i.keys).n - 1] 834 & 1 835 WHEN 1 THEN 'D' 836 ELSE 'A' 837 END 838 ELSE NULL 839 END 840 AS asc_or_desc, 841 ci.reltuples 842 AS cardinality, 843 ci.relpages AS pages, 844 pg_catalog.pg_get_expr( 845 i.indpred, 846 i.indrelid 847 ) 848 AS filter_condition 849 FROM 850 pg_catalog.pg_class AS ct 851 JOIN pg_catalog.pg_namespace 852 AS n ON 853 ct.relnamespace 854 = n.oid 855 JOIN ( 856 SELECT 857 i.indexrelid, 858 i.indrelid, 859 i.indoption, 860 i.indisunique, 861 i.indisclustered, 862 i.indpred, 863 i.indexprs, 864 information_schema._pg_expandarray( 865 i.indkey 866 ) 867 AS keys 868 FROM 869 pg_catalog.pg_index 870 AS i 871 ) 872 AS i ON 873 ct.oid 874 = i.indrelid 875 JOIN pg_catalog.pg_class 876 AS ci ON 877 ci.oid 878 = i.indexrelid 879 JOIN pg_catalog.pg_am 880 AS am ON 881 ci.relam = am.oid 882 WHERE 883 true 884 AND n.nspname = 'public' 885 AND ct.relname = 'j' 886 ORDER BY 887 non_unique, 888 type, 889 index_name, 890 ordinal_position 891 892 31: 893 ------------------------------- 894 SELECT 895 NULL AS table_cat, 896 n.nspname AS table_schem, 897 ct.relname AS table_name, 898 NOT i.indisunique 899 AS non_unique, 900 NULL AS index_qualifier, 901 ci.relname AS index_name, 902 CASE i.indisclustered 903 WHEN true THEN 1 904 ELSE CASE am.amname 905 WHEN 'hash' THEN 2 906 ELSE 3 907 END 908 END 909 AS type, 910 (i.keys).n 911 AS ordinal_position, 912 btrim( 913 pg_catalog.pg_get_indexdef( 914 ci.oid, 915 (i.keys).n, 916 false 917 ), 918 '"' 919 ) 920 AS column_name, 921 CASE am.amcanorder 922 WHEN true 923 THEN CASE i.indoption[(i.keys).n - 1] 924 & 1 925 WHEN 1 THEN 'D' 926 ELSE 'A' 927 END 928 ELSE NULL 929 END 930 AS asc_or_desc, 931 ci.reltuples 932 AS cardinality, 933 ci.relpages AS pages, 934 pg_catalog.pg_get_expr( 935 i.indpred, 936 i.indrelid 937 ) 938 AS filter_condition 939 FROM 940 pg_catalog.pg_class AS ct 941 JOIN pg_catalog.pg_namespace 942 AS n ON 943 ct.relnamespace 944 = n.oid 945 JOIN ( 946 SELECT 947 i.indexrelid, 948 i.indrelid, 949 i.indoption, 950 i.indisunique, 951 i.indisclustered, 952 i.indpred, 953 i.indexprs, 954 information_schema._pg_expandarray( 955 i.indkey 956 ) 957 AS keys 958 FROM 959 pg_catalog.pg_index 960 AS i 961 ) 962 AS i ON 963 ct.oid = i.indrelid 964 JOIN pg_catalog.pg_class 965 AS ci ON 966 ci.oid 967 = i.indexrelid 968 JOIN pg_catalog.pg_am 969 AS am ON 970 ci.relam = am.oid 971 WHERE 972 true 973 AND n.nspname = 'public' 974 AND ct.relname = 'j' 975 ORDER BY 976 non_unique, 977 type, 978 index_name, 979 ordinal_position 980 981 32: 982 -------------------------------- 983 SELECT 984 NULL AS table_cat, 985 n.nspname AS table_schem, 986 ct.relname AS table_name, 987 NOT i.indisunique 988 AS non_unique, 989 NULL AS index_qualifier, 990 ci.relname AS index_name, 991 CASE i.indisclustered 992 WHEN true THEN 1 993 ELSE CASE am.amname 994 WHEN 'hash' THEN 2 995 ELSE 3 996 END 997 END 998 AS type, 999 (i.keys).n 1000 AS ordinal_position, 1001 btrim( 1002 pg_catalog.pg_get_indexdef( 1003 ci.oid, 1004 (i.keys).n, 1005 false 1006 ), 1007 '"' 1008 ) 1009 AS column_name, 1010 CASE am.amcanorder 1011 WHEN true 1012 THEN CASE i.indoption[(i.keys).n - 1] 1013 & 1 1014 WHEN 1 THEN 'D' 1015 ELSE 'A' 1016 END 1017 ELSE NULL 1018 END 1019 AS asc_or_desc, 1020 ci.reltuples AS cardinality, 1021 ci.relpages AS pages, 1022 pg_catalog.pg_get_expr( 1023 i.indpred, 1024 i.indrelid 1025 ) 1026 AS filter_condition 1027 FROM 1028 pg_catalog.pg_class AS ct 1029 JOIN pg_catalog.pg_namespace 1030 AS n ON 1031 ct.relnamespace 1032 = n.oid 1033 JOIN ( 1034 SELECT 1035 i.indexrelid, 1036 i.indrelid, 1037 i.indoption, 1038 i.indisunique, 1039 i.indisclustered, 1040 i.indpred, 1041 i.indexprs, 1042 information_schema._pg_expandarray( 1043 i.indkey 1044 ) 1045 AS keys 1046 FROM 1047 pg_catalog.pg_index 1048 AS i 1049 ) 1050 AS i ON 1051 ct.oid = i.indrelid 1052 JOIN pg_catalog.pg_class 1053 AS ci ON 1054 ci.oid 1055 = i.indexrelid 1056 JOIN pg_catalog.pg_am 1057 AS am ON 1058 ci.relam = am.oid 1059 WHERE 1060 true 1061 AND n.nspname = 'public' 1062 AND ct.relname = 'j' 1063 ORDER BY 1064 non_unique, 1065 type, 1066 index_name, 1067 ordinal_position 1068 1069 33: 1070 --------------------------------- 1071 SELECT 1072 NULL AS table_cat, 1073 n.nspname AS table_schem, 1074 ct.relname AS table_name, 1075 NOT i.indisunique 1076 AS non_unique, 1077 NULL AS index_qualifier, 1078 ci.relname AS index_name, 1079 CASE i.indisclustered 1080 WHEN true THEN 1 1081 ELSE CASE am.amname 1082 WHEN 'hash' THEN 2 1083 ELSE 3 1084 END 1085 END 1086 AS type, 1087 (i.keys).n 1088 AS ordinal_position, 1089 btrim( 1090 pg_catalog.pg_get_indexdef( 1091 ci.oid, 1092 (i.keys).n, 1093 false 1094 ), 1095 '"' 1096 ) 1097 AS column_name, 1098 CASE am.amcanorder 1099 WHEN true 1100 THEN CASE i.indoption[(i.keys).n - 1] 1101 & 1 1102 WHEN 1 THEN 'D' 1103 ELSE 'A' 1104 END 1105 ELSE NULL 1106 END 1107 AS asc_or_desc, 1108 ci.reltuples AS cardinality, 1109 ci.relpages AS pages, 1110 pg_catalog.pg_get_expr( 1111 i.indpred, 1112 i.indrelid 1113 ) 1114 AS filter_condition 1115 FROM 1116 pg_catalog.pg_class AS ct 1117 JOIN pg_catalog.pg_namespace 1118 AS n ON 1119 ct.relnamespace 1120 = n.oid 1121 JOIN ( 1122 SELECT 1123 i.indexrelid, 1124 i.indrelid, 1125 i.indoption, 1126 i.indisunique, 1127 i.indisclustered, 1128 i.indpred, 1129 i.indexprs, 1130 information_schema._pg_expandarray( 1131 i.indkey 1132 ) 1133 AS keys 1134 FROM 1135 pg_catalog.pg_index 1136 AS i 1137 ) 1138 AS i ON 1139 ct.oid = i.indrelid 1140 JOIN pg_catalog.pg_class 1141 AS ci ON 1142 ci.oid = i.indexrelid 1143 JOIN pg_catalog.pg_am 1144 AS am ON 1145 ci.relam = am.oid 1146 WHERE 1147 true 1148 AND n.nspname = 'public' 1149 AND ct.relname = 'j' 1150 ORDER BY 1151 non_unique, 1152 type, 1153 index_name, 1154 ordinal_position 1155 1156 34: 1157 ---------------------------------- 1158 SELECT 1159 NULL AS table_cat, 1160 n.nspname AS table_schem, 1161 ct.relname AS table_name, 1162 NOT i.indisunique 1163 AS non_unique, 1164 NULL AS index_qualifier, 1165 ci.relname AS index_name, 1166 CASE i.indisclustered 1167 WHEN true THEN 1 1168 ELSE CASE am.amname 1169 WHEN 'hash' THEN 2 1170 ELSE 3 1171 END 1172 END 1173 AS type, 1174 (i.keys).n 1175 AS ordinal_position, 1176 btrim( 1177 pg_catalog.pg_get_indexdef( 1178 ci.oid, 1179 (i.keys).n, 1180 false 1181 ), 1182 '"' 1183 ) 1184 AS column_name, 1185 CASE am.amcanorder 1186 WHEN true 1187 THEN CASE i.indoption[(i.keys).n - 1] 1188 & 1 1189 WHEN 1 THEN 'D' 1190 ELSE 'A' 1191 END 1192 ELSE NULL 1193 END 1194 AS asc_or_desc, 1195 ci.reltuples AS cardinality, 1196 ci.relpages AS pages, 1197 pg_catalog.pg_get_expr( 1198 i.indpred, 1199 i.indrelid 1200 ) 1201 AS filter_condition 1202 FROM 1203 pg_catalog.pg_class AS ct 1204 JOIN pg_catalog.pg_namespace 1205 AS n ON 1206 ct.relnamespace 1207 = n.oid 1208 JOIN ( 1209 SELECT 1210 i.indexrelid, 1211 i.indrelid, 1212 i.indoption, 1213 i.indisunique, 1214 i.indisclustered, 1215 i.indpred, 1216 i.indexprs, 1217 information_schema._pg_expandarray( 1218 i.indkey 1219 ) 1220 AS keys 1221 FROM 1222 pg_catalog.pg_index 1223 AS i 1224 ) 1225 AS i ON 1226 ct.oid = i.indrelid 1227 JOIN pg_catalog.pg_class 1228 AS ci ON 1229 ci.oid = i.indexrelid 1230 JOIN pg_catalog.pg_am AS am ON 1231 ci.relam = am.oid 1232 WHERE 1233 true 1234 AND n.nspname = 'public' 1235 AND ct.relname = 'j' 1236 ORDER BY 1237 non_unique, 1238 type, 1239 index_name, 1240 ordinal_position 1241 1242 35: 1243 ----------------------------------- 1244 SELECT 1245 NULL AS table_cat, 1246 n.nspname AS table_schem, 1247 ct.relname AS table_name, 1248 NOT i.indisunique 1249 AS non_unique, 1250 NULL AS index_qualifier, 1251 ci.relname AS index_name, 1252 CASE i.indisclustered 1253 WHEN true THEN 1 1254 ELSE CASE am.amname 1255 WHEN 'hash' THEN 2 1256 ELSE 3 1257 END 1258 END 1259 AS type, 1260 (i.keys).n AS ordinal_position, 1261 btrim( 1262 pg_catalog.pg_get_indexdef( 1263 ci.oid, 1264 (i.keys).n, 1265 false 1266 ), 1267 '"' 1268 ) 1269 AS column_name, 1270 CASE am.amcanorder 1271 WHEN true 1272 THEN CASE i.indoption[(i.keys).n - 1] 1273 & 1 1274 WHEN 1 THEN 'D' 1275 ELSE 'A' 1276 END 1277 ELSE NULL 1278 END 1279 AS asc_or_desc, 1280 ci.reltuples AS cardinality, 1281 ci.relpages AS pages, 1282 pg_catalog.pg_get_expr( 1283 i.indpred, 1284 i.indrelid 1285 ) 1286 AS filter_condition 1287 FROM 1288 pg_catalog.pg_class AS ct 1289 JOIN pg_catalog.pg_namespace 1290 AS n ON 1291 ct.relnamespace = n.oid 1292 JOIN ( 1293 SELECT 1294 i.indexrelid, 1295 i.indrelid, 1296 i.indoption, 1297 i.indisunique, 1298 i.indisclustered, 1299 i.indpred, 1300 i.indexprs, 1301 information_schema._pg_expandarray( 1302 i.indkey 1303 ) 1304 AS keys 1305 FROM 1306 pg_catalog.pg_index 1307 AS i 1308 ) 1309 AS i ON 1310 ct.oid = i.indrelid 1311 JOIN pg_catalog.pg_class 1312 AS ci ON 1313 ci.oid = i.indexrelid 1314 JOIN pg_catalog.pg_am AS am ON 1315 ci.relam = am.oid 1316 WHERE 1317 true 1318 AND n.nspname = 'public' 1319 AND ct.relname = 'j' 1320 ORDER BY 1321 non_unique, 1322 type, 1323 index_name, 1324 ordinal_position 1325 1326 36: 1327 ------------------------------------ 1328 SELECT 1329 NULL AS table_cat, 1330 n.nspname AS table_schem, 1331 ct.relname AS table_name, 1332 NOT i.indisunique AS non_unique, 1333 NULL AS index_qualifier, 1334 ci.relname AS index_name, 1335 CASE i.indisclustered 1336 WHEN true THEN 1 1337 ELSE CASE am.amname 1338 WHEN 'hash' THEN 2 1339 ELSE 3 1340 END 1341 END 1342 AS type, 1343 (i.keys).n AS ordinal_position, 1344 btrim( 1345 pg_catalog.pg_get_indexdef( 1346 ci.oid, 1347 (i.keys).n, 1348 false 1349 ), 1350 '"' 1351 ) 1352 AS column_name, 1353 CASE am.amcanorder 1354 WHEN true 1355 THEN CASE i.indoption[(i.keys).n - 1] 1356 & 1 1357 WHEN 1 THEN 'D' 1358 ELSE 'A' 1359 END 1360 ELSE NULL 1361 END 1362 AS asc_or_desc, 1363 ci.reltuples AS cardinality, 1364 ci.relpages AS pages, 1365 pg_catalog.pg_get_expr( 1366 i.indpred, 1367 i.indrelid 1368 ) 1369 AS filter_condition 1370 FROM 1371 pg_catalog.pg_class AS ct 1372 JOIN pg_catalog.pg_namespace 1373 AS n ON 1374 ct.relnamespace = n.oid 1375 JOIN ( 1376 SELECT 1377 i.indexrelid, 1378 i.indrelid, 1379 i.indoption, 1380 i.indisunique, 1381 i.indisclustered, 1382 i.indpred, 1383 i.indexprs, 1384 information_schema._pg_expandarray( 1385 i.indkey 1386 ) 1387 AS keys 1388 FROM 1389 pg_catalog.pg_index 1390 AS i 1391 ) 1392 AS i ON 1393 ct.oid = i.indrelid 1394 JOIN pg_catalog.pg_class 1395 AS ci ON 1396 ci.oid = i.indexrelid 1397 JOIN pg_catalog.pg_am AS am ON 1398 ci.relam = am.oid 1399 WHERE 1400 true 1401 AND n.nspname = 'public' 1402 AND ct.relname = 'j' 1403 ORDER BY 1404 non_unique, 1405 type, 1406 index_name, 1407 ordinal_position 1408 1409 37: 1410 ------------------------------------- 1411 SELECT 1412 NULL AS table_cat, 1413 n.nspname AS table_schem, 1414 ct.relname AS table_name, 1415 NOT i.indisunique AS non_unique, 1416 NULL AS index_qualifier, 1417 ci.relname AS index_name, 1418 CASE i.indisclustered 1419 WHEN true THEN 1 1420 ELSE CASE am.amname 1421 WHEN 'hash' THEN 2 1422 ELSE 3 1423 END 1424 END 1425 AS type, 1426 (i.keys).n AS ordinal_position, 1427 btrim( 1428 pg_catalog.pg_get_indexdef( 1429 ci.oid, 1430 (i.keys).n, 1431 false 1432 ), 1433 '"' 1434 ) 1435 AS column_name, 1436 CASE am.amcanorder 1437 WHEN true 1438 THEN CASE i.indoption[(i.keys).n - 1] 1439 & 1 1440 WHEN 1 THEN 'D' 1441 ELSE 'A' 1442 END 1443 ELSE NULL 1444 END 1445 AS asc_or_desc, 1446 ci.reltuples AS cardinality, 1447 ci.relpages AS pages, 1448 pg_catalog.pg_get_expr( 1449 i.indpred, 1450 i.indrelid 1451 ) 1452 AS filter_condition 1453 FROM 1454 pg_catalog.pg_class AS ct 1455 JOIN pg_catalog.pg_namespace 1456 AS n ON 1457 ct.relnamespace = n.oid 1458 JOIN ( 1459 SELECT 1460 i.indexrelid, 1461 i.indrelid, 1462 i.indoption, 1463 i.indisunique, 1464 i.indisclustered, 1465 i.indpred, 1466 i.indexprs, 1467 information_schema._pg_expandarray( 1468 i.indkey 1469 ) 1470 AS keys 1471 FROM 1472 pg_catalog.pg_index 1473 AS i 1474 ) 1475 AS i ON 1476 ct.oid = i.indrelid 1477 JOIN pg_catalog.pg_class AS ci ON 1478 ci.oid = i.indexrelid 1479 JOIN pg_catalog.pg_am AS am ON 1480 ci.relam = am.oid 1481 WHERE 1482 true 1483 AND n.nspname = 'public' 1484 AND ct.relname = 'j' 1485 ORDER BY 1486 non_unique, 1487 type, 1488 index_name, 1489 ordinal_position 1490 1491 39: 1492 --------------------------------------- 1493 SELECT 1494 NULL AS table_cat, 1495 n.nspname AS table_schem, 1496 ct.relname AS table_name, 1497 NOT i.indisunique AS non_unique, 1498 NULL AS index_qualifier, 1499 ci.relname AS index_name, 1500 CASE i.indisclustered 1501 WHEN true THEN 1 1502 ELSE CASE am.amname 1503 WHEN 'hash' THEN 2 1504 ELSE 3 1505 END 1506 END 1507 AS type, 1508 (i.keys).n AS ordinal_position, 1509 btrim( 1510 pg_catalog.pg_get_indexdef( 1511 ci.oid, 1512 (i.keys).n, 1513 false 1514 ), 1515 '"' 1516 ) 1517 AS column_name, 1518 CASE am.amcanorder 1519 WHEN true 1520 THEN CASE i.indoption[(i.keys).n - 1] 1521 & 1 1522 WHEN 1 THEN 'D' 1523 ELSE 'A' 1524 END 1525 ELSE NULL 1526 END 1527 AS asc_or_desc, 1528 ci.reltuples AS cardinality, 1529 ci.relpages AS pages, 1530 pg_catalog.pg_get_expr( 1531 i.indpred, 1532 i.indrelid 1533 ) 1534 AS filter_condition 1535 FROM 1536 pg_catalog.pg_class AS ct 1537 JOIN pg_catalog.pg_namespace 1538 AS n ON 1539 ct.relnamespace = n.oid 1540 JOIN ( 1541 SELECT 1542 i.indexrelid, 1543 i.indrelid, 1544 i.indoption, 1545 i.indisunique, 1546 i.indisclustered, 1547 i.indpred, 1548 i.indexprs, 1549 information_schema._pg_expandarray( 1550 i.indkey 1551 ) 1552 AS keys 1553 FROM 1554 pg_catalog.pg_index 1555 AS i 1556 ) 1557 AS i ON ct.oid = i.indrelid 1558 JOIN pg_catalog.pg_class AS ci ON 1559 ci.oid = i.indexrelid 1560 JOIN pg_catalog.pg_am AS am ON 1561 ci.relam = am.oid 1562 WHERE 1563 true 1564 AND n.nspname = 'public' 1565 AND ct.relname = 'j' 1566 ORDER BY 1567 non_unique, 1568 type, 1569 index_name, 1570 ordinal_position 1571 1572 40: 1573 ---------------------------------------- 1574 SELECT 1575 NULL AS table_cat, 1576 n.nspname AS table_schem, 1577 ct.relname AS table_name, 1578 NOT i.indisunique AS non_unique, 1579 NULL AS index_qualifier, 1580 ci.relname AS index_name, 1581 CASE i.indisclustered 1582 WHEN true THEN 1 1583 ELSE CASE am.amname 1584 WHEN 'hash' THEN 2 1585 ELSE 3 1586 END 1587 END 1588 AS type, 1589 (i.keys).n AS ordinal_position, 1590 btrim( 1591 pg_catalog.pg_get_indexdef( 1592 ci.oid, 1593 (i.keys).n, 1594 false 1595 ), 1596 '"' 1597 ) 1598 AS column_name, 1599 CASE am.amcanorder 1600 WHEN true 1601 THEN CASE i.indoption[(i.keys).n - 1] 1602 & 1 1603 WHEN 1 THEN 'D' 1604 ELSE 'A' 1605 END 1606 ELSE NULL 1607 END 1608 AS asc_or_desc, 1609 ci.reltuples AS cardinality, 1610 ci.relpages AS pages, 1611 pg_catalog.pg_get_expr( 1612 i.indpred, 1613 i.indrelid 1614 ) 1615 AS filter_condition 1616 FROM 1617 pg_catalog.pg_class AS ct 1618 JOIN pg_catalog.pg_namespace AS n ON 1619 ct.relnamespace = n.oid 1620 JOIN ( 1621 SELECT 1622 i.indexrelid, 1623 i.indrelid, 1624 i.indoption, 1625 i.indisunique, 1626 i.indisclustered, 1627 i.indpred, 1628 i.indexprs, 1629 information_schema._pg_expandarray( 1630 i.indkey 1631 ) 1632 AS keys 1633 FROM 1634 pg_catalog.pg_index AS i 1635 ) 1636 AS i ON ct.oid = i.indrelid 1637 JOIN pg_catalog.pg_class AS ci ON 1638 ci.oid = i.indexrelid 1639 JOIN pg_catalog.pg_am AS am ON 1640 ci.relam = am.oid 1641 WHERE 1642 true 1643 AND n.nspname = 'public' 1644 AND ct.relname = 'j' 1645 ORDER BY 1646 non_unique, 1647 type, 1648 index_name, 1649 ordinal_position 1650 1651 45: 1652 --------------------------------------------- 1653 SELECT 1654 NULL AS table_cat, 1655 n.nspname AS table_schem, 1656 ct.relname AS table_name, 1657 NOT i.indisunique AS non_unique, 1658 NULL AS index_qualifier, 1659 ci.relname AS index_name, 1660 CASE i.indisclustered 1661 WHEN true THEN 1 1662 ELSE CASE am.amname 1663 WHEN 'hash' THEN 2 1664 ELSE 3 1665 END 1666 END 1667 AS type, 1668 (i.keys).n AS ordinal_position, 1669 btrim( 1670 pg_catalog.pg_get_indexdef( 1671 ci.oid, 1672 (i.keys).n, 1673 false 1674 ), 1675 '"' 1676 ) 1677 AS column_name, 1678 CASE am.amcanorder 1679 WHEN true 1680 THEN CASE i.indoption[(i.keys).n - 1] & 1 1681 WHEN 1 THEN 'D' 1682 ELSE 'A' 1683 END 1684 ELSE NULL 1685 END 1686 AS asc_or_desc, 1687 ci.reltuples AS cardinality, 1688 ci.relpages AS pages, 1689 pg_catalog.pg_get_expr( 1690 i.indpred, 1691 i.indrelid 1692 ) 1693 AS filter_condition 1694 FROM 1695 pg_catalog.pg_class AS ct 1696 JOIN pg_catalog.pg_namespace AS n ON 1697 ct.relnamespace = n.oid 1698 JOIN ( 1699 SELECT 1700 i.indexrelid, 1701 i.indrelid, 1702 i.indoption, 1703 i.indisunique, 1704 i.indisclustered, 1705 i.indpred, 1706 i.indexprs, 1707 information_schema._pg_expandarray( 1708 i.indkey 1709 ) 1710 AS keys 1711 FROM 1712 pg_catalog.pg_index AS i 1713 ) 1714 AS i ON ct.oid = i.indrelid 1715 JOIN pg_catalog.pg_class AS ci ON 1716 ci.oid = i.indexrelid 1717 JOIN pg_catalog.pg_am AS am ON 1718 ci.relam = am.oid 1719 WHERE 1720 true 1721 AND n.nspname = 'public' 1722 AND ct.relname = 'j' 1723 ORDER BY 1724 non_unique, 1725 type, 1726 index_name, 1727 ordinal_position 1728 1729 49: 1730 ------------------------------------------------- 1731 SELECT 1732 NULL AS table_cat, 1733 n.nspname AS table_schem, 1734 ct.relname AS table_name, 1735 NOT i.indisunique AS non_unique, 1736 NULL AS index_qualifier, 1737 ci.relname AS index_name, 1738 CASE i.indisclustered 1739 WHEN true THEN 1 1740 ELSE CASE am.amname 1741 WHEN 'hash' THEN 2 1742 ELSE 3 1743 END 1744 END 1745 AS type, 1746 (i.keys).n AS ordinal_position, 1747 btrim( 1748 pg_catalog.pg_get_indexdef( 1749 ci.oid, 1750 (i.keys).n, 1751 false 1752 ), 1753 '"' 1754 ) 1755 AS column_name, 1756 CASE am.amcanorder 1757 WHEN true 1758 THEN CASE i.indoption[(i.keys).n - 1] & 1 1759 WHEN 1 THEN 'D' 1760 ELSE 'A' 1761 END 1762 ELSE NULL 1763 END 1764 AS asc_or_desc, 1765 ci.reltuples AS cardinality, 1766 ci.relpages AS pages, 1767 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 1768 AS filter_condition 1769 FROM 1770 pg_catalog.pg_class AS ct 1771 JOIN pg_catalog.pg_namespace AS n ON 1772 ct.relnamespace = n.oid 1773 JOIN ( 1774 SELECT 1775 i.indexrelid, 1776 i.indrelid, 1777 i.indoption, 1778 i.indisunique, 1779 i.indisclustered, 1780 i.indpred, 1781 i.indexprs, 1782 information_schema._pg_expandarray( 1783 i.indkey 1784 ) 1785 AS keys 1786 FROM 1787 pg_catalog.pg_index AS i 1788 ) 1789 AS i ON ct.oid = i.indrelid 1790 JOIN pg_catalog.pg_class AS ci ON 1791 ci.oid = i.indexrelid 1792 JOIN pg_catalog.pg_am AS am ON 1793 ci.relam = am.oid 1794 WHERE 1795 true 1796 AND n.nspname = 'public' 1797 AND ct.relname = 'j' 1798 ORDER BY 1799 non_unique, 1800 type, 1801 index_name, 1802 ordinal_position 1803 1804 50: 1805 -------------------------------------------------- 1806 SELECT 1807 NULL AS table_cat, 1808 n.nspname AS table_schem, 1809 ct.relname AS table_name, 1810 NOT i.indisunique AS non_unique, 1811 NULL AS index_qualifier, 1812 ci.relname AS index_name, 1813 CASE i.indisclustered 1814 WHEN true THEN 1 1815 ELSE CASE am.amname 1816 WHEN 'hash' THEN 2 1817 ELSE 3 1818 END 1819 END 1820 AS type, 1821 (i.keys).n AS ordinal_position, 1822 btrim( 1823 pg_catalog.pg_get_indexdef( 1824 ci.oid, 1825 (i.keys).n, 1826 false 1827 ), 1828 '"' 1829 ) 1830 AS column_name, 1831 CASE am.amcanorder 1832 WHEN true 1833 THEN CASE i.indoption[(i.keys).n - 1] & 1 1834 WHEN 1 THEN 'D' 1835 ELSE 'A' 1836 END 1837 ELSE NULL 1838 END 1839 AS asc_or_desc, 1840 ci.reltuples AS cardinality, 1841 ci.relpages AS pages, 1842 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 1843 AS filter_condition 1844 FROM 1845 pg_catalog.pg_class AS ct 1846 JOIN pg_catalog.pg_namespace AS n ON 1847 ct.relnamespace = n.oid 1848 JOIN ( 1849 SELECT 1850 i.indexrelid, 1851 i.indrelid, 1852 i.indoption, 1853 i.indisunique, 1854 i.indisclustered, 1855 i.indpred, 1856 i.indexprs, 1857 information_schema._pg_expandarray( 1858 i.indkey 1859 ) 1860 AS keys 1861 FROM 1862 pg_catalog.pg_index AS i 1863 ) 1864 AS i ON ct.oid = i.indrelid 1865 JOIN pg_catalog.pg_class AS ci ON 1866 ci.oid = i.indexrelid 1867 JOIN pg_catalog.pg_am AS am ON 1868 ci.relam = am.oid 1869 WHERE 1870 true 1871 AND n.nspname = 'public' 1872 AND ct.relname = 'j' 1873 ORDER BY 1874 non_unique, type, index_name, ordinal_position 1875 1876 52: 1877 ---------------------------------------------------- 1878 SELECT 1879 NULL AS table_cat, 1880 n.nspname AS table_schem, 1881 ct.relname AS table_name, 1882 NOT i.indisunique AS non_unique, 1883 NULL AS index_qualifier, 1884 ci.relname AS index_name, 1885 CASE i.indisclustered 1886 WHEN true THEN 1 1887 ELSE CASE am.amname 1888 WHEN 'hash' THEN 2 1889 ELSE 3 1890 END 1891 END 1892 AS type, 1893 (i.keys).n AS ordinal_position, 1894 btrim( 1895 pg_catalog.pg_get_indexdef( 1896 ci.oid, 1897 (i.keys).n, 1898 false 1899 ), 1900 '"' 1901 ) 1902 AS column_name, 1903 CASE am.amcanorder 1904 WHEN true 1905 THEN CASE i.indoption[(i.keys).n - 1] & 1 1906 WHEN 1 THEN 'D' 1907 ELSE 'A' 1908 END 1909 ELSE NULL 1910 END 1911 AS asc_or_desc, 1912 ci.reltuples AS cardinality, 1913 ci.relpages AS pages, 1914 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 1915 AS filter_condition 1916 FROM 1917 pg_catalog.pg_class AS ct 1918 JOIN pg_catalog.pg_namespace AS n ON 1919 ct.relnamespace = n.oid 1920 JOIN ( 1921 SELECT 1922 i.indexrelid, 1923 i.indrelid, 1924 i.indoption, 1925 i.indisunique, 1926 i.indisclustered, 1927 i.indpred, 1928 i.indexprs, 1929 information_schema._pg_expandarray( 1930 i.indkey 1931 ) 1932 AS keys 1933 FROM 1934 pg_catalog.pg_index AS i 1935 ) 1936 AS i ON ct.oid = i.indrelid 1937 JOIN pg_catalog.pg_class AS ci ON 1938 ci.oid = i.indexrelid 1939 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 1940 WHERE 1941 true 1942 AND n.nspname = 'public' 1943 AND ct.relname = 'j' 1944 ORDER BY 1945 non_unique, type, index_name, ordinal_position 1946 1947 53: 1948 ----------------------------------------------------- 1949 SELECT 1950 NULL AS table_cat, 1951 n.nspname AS table_schem, 1952 ct.relname AS table_name, 1953 NOT i.indisunique AS non_unique, 1954 NULL AS index_qualifier, 1955 ci.relname AS index_name, 1956 CASE i.indisclustered 1957 WHEN true THEN 1 1958 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 1959 END 1960 AS type, 1961 (i.keys).n AS ordinal_position, 1962 btrim( 1963 pg_catalog.pg_get_indexdef( 1964 ci.oid, 1965 (i.keys).n, 1966 false 1967 ), 1968 '"' 1969 ) 1970 AS column_name, 1971 CASE am.amcanorder 1972 WHEN true 1973 THEN CASE i.indoption[(i.keys).n - 1] & 1 1974 WHEN 1 THEN 'D' 1975 ELSE 'A' 1976 END 1977 ELSE NULL 1978 END 1979 AS asc_or_desc, 1980 ci.reltuples AS cardinality, 1981 ci.relpages AS pages, 1982 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 1983 AS filter_condition 1984 FROM 1985 pg_catalog.pg_class AS ct 1986 JOIN pg_catalog.pg_namespace AS n ON 1987 ct.relnamespace = n.oid 1988 JOIN ( 1989 SELECT 1990 i.indexrelid, 1991 i.indrelid, 1992 i.indoption, 1993 i.indisunique, 1994 i.indisclustered, 1995 i.indpred, 1996 i.indexprs, 1997 information_schema._pg_expandarray( 1998 i.indkey 1999 ) 2000 AS keys 2001 FROM 2002 pg_catalog.pg_index AS i 2003 ) 2004 AS i ON ct.oid = i.indrelid 2005 JOIN pg_catalog.pg_class AS ci ON 2006 ci.oid = i.indexrelid 2007 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2008 WHERE 2009 true 2010 AND n.nspname = 'public' 2011 AND ct.relname = 'j' 2012 ORDER BY 2013 non_unique, type, index_name, ordinal_position 2014 2015 54: 2016 ------------------------------------------------------ 2017 SELECT 2018 NULL AS table_cat, 2019 n.nspname AS table_schem, 2020 ct.relname AS table_name, 2021 NOT i.indisunique AS non_unique, 2022 NULL AS index_qualifier, 2023 ci.relname AS index_name, 2024 CASE i.indisclustered 2025 WHEN true THEN 1 2026 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2027 END 2028 AS type, 2029 (i.keys).n AS ordinal_position, 2030 btrim( 2031 pg_catalog.pg_get_indexdef( 2032 ci.oid, 2033 (i.keys).n, 2034 false 2035 ), 2036 '"' 2037 ) 2038 AS column_name, 2039 CASE am.amcanorder 2040 WHEN true 2041 THEN CASE i.indoption[(i.keys).n - 1] & 1 2042 WHEN 1 THEN 'D' 2043 ELSE 'A' 2044 END 2045 ELSE NULL 2046 END 2047 AS asc_or_desc, 2048 ci.reltuples AS cardinality, 2049 ci.relpages AS pages, 2050 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 2051 AS filter_condition 2052 FROM 2053 pg_catalog.pg_class AS ct 2054 JOIN pg_catalog.pg_namespace AS n ON 2055 ct.relnamespace = n.oid 2056 JOIN ( 2057 SELECT 2058 i.indexrelid, 2059 i.indrelid, 2060 i.indoption, 2061 i.indisunique, 2062 i.indisclustered, 2063 i.indpred, 2064 i.indexprs, 2065 information_schema._pg_expandarray( 2066 i.indkey 2067 ) 2068 AS keys 2069 FROM 2070 pg_catalog.pg_index AS i 2071 ) 2072 AS i ON ct.oid = i.indrelid 2073 JOIN pg_catalog.pg_class AS ci ON 2074 ci.oid = i.indexrelid 2075 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2076 WHERE 2077 true AND n.nspname = 'public' AND ct.relname = 'j' 2078 ORDER BY 2079 non_unique, type, index_name, ordinal_position 2080 2081 59: 2082 ----------------------------------------------------------- 2083 SELECT 2084 NULL AS table_cat, 2085 n.nspname AS table_schem, 2086 ct.relname AS table_name, 2087 NOT i.indisunique AS non_unique, 2088 NULL AS index_qualifier, 2089 ci.relname AS index_name, 2090 CASE i.indisclustered 2091 WHEN true THEN 1 2092 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2093 END 2094 AS type, 2095 (i.keys).n AS ordinal_position, 2096 btrim( 2097 pg_catalog.pg_get_indexdef( 2098 ci.oid, 2099 (i.keys).n, 2100 false 2101 ), 2102 '"' 2103 ) 2104 AS column_name, 2105 CASE am.amcanorder 2106 WHEN true 2107 THEN CASE i.indoption[(i.keys).n - 1] & 1 2108 WHEN 1 THEN 'D' 2109 ELSE 'A' 2110 END 2111 ELSE NULL 2112 END 2113 AS asc_or_desc, 2114 ci.reltuples AS cardinality, 2115 ci.relpages AS pages, 2116 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 2117 AS filter_condition 2118 FROM 2119 pg_catalog.pg_class AS ct 2120 JOIN pg_catalog.pg_namespace AS n ON 2121 ct.relnamespace = n.oid 2122 JOIN ( 2123 SELECT 2124 i.indexrelid, 2125 i.indrelid, 2126 i.indoption, 2127 i.indisunique, 2128 i.indisclustered, 2129 i.indpred, 2130 i.indexprs, 2131 information_schema._pg_expandarray( 2132 i.indkey 2133 ) 2134 AS keys 2135 FROM 2136 pg_catalog.pg_index AS i 2137 ) 2138 AS i ON ct.oid = i.indrelid 2139 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2140 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2141 WHERE 2142 true AND n.nspname = 'public' AND ct.relname = 'j' 2143 ORDER BY 2144 non_unique, type, index_name, ordinal_position 2145 2146 60: 2147 ------------------------------------------------------------ 2148 SELECT 2149 NULL AS table_cat, 2150 n.nspname AS table_schem, 2151 ct.relname AS table_name, 2152 NOT i.indisunique AS non_unique, 2153 NULL AS index_qualifier, 2154 ci.relname AS index_name, 2155 CASE i.indisclustered 2156 WHEN true THEN 1 2157 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2158 END 2159 AS type, 2160 (i.keys).n AS ordinal_position, 2161 btrim( 2162 pg_catalog.pg_get_indexdef( 2163 ci.oid, 2164 (i.keys).n, 2165 false 2166 ), 2167 '"' 2168 ) 2169 AS column_name, 2170 CASE am.amcanorder 2171 WHEN true 2172 THEN CASE i.indoption[(i.keys).n - 1] & 1 2173 WHEN 1 THEN 'D' 2174 ELSE 'A' 2175 END 2176 ELSE NULL 2177 END 2178 AS asc_or_desc, 2179 ci.reltuples AS cardinality, 2180 ci.relpages AS pages, 2181 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 2182 AS filter_condition 2183 FROM 2184 pg_catalog.pg_class AS ct 2185 JOIN pg_catalog.pg_namespace AS n ON 2186 ct.relnamespace = n.oid 2187 JOIN ( 2188 SELECT 2189 i.indexrelid, 2190 i.indrelid, 2191 i.indoption, 2192 i.indisunique, 2193 i.indisclustered, 2194 i.indpred, 2195 i.indexprs, 2196 information_schema._pg_expandarray(i.indkey) 2197 AS keys 2198 FROM 2199 pg_catalog.pg_index AS i 2200 ) 2201 AS i ON ct.oid = i.indrelid 2202 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2203 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2204 WHERE 2205 true AND n.nspname = 'public' AND ct.relname = 'j' 2206 ORDER BY 2207 non_unique, type, index_name, ordinal_position 2208 2209 62: 2210 -------------------------------------------------------------- 2211 SELECT 2212 NULL AS table_cat, 2213 n.nspname AS table_schem, 2214 ct.relname AS table_name, 2215 NOT i.indisunique AS non_unique, 2216 NULL AS index_qualifier, 2217 ci.relname AS index_name, 2218 CASE i.indisclustered 2219 WHEN true THEN 1 2220 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2221 END 2222 AS type, 2223 (i.keys).n AS ordinal_position, 2224 btrim( 2225 pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), 2226 '"' 2227 ) 2228 AS column_name, 2229 CASE am.amcanorder 2230 WHEN true 2231 THEN CASE i.indoption[(i.keys).n - 1] & 1 2232 WHEN 1 THEN 'D' 2233 ELSE 'A' 2234 END 2235 ELSE NULL 2236 END 2237 AS asc_or_desc, 2238 ci.reltuples AS cardinality, 2239 ci.relpages AS pages, 2240 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 2241 AS filter_condition 2242 FROM 2243 pg_catalog.pg_class AS ct 2244 JOIN pg_catalog.pg_namespace AS n ON 2245 ct.relnamespace = n.oid 2246 JOIN ( 2247 SELECT 2248 i.indexrelid, 2249 i.indrelid, 2250 i.indoption, 2251 i.indisunique, 2252 i.indisclustered, 2253 i.indpred, 2254 i.indexprs, 2255 information_schema._pg_expandarray(i.indkey) 2256 AS keys 2257 FROM 2258 pg_catalog.pg_index AS i 2259 ) 2260 AS i ON ct.oid = i.indrelid 2261 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2262 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2263 WHERE 2264 true AND n.nspname = 'public' AND ct.relname = 'j' 2265 ORDER BY 2266 non_unique, type, index_name, ordinal_position 2267 2268 64: 2269 ---------------------------------------------------------------- 2270 SELECT 2271 NULL AS table_cat, 2272 n.nspname AS table_schem, 2273 ct.relname AS table_name, 2274 NOT i.indisunique AS non_unique, 2275 NULL AS index_qualifier, 2276 ci.relname AS index_name, 2277 CASE i.indisclustered 2278 WHEN true THEN 1 2279 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2280 END 2281 AS type, 2282 (i.keys).n AS ordinal_position, 2283 btrim( 2284 pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), 2285 '"' 2286 ) 2287 AS column_name, 2288 CASE am.amcanorder 2289 WHEN true 2290 THEN CASE i.indoption[(i.keys).n - 1] & 1 2291 WHEN 1 THEN 'D' 2292 ELSE 'A' 2293 END 2294 ELSE NULL 2295 END 2296 AS asc_or_desc, 2297 ci.reltuples AS cardinality, 2298 ci.relpages AS pages, 2299 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 2300 AS filter_condition 2301 FROM 2302 pg_catalog.pg_class AS ct 2303 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2304 JOIN ( 2305 SELECT 2306 i.indexrelid, 2307 i.indrelid, 2308 i.indoption, 2309 i.indisunique, 2310 i.indisclustered, 2311 i.indpred, 2312 i.indexprs, 2313 information_schema._pg_expandarray(i.indkey) 2314 AS keys 2315 FROM 2316 pg_catalog.pg_index AS i 2317 ) 2318 AS i ON ct.oid = i.indrelid 2319 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2320 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2321 WHERE 2322 true AND n.nspname = 'public' AND ct.relname = 'j' 2323 ORDER BY 2324 non_unique, type, index_name, ordinal_position 2325 2326 68: 2327 -------------------------------------------------------------------- 2328 SELECT 2329 NULL AS table_cat, 2330 n.nspname AS table_schem, 2331 ct.relname AS table_name, 2332 NOT i.indisunique AS non_unique, 2333 NULL AS index_qualifier, 2334 ci.relname AS index_name, 2335 CASE i.indisclustered 2336 WHEN true THEN 1 2337 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2338 END 2339 AS type, 2340 (i.keys).n AS ordinal_position, 2341 btrim( 2342 pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), 2343 '"' 2344 ) 2345 AS column_name, 2346 CASE am.amcanorder 2347 WHEN true 2348 THEN CASE i.indoption[(i.keys).n - 1] & 1 2349 WHEN 1 THEN 'D' 2350 ELSE 'A' 2351 END 2352 ELSE NULL 2353 END 2354 AS asc_or_desc, 2355 ci.reltuples AS cardinality, 2356 ci.relpages AS pages, 2357 pg_catalog.pg_get_expr(i.indpred, i.indrelid) 2358 AS filter_condition 2359 FROM 2360 pg_catalog.pg_class AS ct 2361 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2362 JOIN ( 2363 SELECT 2364 i.indexrelid, 2365 i.indrelid, 2366 i.indoption, 2367 i.indisunique, 2368 i.indisclustered, 2369 i.indpred, 2370 i.indexprs, 2371 information_schema._pg_expandarray(i.indkey) AS keys 2372 FROM 2373 pg_catalog.pg_index AS i 2374 ) 2375 AS i ON ct.oid = i.indrelid 2376 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2377 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2378 WHERE 2379 true AND n.nspname = 'public' AND ct.relname = 'j' 2380 ORDER BY 2381 non_unique, type, index_name, ordinal_position 2382 2383 69: 2384 --------------------------------------------------------------------- 2385 SELECT 2386 NULL AS table_cat, 2387 n.nspname AS table_schem, 2388 ct.relname AS table_name, 2389 NOT i.indisunique AS non_unique, 2390 NULL AS index_qualifier, 2391 ci.relname AS index_name, 2392 CASE i.indisclustered 2393 WHEN true THEN 1 2394 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2395 END 2396 AS type, 2397 (i.keys).n AS ordinal_position, 2398 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') 2399 AS column_name, 2400 CASE am.amcanorder 2401 WHEN true 2402 THEN CASE i.indoption[(i.keys).n - 1] & 1 2403 WHEN 1 THEN 'D' 2404 ELSE 'A' 2405 END 2406 ELSE NULL 2407 END 2408 AS asc_or_desc, 2409 ci.reltuples AS cardinality, 2410 ci.relpages AS pages, 2411 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2412 FROM 2413 pg_catalog.pg_class AS ct 2414 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2415 JOIN ( 2416 SELECT 2417 i.indexrelid, 2418 i.indrelid, 2419 i.indoption, 2420 i.indisunique, 2421 i.indisclustered, 2422 i.indpred, 2423 i.indexprs, 2424 information_schema._pg_expandarray(i.indkey) AS keys 2425 FROM 2426 pg_catalog.pg_index AS i 2427 ) 2428 AS i ON ct.oid = i.indrelid 2429 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2430 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2431 WHERE 2432 true AND n.nspname = 'public' AND ct.relname = 'j' 2433 ORDER BY 2434 non_unique, type, index_name, ordinal_position 2435 2436 74: 2437 -------------------------------------------------------------------------- 2438 SELECT 2439 NULL AS table_cat, 2440 n.nspname AS table_schem, 2441 ct.relname AS table_name, 2442 NOT i.indisunique AS non_unique, 2443 NULL AS index_qualifier, 2444 ci.relname AS index_name, 2445 CASE i.indisclustered 2446 WHEN true THEN 1 2447 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2448 END 2449 AS type, 2450 (i.keys).n AS ordinal_position, 2451 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') 2452 AS column_name, 2453 CASE am.amcanorder 2454 WHEN true 2455 THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END 2456 ELSE NULL 2457 END 2458 AS asc_or_desc, 2459 ci.reltuples AS cardinality, 2460 ci.relpages AS pages, 2461 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2462 FROM 2463 pg_catalog.pg_class AS ct 2464 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2465 JOIN ( 2466 SELECT 2467 i.indexrelid, 2468 i.indrelid, 2469 i.indoption, 2470 i.indisunique, 2471 i.indisclustered, 2472 i.indpred, 2473 i.indexprs, 2474 information_schema._pg_expandarray(i.indkey) AS keys 2475 FROM 2476 pg_catalog.pg_index AS i 2477 ) 2478 AS i ON ct.oid = i.indrelid 2479 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2480 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2481 WHERE 2482 true AND n.nspname = 'public' AND ct.relname = 'j' 2483 ORDER BY 2484 non_unique, type, index_name, ordinal_position 2485 2486 84: 2487 ------------------------------------------------------------------------------------ 2488 SELECT 2489 NULL AS table_cat, 2490 n.nspname AS table_schem, 2491 ct.relname AS table_name, 2492 NOT i.indisunique AS non_unique, 2493 NULL AS index_qualifier, 2494 ci.relname AS index_name, 2495 CASE i.indisclustered 2496 WHEN true THEN 1 2497 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2498 END 2499 AS type, 2500 (i.keys).n AS ordinal_position, 2501 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') 2502 AS column_name, 2503 CASE am.amcanorder 2504 WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END 2505 ELSE NULL 2506 END 2507 AS asc_or_desc, 2508 ci.reltuples AS cardinality, 2509 ci.relpages AS pages, 2510 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2511 FROM 2512 pg_catalog.pg_class AS ct 2513 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2514 JOIN ( 2515 SELECT 2516 i.indexrelid, 2517 i.indrelid, 2518 i.indoption, 2519 i.indisunique, 2520 i.indisclustered, 2521 i.indpred, 2522 i.indexprs, 2523 information_schema._pg_expandarray(i.indkey) AS keys 2524 FROM 2525 pg_catalog.pg_index AS i 2526 ) 2527 AS i ON ct.oid = i.indrelid 2528 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2529 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2530 WHERE 2531 true AND n.nspname = 'public' AND ct.relname = 'j' 2532 ORDER BY 2533 non_unique, type, index_name, ordinal_position 2534 2535 85: 2536 ------------------------------------------------------------------------------------- 2537 SELECT 2538 NULL AS table_cat, 2539 n.nspname AS table_schem, 2540 ct.relname AS table_name, 2541 NOT i.indisunique AS non_unique, 2542 NULL AS index_qualifier, 2543 ci.relname AS index_name, 2544 CASE i.indisclustered 2545 WHEN true THEN 1 2546 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END 2547 END 2548 AS type, 2549 (i.keys).n AS ordinal_position, 2550 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2551 CASE am.amcanorder 2552 WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END 2553 ELSE NULL 2554 END 2555 AS asc_or_desc, 2556 ci.reltuples AS cardinality, 2557 ci.relpages AS pages, 2558 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2559 FROM 2560 pg_catalog.pg_class AS ct 2561 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2562 JOIN ( 2563 SELECT 2564 i.indexrelid, 2565 i.indrelid, 2566 i.indoption, 2567 i.indisunique, 2568 i.indisclustered, 2569 i.indpred, 2570 i.indexprs, 2571 information_schema._pg_expandarray(i.indkey) AS keys 2572 FROM 2573 pg_catalog.pg_index AS i 2574 ) 2575 AS i ON ct.oid = i.indrelid 2576 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2577 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2578 WHERE 2579 true AND n.nspname = 'public' AND ct.relname = 'j' 2580 ORDER BY 2581 non_unique, type, index_name, ordinal_position 2582 2583 105: 2584 --------------------------------------------------------------------------------------------------------- 2585 SELECT 2586 NULL AS table_cat, 2587 n.nspname AS table_schem, 2588 ct.relname AS table_name, 2589 NOT i.indisunique AS non_unique, 2590 NULL AS index_qualifier, 2591 ci.relname AS index_name, 2592 CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, 2593 (i.keys).n AS ordinal_position, 2594 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2595 CASE am.amcanorder 2596 WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END 2597 ELSE NULL 2598 END 2599 AS asc_or_desc, 2600 ci.reltuples AS cardinality, 2601 ci.relpages AS pages, 2602 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2603 FROM 2604 pg_catalog.pg_class AS ct 2605 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2606 JOIN ( 2607 SELECT 2608 i.indexrelid, 2609 i.indrelid, 2610 i.indoption, 2611 i.indisunique, 2612 i.indisclustered, 2613 i.indpred, 2614 i.indexprs, 2615 information_schema._pg_expandarray(i.indkey) AS keys 2616 FROM 2617 pg_catalog.pg_index AS i 2618 ) 2619 AS i ON ct.oid = i.indrelid 2620 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2621 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2622 WHERE 2623 true AND n.nspname = 'public' AND ct.relname = 'j' 2624 ORDER BY 2625 non_unique, type, index_name, ordinal_position 2626 2627 133: 2628 ------------------------------------------------------------------------------------------------------------------------------------- 2629 SELECT 2630 NULL AS table_cat, 2631 n.nspname AS table_schem, 2632 ct.relname AS table_name, 2633 NOT i.indisunique AS non_unique, 2634 NULL AS index_qualifier, 2635 ci.relname AS index_name, 2636 CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, 2637 (i.keys).n AS ordinal_position, 2638 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2639 CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, 2640 ci.reltuples AS cardinality, 2641 ci.relpages AS pages, 2642 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2643 FROM 2644 pg_catalog.pg_class AS ct 2645 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2646 JOIN ( 2647 SELECT 2648 i.indexrelid, 2649 i.indrelid, 2650 i.indoption, 2651 i.indisunique, 2652 i.indisclustered, 2653 i.indpred, 2654 i.indexprs, 2655 information_schema._pg_expandarray(i.indkey) AS keys 2656 FROM 2657 pg_catalog.pg_index AS i 2658 ) 2659 AS i ON ct.oid = i.indrelid 2660 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2661 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2662 WHERE 2663 true AND n.nspname = 'public' AND ct.relname = 'j' 2664 ORDER BY 2665 non_unique, type, index_name, ordinal_position 2666 2667 163: 2668 ------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2669 SELECT 2670 NULL AS table_cat, 2671 n.nspname AS table_schem, 2672 ct.relname AS table_name, 2673 NOT i.indisunique AS non_unique, 2674 NULL AS index_qualifier, 2675 ci.relname AS index_name, 2676 CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, 2677 (i.keys).n AS ordinal_position, 2678 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2679 CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, 2680 ci.reltuples AS cardinality, 2681 ci.relpages AS pages, 2682 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2683 FROM 2684 pg_catalog.pg_class AS ct 2685 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2686 JOIN ( 2687 SELECT 2688 i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray(i.indkey) AS keys 2689 FROM 2690 pg_catalog.pg_index AS i 2691 ) 2692 AS i ON ct.oid = i.indrelid 2693 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2694 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2695 WHERE 2696 true AND n.nspname = 'public' AND ct.relname = 'j' 2697 ORDER BY 2698 non_unique, type, index_name, ordinal_position 2699 2700 195: 2701 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2702 SELECT 2703 NULL AS table_cat, 2704 n.nspname AS table_schem, 2705 ct.relname AS table_name, 2706 NOT i.indisunique AS non_unique, 2707 NULL AS index_qualifier, 2708 ci.relname AS index_name, 2709 CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, 2710 (i.keys).n AS ordinal_position, 2711 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2712 CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, 2713 ci.reltuples AS cardinality, 2714 ci.relpages AS pages, 2715 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2716 FROM 2717 pg_catalog.pg_class AS ct 2718 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2719 JOIN (SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) 2720 AS i ON ct.oid = i.indrelid 2721 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2722 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2723 WHERE 2724 true AND n.nspname = 'public' AND ct.relname = 'j' 2725 ORDER BY 2726 non_unique, type, index_name, ordinal_position 2727 2728 203: 2729 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2730 SELECT 2731 NULL AS table_cat, 2732 n.nspname AS table_schem, 2733 ct.relname AS table_name, 2734 NOT i.indisunique AS non_unique, 2735 NULL AS index_qualifier, 2736 ci.relname AS index_name, 2737 CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, 2738 (i.keys).n AS ordinal_position, 2739 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2740 CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, 2741 ci.reltuples AS cardinality, 2742 ci.relpages AS pages, 2743 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2744 FROM 2745 pg_catalog.pg_class AS ct 2746 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2747 JOIN (SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON 2748 ct.oid = i.indrelid 2749 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2750 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2751 WHERE 2752 true AND n.nspname = 'public' AND ct.relname = 'j' 2753 ORDER BY 2754 non_unique, type, index_name, ordinal_position 2755 2756 223: 2757 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2758 SELECT 2759 NULL AS table_cat, 2760 n.nspname AS table_schem, 2761 ct.relname AS table_name, 2762 NOT i.indisunique AS non_unique, 2763 NULL AS index_qualifier, 2764 ci.relname AS index_name, 2765 CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, 2766 (i.keys).n AS ordinal_position, 2767 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2768 CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, 2769 ci.reltuples AS cardinality, 2770 ci.relpages AS pages, 2771 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2772 FROM 2773 pg_catalog.pg_class AS ct 2774 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 2775 JOIN (SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON ct.oid = i.indrelid 2776 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 2777 JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2778 WHERE 2779 true AND n.nspname = 'public' AND ct.relname = 'j' 2780 ORDER BY 2781 non_unique, type, index_name, ordinal_position 2782 2783 415: 2784 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2785 SELECT 2786 NULL AS table_cat, 2787 n.nspname AS table_schem, 2788 ct.relname AS table_name, 2789 NOT i.indisunique AS non_unique, 2790 NULL AS index_qualifier, 2791 ci.relname AS index_name, 2792 CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, 2793 (i.keys).n AS ordinal_position, 2794 btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, 2795 CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, 2796 ci.reltuples AS cardinality, 2797 ci.relpages AS pages, 2798 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2799 FROM 2800 pg_catalog.pg_class AS ct JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid JOIN (SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON ct.oid = i.indrelid JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2801 WHERE 2802 true AND n.nspname = 'public' AND ct.relname = 'j' 2803 ORDER BY 2804 non_unique, type, index_name, ordinal_position 2805 2806 621: 2807 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2808 SELECT 2809 NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, (i.keys).n AS ordinal_position, btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition 2810 FROM 2811 pg_catalog.pg_class AS ct JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid JOIN (SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON ct.oid = i.indrelid JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid 2812 WHERE 2813 true AND n.nspname = 'public' AND ct.relname = 'j' 2814 ORDER BY 2815 non_unique, type, index_name, ordinal_position 2816 2817 1154: 2818 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2819 SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, NOT i.indisunique AS non_unique, NULL AS index_qualifier, ci.relname AS index_name, CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS type, (i.keys).n AS ordinal_position, btrim(pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false), '"') AS column_name, CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS asc_or_desc, ci.reltuples AS cardinality, ci.relpages AS pages, pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition FROM pg_catalog.pg_class AS ct JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid JOIN (SELECT i.indexrelid, i.indrelid, i.indoption, i.indisunique, i.indisclustered, i.indpred, i.indexprs, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON ct.oid = i.indrelid JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid JOIN pg_catalog.pg_am AS am ON ci.relam = am.oid WHERE true AND n.nspname = 'public' AND ct.relname = 'j' ORDER BY non_unique, type, index_name, ordinal_position 2820 2821