---

Sql="SELECT
CAST(T1._Fld27110 AS MVARCHAR(30)),
T1._IDRRef,
'ВЫБОРКА СЕРИЙ'::mvarcharф
FROM _Reference314 T1
WHERE ((T1._Fld1345 = CAST(0 AS NUMERIC))) AND (T1._Fld27110 IN
(SELECT
T2._Q_001_F_000 AS Q_002_F_000_
FROM pg_temp.tt65 T2))",planSQLText="Nested Loop  (cost=58.28..6232095.28 rows=1 width=81) (actual time=1.784..17.343 rows=3000 loops=1)
  Output: (t1._fld27110)::mvarchar(30), t1._idrref, 'ВЫБОРКА СЕРИЙ'::mvarchar
  Buffers: shared hit=15841, local hit=25
  ->  HashAggregate  (cost=58.00..88.00 rows=3000 width=35) (actual time=1.766..2.051 rows=3000 loops=1)
        Output: t2._q_001_f_000
        Group Key: t2._q_001_f_000
        Batches: 1  Memory Usage: 369kB
        Buffers: local hit=25
        ->  Seq Scan on pg_temp.tt65 t2  (cost=0.00..55.00 rows=3000 width=35) (actual time=0.005..0.156 rows=3000 loops=1)
              Output: t2._q_001_f_000
              Buffers: local hit=25
  ->  Index Only Scan using _reference314_4 on public._reference314 t1  (cost=0.28..1583.35 rows=49399 width=51) (actual time=0.005..0.005 rows=1 loops=3000)
        Output: t1._fld1345, t1._fld27110, t1._description, t1._idrref, t1._marked, t1._fld27108
        Index Cond: ((t1._fld1345 = '0'::numeric) AND (t1._fld27110 = t2._q_001_f_000))
        Heap Fetches: 0
        Buffers: shared hit=15841
Query Identifier: -7846548482577455867
Planning:
  Buffers: shared hit=18, local hit=1
Planning Time: 0.338 ms
Execution Time: 17.461 ms


SELECT
CAST(T1._Fld27110 AS MVARCHAR(30)),
T1._IDRRef,
'ВЫБОРКА СЕРИЙ'::mvarchar
FROM _Reference314 T1
WHERE ((T1._Fld1345 = CAST(0 AS NUMERIC))) AND (T1._Fld27110 IN
(SELECT
T2._Q_001_F_000 AS Q_002_F_000_
FROM pg_temp.tt10 T2))",planSQLText="Hash Semi Join  (cost=147.28..7190995.84 rows=1 width=81) (actual time=14.856..105934.684 rows=5000 loops=1)
  Output: (t1._fld27110)::mvarchar(30), t1._idrref, 'ВЫБОРКА СЕРИЙ'::mvarchar
  Hash Cond: (t1._fld27110 = t2._q_001_f_000)
  Buffers: shared hit=26007171 read=31 dirtied=186, local hit=42
  I/O Timings: shared read=0.112
  ->  Index Only Scan using _reference314_4 on public._reference314 t1  (cost=0.28..6990791.17 rows=190531118 width=51) (actual time=0.014..25804.034 rows=190502540 loops=1)
        Output: t1._fld1345, t1._fld27110, t1._description, t1._idrref, t1._marked, t1._fld27108
        Index Cond: (t1._fld1345 = '0'::numeric)
        Heap Fetches: 1836442
        Buffers: shared hit=26007171 read=31 dirtied=186
        I/O Timings: shared read=0.112
  ->  Hash  (cost=92.00..92.00 rows=5000 width=35) (actual time=2.533..2.534 rows=5000 loops=1)
        Output: t2._q_001_f_000
        Buckets: 8192  Batches: 1  Memory Usage: 392kB
        Buffers: local hit=42
        ->  Seq Scan on pg_temp.tt10 t2  (cost=0.00..92.00 rows=5000 width=35) (actual time=0.005..0.310 rows=5000 loops=1)
              Output: t2._q_001_f_000
              Buffers: local hit=42
Query Identifier: 6656754341238614127
Planning:
  Buffers: shared hit=18, local hit=1
Planning Time: 0.278 ms
Execution Time: 105934.975 ms