Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- explain verbose select * from mrozonka.sb_preselect p where date_trunc('day'::text, p.dt::timestamp without time zone) = '2018-02-19'::timestamp without time zone;
- QUERY PLAN
- -----------------------------------------------------------------------------------------------------
- Foreign Scan on mrozonka.sb_preselect p (cost=100.00..131.30 rows=3 width=108)
- Output: id, access, dt, ean, gsklep, price, qty, val, arseq
- Filter: (date_trunc('day'::text, p.dt) = '2018-02-19 00:00:00'::timestamp without time zone)
- Remote SQL: SELECT id, access, dt, ean, gsklep, price, qty, val, arseq FROM mrozonka.sb_preselect
- (4 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement