scaramouche  ~  psql service=swh-replica 
psql (10.1, server 10.0)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

softwareheritage=> \d origin
                            Table "public.origin"
 Column  |  Type  | Collation | Nullable |              Default               
---------+--------+-----------+----------+------------------------------------
 id      | bigint |           | not null | nextval('origin_id_seq'::regclass)
 type    | text   |           |          | 
 url     | text   |           | not null | 
 lister  | uuid   |           |          | 
 project | uuid   |           |          | 
Indexes:
    "origin_pkey" UNIQUE, btree (id)
    "origin_type_url_idx" btree (type, url)
    "origin_url_idx" gin (url gin_trgm_ops)

softwareheritage=> explain select id from origin where url='foo';
                                QUERY PLAN                                 
---------------------------------------------------------------------------
 Gather  (cost=1000.00..1047680.56 rows=1 width=8)
   Workers Planned: 2
   ->  Parallel Seq Scan on origin  (cost=0.00..1046680.46 rows=1 width=8)
         Filter: (url = 'foo'::text)
(4 rows)

softwareheritage=> explain select id from origin where url like '%foo%';
                                     QUERY PLAN                                      
-------------------------------------------------------------------------------------
 Bitmap Heap Scan on origin  (cost=5648.60..555112.94 rows=663045 width=8)
   Recheck Cond: (url ~~ '%foo%'::text)
   ->  Bitmap Index Scan on origin_url_idx  (cost=0.00..5482.84 rows=663045 width=0)
         Index Cond: (url ~~ '%foo%'::text)
(4 rows)

softwareheritage=>