Table "public.outputs"
  Column   |   Type   |                      Modifiers                       | Storage  | Stats target | Description
-----------+----------+------------------------------------------------------+----------+--------------+-------------
 id        | integer  | not null default nextval('outputs_id_seq'::regclass) | plain    |              |
 trx_id    | integer  |                                                      | plain    |              |
 addresses | bigint[] | default '{}'::bigint[]                               | extended |              |
 position  | integer  |                                                      | plain    |              |
 amount    | bigint   | default 0                                            | plain    |              |
 spent     | boolean  | default false                                        | plain    |              |
Indexes:
    "outputs_pkey" PRIMARY KEY, btree (id)
    "index_outputs_on_addresses" btree (addresses)
    "index_outputs_on_trx_id" btree (trx_id)
    "index_outputs_on_trx_id_and_position" btree (trx_id, "position")

prometheus=> explain analyze SELECT  "outputs".* FROM "outputs" WHERE "outputs"."trx_id" = 10212713 AND "outputs"."position" = 0 LIMIT 1;
                                                                 QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.56..0.98 rows=1 width=50) (actual time=12.096..12.096 rows=1 loops=1)
   ->  Index Scan using index_outputs_on_trx_id on outputs  (cost=0.56..17.91 rows=42 width=50) (actual time=12.096..12.096 rows=1 loops=1)
         Index Cond: (trx_id = 10212713)
         Filter: ("position" = 0)
         Rows Removed by Filter: 1
 Planning time: 0.045 ms
 Execution time: 12.107 ms
(7 rows)

UPDATE "outputs" SET "spent" = 't' WHERE "outputs"."id" IN (37608707,....примерно 600 ид);

--------------------------------------------------------------------------------------------------------------------------------------------
 Update on outputs  (cost=1.28..3016.85 rows=577 width=55) (actual time=14.439..14.439 rows=0 loops=1)
   ->  Index Scan using outputs_pkey on outputs  (cost=1.28..3016.85 rows=577 width=55) (actual time=0.091..11.570 rows=577 loops=1)
         Index Cond: (id = ANY ('{37608707,40562950,...,49040473}'::integer[]))
 Planning time: 0.692 ms
 Execution time: 14.537 ms
(5 rows)