とあるPostgreSQLのスロークエリ

Explain Analyze

                                                                                              QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=1568.27..1568.51 rows=96 width=260) (actual time=822.175..822.259 rows=198 loops=1)
   Sort Key: e.pgd, e.evtno, p.ptgno
   Sort Method:  quicksort  Memory: 100kB
   ->  Nested Loop  (cost=87.12..1565.11 rows=96 width=260) (actual time=15.763..821.403 rows=198 loops=1)
         ->  Nested Loop  (cost=87.12..1309.65 rows=96 width=256) (actual time=15.729..792.478 rows=198 loops=1)
               ->  Hash Join  (cost=87.12..1058.64 rows=96 width=256) (actual time=15.703..791.253 rows=198 loops=1)
                     Hash Cond: (e.grpsno = g.grpsno)
                     ->  Nested Loop  (cost=0.00..970.13 rows=112 width=226) (actual time=13.304..788.536 rows=198 loops=1)
                           ->  Nested Loop  (cost=0.00..680.36 rows=111 width=129) (actual time=13.282..786.911 rows=198 loops=1)
                                 ->  Nested Loop  (cost=0.00..69.49 rows=111 width=10) (actual time=13.221..275.439 rows=198 loops=1)
                                       ->  Nested Loop  (cost=0.00..46.76 rows=4 width=4) (actual time=13.171..218.500 rows=15 loops=1)
                                             ->  Index Scan using oifo_uano_index on oifo oi  (cost=0.00..21.43 rows=4 width=4) (actual time=13.123..194.165 rows=15 loops=1)
                                                   Index Cond: (uano = 103679)
                                                   Filter: ((createdday > '2010-01-01 00:00:00'::timestamp without time zone) AND (pmtsttsmstrno = 2))
                                             ->  Index Scan using odvifo_oifono on odvifo odi  (cost=0.00..6.32 rows=1 width=8) (actual time=1.617..1.618 rows=1 loops=15)
                                                   Index Cond: (odi.oifono = oi.oifono)
                                                   Filter: (odi.createdday > '2010-01-01 00:00:00'::timestamp without time zone)
                                       ->  Index Scan using odpt_odvifono on odpt op  (cost=0.00..4.87 rows=65 width=14) (actual time=3.767..3.778 rows=13 loops=15)
                                             Index Cond: (op.odvifono = odi.odvifono)
                                 ->  Index Scan using ptgrp_pk on ptgrp p  (cost=0.00..5.49 rows=1 width=123) (actual time=2.580..2.581 rows=1 loops=198)
                                       Index Cond: (p.ptgno = op.ptgno)
                                       Filter: ((p.createdday > '2010-01-01 00:00:00'::timestamp without time zone) AND (p.delflag = '0'::bpchar) AND (p.viewflag = '0'::bpchar))
                           ->  Index Scan using evt_cvtifo on evt e  (cost=0.00..2.60 rows=1 width=97) (actual time=0.005..0.005 rows=1 loops=198)
                                 Index Cond: (e.cvtifono = p.cvtifono)
                                 Filter: (e.delflag = '0'::bpchar)
                     ->  Hash  (cost=69.38..69.38 rows=1420 width=34) (actual time=2.376..2.376 rows=1420 loops=1)
                           ->  Seq Scan on groups g  (cost=0.00..69.38 rows=1420 width=34) (actual time=0.011..1.377 rows=1420 loops=1)
                                 Filter: (delflag = '0'::bpchar)
               ->  Index Scan using cvtifo_pk on cvtifo ci  (cost=0.00..2.60 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=198)
                     Index Cond: (ci.cvtifono = p.cvtifono)
                     Filter: (ci.delflag = '0'::bpchar)
         ->  Index Scan using ctgry_pk on ctgry c  (cost=0.00..2.65 rows=1 width=8) (actual time=0.143..0.144 rows=1 loops=198)
               Index Cond: (c.ctgryno = p.ctgryno)
               Filter: ((c.delflag = '0'::bpchar) AND (c.viewflag = '0'::bpchar))
 Total runtime: 822.580 ms
(35 行)