PostgreSQL — Indexes & EXPLAIN

1 PostgreSQL SELECT with ILIKE Easy 2 PostgreSQL B-tree index #1 Hard 3 PostgreSQL B-tree index #2 Medium 4 PostgreSQL B-tree index #3 Medium 5 PostgreSQL B-tree index #4 Hard 6 PostgreSQL B-tree index #5 Medium 7 PostgreSQL B-tree index #6 Medium 8 PostgreSQL B-tree index #7 Hard 9 PostgreSQL B-tree index #8 Medium 10 PostgreSQL B-tree index #9 Medium 11 PostgreSQL B-tree index #10 Hard 12 PostgreSQL B-tree index #11 Medium 13 PostgreSQL B-tree index #12 Medium 14 PostgreSQL B-tree index #13 Hard 15 PostgreSQL B-tree index #14 Medium 16 PostgreSQL B-tree index #15 Medium 17 PostgreSQL B-tree index #16 Hard 18 PostgreSQL B-tree index #17 Medium 19 PostgreSQL B-tree index #18 Medium 20 PostgreSQL B-tree index #19 Hard 21 PostgreSQL B-tree index #20 Medium 22 PostgreSQL B-tree index #21 Medium 23 PostgreSQL B-tree index #22 Hard 24 PostgreSQL B-tree index #23 Medium 25 PostgreSQL B-tree index #24 Medium 26 PostgreSQL B-tree index #25 Hard 27 PostgreSQL B-tree index #26 Medium 28 PostgreSQL B-tree index #27 Medium 29 PostgreSQL B-tree index #28 Hard 30 PostgreSQL B-tree index #29 Medium 31 PostgreSQL B-tree index #30 Medium