Nested Loop  (cost=1541.51..4713.92 rows=754 width=406) (actual time=334.337..342.656 rows=1 loops=1)

    Output: e.tags, e.data

    Join Filter: (uo.uo = latest_update_operations.id)

    Buffers: shared hit=1263

    ->  Limit  (cost=0.00..1.78 rows=1 width=8) (actual time=0.025..0.030 rows=1 loops=1)

          Output: latest_update_operations.id

          Buffers: shared hit=1

          ->  Seq Scan on public.latest_update_operations  (cost=0.00..1.78 rows=1 width=8) (actual time=0.021..0.023 rows=1 loops=1)

                Output: latest_update_operations.id

                Filter: ((latest_update_operations.updater = 'clair.cvss'::text) AND (latest_update_operations.kind = 'enrichment'::text))

                Rows Removed by Filter: 50

                Buffers: shared hit=1

    ->  Hash Join  (cost=1541.51..4702.72 rows=754 width=414) (actual time=334.307..342.613 rows=1 loops=1)

          Output: e.tags, e.data, uo.uo

          Inner Unique: true

          Hash Cond: (uo.enrich = e.id)

          Buffers: shared hit=1262

          ->  Seq Scan on public.uo_enrich uo  (cost=0.00..2765.27 rows=150827 width=16) (actual time=0.022..176.703 rows=150827 loops=1)

                Output: uo.uo, uo.enrich, uo.updater, uo.fingerprint, uo.date

               Buffers: shared hit=1257

         ->  Hash  (cost=1532.09..1532.09 rows=754 width=414) (actual time=0.104..0.112 rows=1 loops=1)

               Output: e.tags, e.data, e.id

               Buckets: 1024  Batches: 1  Memory Usage: 9kB

               Buffers: shared hit=5

               ->  Bitmap Heap Scan on public.enrichment e  (cost=15.05..1532.09 rows=754 width=414) (actual time=0.092..0.097 rows=1 loops=1)

                     Output: e.tags, e.data, e.id

                     Recheck Cond: (e.tags && '{CVE-2025-20164}'::text[])

                     Heap Blocks: exact=1

                     Buffers: shared hit=5

                     ->  Bitmap Index Scan on enrichment_tags_idx  (cost=0.00..14.86 rows=754 width=0) (actual time=0.070..0.071 rows=1 loops=1)

                           Index Cond: (e.tags && '{CVE-2025-20164}'::text[])

                           Buffers: shared hit=4

Query Identifier: 4835994851792681965

Planning:

   Buffers: shared hit=389

Planning Time: 1.506 ms

Execution Time: 342.785 ms

(37 rows)