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