tpro company search

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
1174.833 100.00% 
 Sort (cost=151.71..151.72 rows=4 width=177) (actual time=1174.833..1174.833 rows=0 loops=1)
   Sort Key: t.testing, t.sort, t.title
   Sort Method:  quicksort  Memory: 17kB
1174.801 100.00% 
   -> Subquery Scan t (cost=20.07..151.67 rows=4 width=177) (actual time=1174.801..1174.801 rows=0 loops=1)
1174.797 100.00% 
         -> Nested Loop Left Join (cost=20.07..151.61 rows=4 width=417) (actual time=1174.797..1174.797 rows=0 loops=1)
1174.793 100.00% 
               -> Nested Loop Left Join (cost=20.07..54.36 rows=4 width=383) (actual time=1174.793..1174.793 rows=0 loops=1)
1174.790 100.00% 
                     -> Nested Loop (cost=20.07..53.23 rows=4 width=349) (actual time=1174.790..1174.790 rows=0 loops=1)
1174.786 100.00% 
                           -> HashAggregate (cost=20.07..20.11 rows=4 width=4) (actual time=1174.786..1174.786 rows=0 loops=1)
1174.782 100.00% 
                                 -> Limit (cost=20.01..20.02 rows=4 width=257) (actual time=1174.782..1174.782 rows=0 loops=1)
1174.777 100.00% 
                                       -> Sort (cost=20.01..20.02 rows=4 width=257) (actual time=1174.777..1174.777 rows=0 loops=1)
                                             Sort Key: (ts_rank_cd('{0.1,0.2,0.3,1}'::real[], c.tsv, ftsearch.ftsearch, 20))
                                             Sort Method:  quicksort  Memory: 17kB
1174.757 99.99% 
                                             -> Nested Loop (cost=4.3..19.97 rows=4 width=257) (actual time=1174.757..1174.757 rows=0 loops=1)
1174.676 99.99% 
                                                   -> Function Scan on plainto_tsquery ftsearch (cost=0.0..0.26 rows=1 width=32) (actual time=1174.674..1174.676 rows=1 loops=1)
0.063 0.01% 
                                                   -> Bitmap Heap Scan on company c (cost=4.3..19.64 rows=4 width=225) (actual time=0.063..0.063 rows=0 loops=1)
                                                         Recheck Cond: (c.tsv @@ ftsearch.ftsearch)
0.058 0.00% 
                                                         -> Bitmap Index Scan on company_tsv_fts (cost=0.0..4.29 rows=4 width=0) (actual time=0.058..0.058 rows=0 loops=1)
                                                               Index Cond: (c.tsv @@ ftsearch.ftsearch)
0.000 0.00% 
                           -> Index Scan using company_id_pkey on company c (never executed)
                                 Index Cond: (c.id = c.id)
0.000 0.00% 
                     -> Index Scan using tariffs_pkey on tariffs ts (never executed)
                           Index Cond: (ts.tariffid = c.tariffid_seller)
0.000 0.00% 
               -> Index Scan using tariffs_pkey on tariffs tb (never executed)
                     Index Cond: (tb.tariffid = c.tariffid_buyer)
               SubPlan
0.000 0.00% 
                 -> Aggregate (never executed)
0.000 0.00% 
                       -> Bitmap Heap Scan on face (never executed)
                             Recheck Cond: (companyid = $0)
0.000 0.00% 
                             -> Bitmap Index Scan on face_companyid_idx (never executed)
                                   Index Cond: (companyid = $0)
0.000 0.00% 
                 -> Aggregate (never executed)
0.000 0.00% 
                       -> Bitmap Heap Scan on face (never executed)
                             Recheck Cond: (companyid = $0)
                             Filter: (status = 0)
0.000 0.00% 
                             -> Bitmap Index Scan on face_companyid_idx (never executed)
                                   Index Cond: (companyid = $0)