eVl <evl(dot)evl(at)gmail(dot)com> writes:
> When executing this SELECT (see SELECT.A above) it executes in about 700 ms, but when I want wipe out all info about local traffic, with query like this:
> SELECT * FROM ( SELECT.A ) a WHERE type = 'global';
> It executes about 10000 ms - more then 10 TIMES SLOWER!
> Why this could be?
You tell us --- let's see EXPLAIN ANALYZE results for both cases.
regards, tom lane