Advertisement
Guest User

Untitled

a guest
Jul 20th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. 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;
  2. QUERY PLAN
  3. -----------------------------------------------------------------------------------------------------
  4. Foreign Scan on mrozonka.sb_preselect p (cost=100.00..131.30 rows=3 width=108)
  5. Output: id, access, dt, ean, gsklep, price, qty, val, arseq
  6. Filter: (date_trunc('day'::text, p.dt) = '2018-02-19 00:00:00'::timestamp without time zone)
  7. Remote SQL: SELECT id, access, dt, ean, gsklep, price, qty, val, arseq FROM mrozonka.sb_preselect
  8. (4 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement