Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sort (cost=117212470.49..117212475.55 rows=2023 width=135)
- Sort Key: invoice.sl_name, invoice.origin_loc_display_name, invoice.origin_loc_pcode, invoice.cv_name, (count(DISTINCT invoice.id))
- -> GroupAggregate (cost=59023.42..117212359.41 rows=2023 width=135)
- -> Sort (cost=59023.42..59048.71 rows=10115 width=135)
- 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
- -> Seq Scan on invoice (cost=0.00..57657.56 rows=10115 width=135)
- 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[])))
- SubPlan
- -> Aggregate (cost=57910.48..57910.49 rows=1 width=8)
- -> Seq Scan on invoice i2 (cost=0.00..57910.44 rows=6 width=8)
- 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[])))
- (11 rows)
Add Comment
Please, Sign In to add comment