Nested Loop  (cost=37.49..3804.72 rows=632 width=406) (actual time=2.624..2.656 rows=1 loops=1)

    Output: e.tags, e.data

    Buffers: shared hit=1 read=17

    I/O Timings: shared read=1.564

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

          Output: latest_update_operations.id

          Buffers: shared read=1

          I/O Timings: shared read=0.037

          ->  Seq Scan on public.latest_update_operations  (cost=0.00..1.78 rows=1 width=8) (actual time=0.072..0.073 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: 47

                Buffers: shared read=1

                I/O Timings: shared read=0.037

    ->  Nested Loop  (cost=37.49..3795.37 rows=757 width=414) (actual time=2.538..2.556 rows=1 loops=1)

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

          Buffers: shared hit=1 read=16

          I/O Timings: shared read=1.526

          ->  Bitmap Heap Scan on public.enrichment e  (cost=37.07..1560.33 rows=757 width=414) (actual time=2.322..2.329 rows=1 loops=1)

                Output: e.id, e.hash_kind, e.hash, e.updater, e.tags, e.data

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

                Heap Blocks: exact=1

               Buffers: shared hit=1 read=12

               I/O Timings: shared read=1.437

               ->  Bitmap Index Scan on enrichment_tags_idx  (cost=0.00..36.88 rows=757 width=0) (actual time=2.284..2.286 rows=1 loops=1)

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

                     Buffers: shared hit=1 read=11

                     I/O Timings: shared read=1.418

         ->  Index Only Scan using uo_enrich_pkey on public.uo_enrich uo  (cost=0.42..2.94 rows=1 width=16) (actual time=0.203..0.207 rows=1 loops=1)

               Output: uo.uo, uo.enrich

               Index Cond: ((uo.uo = latest_update_operations.id) AND (uo.enrich = e.id))

               Heap Fetches: 0

               Buffers: shared read=4

               I/O Timings: shared read=0.090

Query Identifier: 4534832060290292843

Planning:

   Buffers: shared hit=339 read=49

   I/O Timings: shared read=15.268

Planning Time: 19.761 ms

Execution Time: 2.963 ms

(40 rows)