Guest User

Untitled

a guest
Jul 20th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. Sort (cost=117212470.49..117212475.55 rows=2023 width=135)
  2. Sort Key: invoice.sl_name, invoice.origin_loc_display_name, invoice.origin_loc_pcode, invoice.cv_name, (count(DISTINCT invoice.id))
  3. -> GroupAggregate (cost=59023.42..117212359.41 rows=2023 width=135)
  4. -> Sort (cost=59023.42..59048.71 rows=10115 width=135)
  5. Sort Key: invoice.sl_name, invoice.origin_loc_display_name, invoice.origin_loc_pcode, invoice.cv_name, invoice.destin_loc_pcode, invoice.carrier_name, invoice.has_notes
  6. -> Seq Scan on invoice (cost=0.00..57657.56 rows=10115 width=135)
  7. Filter: ((invoice_date >= '2009-01-01'::date) AND (invoice_date <= '2009-12-30'::date) AND (direction = ANY ('{2,5}'::integer[])) AND (currency_id = 1) AND ((mode_name)::text = 'TL'::text) AND (invoice_status = ANY ('{1,2,3,4,5,6}'::bigint[])))
  8. SubPlan
  9. -> Aggregate (cost=57910.48..57910.49 rows=1 width=8)
  10. -> Seq Scan on invoice i2 (cost=0.00..57910.44 rows=6 width=8)
  11. Filter: ((direction = ANY ('{2,5}'::integer[])) AND (invoice_date >= '2009-01-01'::date) AND (invoice_date <= '2009-12-30'::date) AND (($0)::text = (origin_loc_display_name)::text) AND (($1)::text = (sl_name)::text) AND ((mode_name)::text = 'TL'::text) AND (invoice_status = ANY ('{1,2,3,4,5,6}'::bigint[])))
  12. (11 rows)
Add Comment
Please, Sign In to add comment