Seq Scan on s  (cost=22.76..4348.82 rows=340 width=212) (actual time=0.053..0.090 rows=5 loops=1)
   InitPlan 2 (returns $1)
     ->  Aggregate  (cost=22.75..22.76 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)
           ->  Seq Scan on sp sp_1  (cost=0.00..20.20 rows=1020 width=4) (actual time=0.001..0.002 rows=12 loops=1)
   SubPlan 1
     ->  Aggregate  (cost=12.67..12.68 rows=1 width=4) (actual time=0.012..0.013 rows=1 loops=5)
           ->  Bitmap Heap Scan on sp  (cost=4.19..12.66 rows=5 width=4) (actual time=0.009..0.009 rows=2 loops=5)
                 Recheck Cond: ((sno)::text = (s.sno)::text)
                 Heap Blocks: exact=4
                 ->  Bitmap Index Scan on sp_pkey  (cost=0.00..4.19 rows=5 width=0) (actual time=0.007..0.007 rows=2 loops=5)
                       Index Cond: ((sno)::text = (s.sno)::text)

user_indexes