QUERY PLAN
"Unique  (cost=10.81..10.83 rows=1 width=167) (actual time=19390.684..19390.687 rows=1 loops=1)"
"  ->  Sort  (cost=10.81..10.82 rows=1 width=167) (actual time=19390.678..19390.679 rows=1 loops=1)"
"        Sort Key: up.prefix, s.name, s.tuid, s.foundryversion"
"        ->  Nested Loop  (cost=9.75..10.80 rows=1 width=167) (actual time=19377.051..19390.391 rows=1 loops=1)"
"              Join Filter: ("outer".flow = "inner".dbid)"
"              ->  Hash Join  (cost=9.75..10.79 rows=1 width=171) (actual time=19173.684..19181.827 rows=770 loops=1)"
"                    Hash Cond: ("outer".dbid = "inner"."schema")"
"                    ->  Seq Scan on "schema" s  (cost=0.00..1.02 rows=2 width=128) (actual time=0.240..0.693 rows=20 loops=1)"
"                    ->  Hash  (cost=9.75..9.75 rows=1 width=51) (actual time=19173.354..19173.354 rows=0 loops=1)"
"                          ->  Nested Loop  (cost=0.00..9.75 rows=1 width=51) (actual time=30.456..19166.759 rows=770 loops=1)"
"                                Join Filter: ("inner"."usage" = "outer".dbid)"
"                                ->  Index Scan using usage_flow_i on "usage" u  (cost=0.00..4.78 rows=1 width=8) (actual time=0.593..9.576 rows=771 loops=1)"
"                                ->  Index Scan using usageparameter_schema_i on usageparameter up  (cost=0.00..4.96 rows=1 width=51) (actual time=16.171..22.411 rows=770 loops=771)"
"                                      Filter: ((prefix)::text <> 'xsd'::text)"
"              ->  Seq Scan on flow fl  (cost=0.00..0.00 rows=1 width=4) (actual time=0.007..0.260 rows=1 loops=770)"
"                    Filter: (servicetype = 646)"
"Total runtime: 19391.173 ms"