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