QUERY PLAN
"Unique  (cost=11.50..11.52 rows=2 width=131) (actual time=0.724..0.727 rows=1 loops=1)"
"  ->  Sort  (cost=11.50..11.50 rows=2 width=131) (actual time=0.722..0.723 rows=1 loops=1)"
"        Sort Key: up.prefix, s.name, s.tuid, s.foundryversion"
"        ->  Hash Join  (cost=10.42..11.49 rows=2 width=131) (actual time=0.551..0.670 rows=1 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.027..0.129 rows=20 loops=1)"
"              ->  Hash  (cost=10.41..10.41 rows=4 width=11) (actual time=0.478..0.478 rows=0 loops=1)"
"                    ->  Nested Loop  (cost=0.00..10.41 rows=4 width=11) (actual time=0.355..0.455 rows=1 loops=1)"
"                          ->  Nested Loop  (cost=0.00..2.14 rows=4 width=4) (actual time=0.179..0.249 rows=3 loops=1)"
"                                ->  Seq Scan on flow fl  (cost=0.00..0.00 rows=1 width=4) (actual time=0.057..0.112 rows=1 loops=1)"
"                                      Filter: (servicetype = 646)"
"                                ->  Index Scan using usage_flow_i on "usage" u  (cost=0.00..2.06 rows=6 width=8) (actual time=0.115..0.121 rows=3 loops=1)"
"                                      Index Cond: (u.flow = "outer".dbid)"
"                          ->  Index Scan using usageparameter_usage_i on usageparameter up  (cost=0.00..2.06 rows=1 width=15) (actual time=0.044..0.046 rows=0 loops=3)"
"                                Index Cond: (up."usage" = "outer".dbid)"
"                                Filter: ((prefix)::text <> 'xsd'::text)"
"Total runtime: 0.842 ms"