tpro company search 1

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
2104.340 100.00% 
 Hash Left Join (cost=108252.84..108270.78 rows=4 width=301) (actual time=2104.147..2104.340 rows=7 loops=1)
   Hash Cond: (company.id = c.id)
635.315 30.19% 
   -> Nested Loop (cost=4.3..19.96 rows=4 width=269) (actual time=635.263..635.315 rows=7 loops=1)
635.064 30.18% 
         -> Function Scan on plainto_tsquery ftsearch (cost=0.0..0.26 rows=1 width=32) (actual time=635.062..635.064 rows=1 loops=1)
0.217 0.01% 
         -> Bitmap Heap Scan on company (cost=4.3..19.65 rows=4 width=237) (actual time=0.188..0.217 rows=7 loops=1)
               Recheck Cond: (company.tsv @@ ftsearch.ftsearch)
0.163 0.01% 
               -> Bitmap Index Scan on company_tsv_fts (cost=0.0..4.3 rows=4 width=0) (actual time=0.163..0.163 rows=7 loops=1)
                     Index Cond: (company.tsv @@ ftsearch.ftsearch)
1468.850 69.80% 
   -> Hash (cost=108193.0..108193.0 rows=4443 width=36) (actual time=1468.850..1468.850 rows=4443 loops=1)
1458.596 69.31% 
         -> Subquery Scan c (cost=2.95..108193.0 rows=4443 width=36) (actual time=2.120..1458.596 rows=4443 loops=1)
1444.200 68.63% 
               -> Hash Left Join (cost=2.95..108148.57 rows=4443 width=397) (actual time=2.116..1444.200 rows=4443 loops=1)
                     Hash Cond: (c.tariffid_buyer = tb.tariffid)
36.941 1.76% 
                     -> Hash Left Join (cost=1.47..1321.99 rows=4443 width=363) (actual time=0.133..36.941 rows=4443 loops=1)
                           Hash Cond: (c.tariffid_seller = ts.tariffid)
20.414 0.97% 
                           -> Seq Scan on company c (cost=0.0..1259.43 rows=4443 width=329) (actual time=0.019..20.414 rows=4443 loops=1)
0.102 0.00% 
                           -> Hash (cost=1.21..1.21 rows=21 width=38) (actual time=0.102..0.102 rows=21 loops=1)
0.060 0.00% 
                                 -> Seq Scan on tariffs ts (cost=0.0..1.21 rows=21 width=38) (actual time=0.018..0.060 rows=21 loops=1)
0.082 0.00% 
                     -> Hash (cost=1.21..1.21 rows=21 width=38) (actual time=0.082..0.082 rows=21 loops=1)
0.043 0.00% 
                           -> Seq Scan on tariffs tb (cost=0.0..1.21 rows=21 width=38) (actual time=0.004..0.043 rows=21 loops=1)
                     SubPlan
88.860 4.22% 
                       -> Aggregate (cost=11.88..11.89 rows=1 width=0) (actual time=0.018..0.020 rows=1 loops=4443)
44.430 2.11% 
                             -> Bitmap Heap Scan on face (cost=4.27..11.87 rows=2 width=0) (actual time=0.008..0.010 rows=2 loops=4443)
                                   Recheck Cond: (companyid = $0)
17.772 0.84% 
                                   -> Bitmap Index Scan on face_companyid_idx (cost=0.0..4.27 rows=2 width=0) (actual time=0.004..0.004 rows=2 loops=4443)
                                         Index Cond: (companyid = $0)
79.974 3.80% 
                       -> Aggregate (cost=11.88..11.89 rows=1 width=0) (actual time=0.017..0.018 rows=1 loops=4443)
48.873 2.32% 
                             -> Bitmap Heap Scan on face (cost=4.27..11.87 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=4443)
                                   Recheck Cond: (companyid = $0)
                                   Filter: (status = 0)
22.215 1.06% 
                                   -> Bitmap Index Scan on face_companyid_idx (cost=0.0..4.27 rows=2 width=0) (actual time=0.005..0.005 rows=2 loops=4443)
                                         Index Cond: (companyid = $0)