-- хорошо
select *
from main.account
where owner_id = 12345 and code = 2411::int2 and currency = 'TEST'

--Index Scan using account_owner_id_code_currency_idx on account a  (cost=0.43..4.67 rows=3 width=140) (actual time=0.079..0.081 rows=1 loops=1)
--  Index Cond: ((owner_id = '12345'::bigint) AND (code = '2411'::smallint) AND (currency = 'TEST'::text))
--Planning Time: 0.135 ms
--Execution Time: 0.115 ms


-- почему так?
select *
from main.account a
  join main.post p on p.debit_id = a.id
where a.owner_id = 12345 and a.code = 2411::int2 and a.currency = 'TEST'

--Gather  (cost=1000.71..8769077.25 rows=2140 width=201) (actual time=1759.120..1764.689 rows=0 loops=1)
--  Workers Planned: 2
--  Workers Launched: 2
--  ->  Nested Loop  (cost=0.70..8767863.25 rows=892 width=201) (actual time=1735.726..1735.727 rows=0 loops=3)
--        ->  Parallel Seq Scan on account a  (cost=0.00..103251.04 rows=1 width=140) (actual time=1732.715..1735.699 rows=0 loops=3)
--              Filter: ((owner_id = '12345'::bigint) AND (code = '2411'::smallint) AND (currency = 'TEST'::text))
--              Rows Removed by Filter: 1215308
--        ->  Index Scan using post_0_0_debit_id_ts_idx on post_0_0 p  (cost=0.70..8580683.44 rows=8392877 width=61) (actual time=0.055..0.055 rows=0 loops=1)
--              Index Cond: (debit_id = a.id)
--Planning Time: 0.729 ms
--JIT:
--  Functions: 24
--  Options: Inlining true, Optimization true, Expressions true, Deforming true
--  Timing: Generation 5.994 ms, Inlining 318.341 ms, Optimization 444.522 ms, Emission 305.928 ms, Total 1074.786 ms
--Execution Time: 1766.207 ms


-- снова хорошо
with a as materialized
(
  select *
  from main.account
  where owner_id = 12345 and code = 2411::int2 and currency = 'TEST'
)
select *
from a
  join main.post p on p.debit_id = a.id

--Nested Loop  (cost=5.37..25993541.06 rows=30273492 width=275) (actual time=170.289..170.291 rows=0 loops=1)
--  CTE a
--    ->  Index Scan using account_owner_id_code_currency_idx on account a_1  (cost=0.43..4.67 rows=3 width=140) (actual time=0.054..0.056 rows=1 loops=1)
--          Index Cond: ((owner_id = '12345'::bigint) AND (code = '2411'::smallint) AND (currency = 'TEST'::text))
--  ->  CTE Scan on a  (cost=0.00..0.06 rows=3 width=214) (actual time=0.055..0.058 rows=1 loops=1)
--  ->  Index Scan using post_0_0_debit_id_ts_idx on post_0_0 p  (cost=0.70..8580582.36 rows=8392975 width=61) (actual time=0.066..0.067 rows=0 loops=1)
--        Index Cond: (debit_id = a.id)
--Planning Time: 0.218 ms
--JIT:
--  Functions: 8
--  Options: Inlining true, Optimization true, Expressions true, Deforming true
--  Timing: Generation 1.226 ms, Inlining 8.509 ms, Optimization 80.447 ms, Emission 81.031 ms, Total 171.213 ms
--Execution Time: 171.586 ms