[Tom Lane]
> EXPLAIN ANALYZE doesn't account for all of the runtime involved. In
> this case, I'd bet that session startup/shutdown is a big part of the
> difference.
The session startup/shutdown should be the same for the real SQL and
the broken SQL, shouldn't it?
[Artur Zając]
> time psql -c 'explain analyze SELECT te.idt FROM t_positions AS te
> JOIN t_st AS stm ON (te.idt=stm.idt AND 4=stm.idm) WHERE te.idtr IN
> (347186)'
Is this weidness only observed for this query? What happens with
other queries? "explain analyze select 1"? "explain analyze select *
from t_positions where idtr=347816"? plain select without "explain
analyze"? etc?