#	exclusive	inclusive	rows x	rows	loops	node
1.	1.758	233.963	↑ 1.0	516	1	→ Sort (cost=7164.37..7165.66 rows=517 width=357) (actual time=233.346..233.963 rows=516 loops=1) Sort Key: a.eventtime Sort Method: quicksort Memory: 125kB
2.	2.472	232.205	↑ 1.0	516	1	→ HashAggregate (cost=7135.90..7141.07 rows=517 width=357) (actual time=231.347..232.205 rows=516 loops=1)
3.	1.278	229.733	↑ 1.0	516	1	→ Append (cost=99.90..7116.51 rows=517 width=357) (actual time=0.233..229.733 rows=516 loops=1)
4.	6.097	41.792	↓ 1.0	386	1	→ Hash Left Join (cost=99.90..3090.19 rows=384 width=382) (actual time=0.229..41.792 rows=386 loops=1) Hash Cond: (a.activebusystatus = d.activebusystatus)
5.	2.136	35.673	↓ 1.0	386	1	→ Hash Left Join (cost=76.17..2863.43 rows=384 width=288) (actual time=0.152..35.673 rows=386 loops=1) Hash Cond: ((a.cmdtype = t.cmdtype) AND (a.opcode = t.opcode))
6.	1.101	33.488	↓ 1.0	386	1	→ Hash Left Join (cost=47.67..2761.90 rows=384 width=224) (actual time=0.092..33.488 rows=386 loops=1) Hash Cond: (a.calltype = c.calltype)
7.	1.126	32.364	↓ 1.0	386	1	→ Hash Left Join (cost=17.88..2726.82 rows=384 width=168) (actual time=0.059..32.364 rows=386 loops=1) Hash Cond: (a.sourceradiorbsid = b.rbsid)
8.	0.947	31.214	↓ 1.0	386	1	→ Append (cost=0.00..2703.66 rows=384 width=70) (actual time=0.024..31.214 rows=386 loops=1)
9.	0.002	0.002	↓ 0.0	0	1	→ Seq Scan on rcs_radiotraffic a (cost=0.00..12.50 rows=1 width=156) (actual time=0.002..0.002 rows=0 loops=1) Filter: (talkgroupid = 405203)
10.	30.259	30.259	↓ 1.0	386	1	→ Seq Scan on rcs_radiotraffic_20120202 a (cost=0.00..2641.16 rows=379 width=69) (actual time=0.016..30.259 rows=386 loops=1) Filter: (talkgroupid = 405203)
11.	0.002	0.002	↓ 0.0	0	1	→ Seq Scan on rcs_radiotraffic_20120203 a (cost=0.00..12.50 rows=1 width=156) (actual time=0.002..0.002 rows=0 loops=1) Filter: (talkgroupid = 405203)
12.	0.002	0.002	↓ 0.0	0	1	→ Seq Scan on rcs_radiotraffic_20120204 a (cost=0.00..12.50 rows=1 width=156) (actual time=0.002..0.002 rows=0 loops=1) Filter: (talkgroupid = 405203)
13.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on rcs_radiotraffic_20120205 a (cost=0.00..12.50 rows=1 width=156) (actual time=0.001..0.001 rows=0 loops=1) Filter: (talkgroupid = 405203)
14.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on rcs_radiotraffic_20120206 a (cost=0.00..12.50 rows=1 width=156) (actual time=0.001..0.001 rows=0 loops=1) Filter: (talkgroupid = 405203)
15.	0.013	0.024	↑ 58.3	6	1	→ Hash (cost=13.50..13.50 rows=350 width=102) (actual time=0.024..0.024 rows=6 loops=1)
16.	0.011	0.011	↑ 58.3	6	1	→ Seq Scan on rcs_basestation b (cost=0.00..13.50 rows=350 width=102) (actual time=0.004..0.011 rows=6 loops=1)
17.	0.012	0.023	↑ 146.7	6	1	→ Hash (cost=18.80..18.80 rows=880 width=62) (actual time=0.023..0.023 rows=6 loops=1)
18.	0.011	0.011	↑ 146.7	6	1	→ Seq Scan on rcs_refcalltype c (cost=0.00..18.80 rows=880 width=62) (actual time=0.003..0.011 rows=6 loops=1)
19.	0.026	0.049	↑ 46.2	16	1	→ Hash (cost=17.40..17.40 rows=740 width=80) (actual time=0.049..0.049 rows=16 loops=1)
20.	0.023	0.023	↑ 46.2	16	1	→ Seq Scan on rcs_refcmdtype t (cost=0.00..17.40 rows=740 width=80) (actual time=0.003..0.023 rows=16 loops=1)
21.	0.011	0.022	↑ 101.7	6	1	→ Hash (cost=16.10..16.10 rows=610 width=102) (actual time=0.022..0.022 rows=6 loops=1)
22.	0.011	0.011	↑ 101.7	6	1	→ Seq Scan on rcs_refactivebusy d (cost=0.00..16.10 rows=610 width=102) (actual time=0.003..0.011 rows=6 loops=1)
23.	0.350	186.663	↑ 1.0	130	1	→ Subquery Scan "SELECT 2" (cost=2974.54..4022.48 rows=133 width=286) (actual time=25.690..186.663 rows=130 loops=1)
24.	2.241	186.313	↑ 1.0	130	1	→ Hash Join (cost=2974.54..4021.15 rows=133 width=286) (actual time=25.684..186.313 rows=130 loops=1) Hash Cond: (a.calltype = c.calltype)
25.	0.397	184.045	↑ 1.0	130	1	→ Nested Loop (cost=2944.74..3921.02 rows=133 width=230) (actual time=25.587..184.045 rows=130 loops=1)
26.	0.016	0.016	↑ 1.0	1	1	→ Index Scan using rcs_refcmdtype_pkey on rcs_refcmdtype t (cost=0.00..8.27 rows=1 width=76) (actual time=0.012..0.016 rows=1 loops=1) Index Cond: ((cmdtype = 7) AND (opcode = 1))
27.	0.390	183.632	↑ 1.0	130	1	→ Hash Join (cost=2944.74..3911.42 rows=133 width=162) (actual time=25.506..183.632 rows=130 loops=1) Hash Cond: (a.sourceradiorbsid = b.rbsid)
28.	41.033	183.215	↓ 1.0	135	1	→ Hash Join (cost=2926.86..3891.72 rows=133 width=64) (actual time=25.464..183.215 rows=135 loops=1) Hash Cond: ((e.callno = a.callno) AND (e.starttime = a.starttime))
29.	73.833	116.954	↑ 1.2	31830	1	→ Append (cost=0.00..672.30 rows=38830 width=24) (actual time=0.014..116.954 rows=31830 loops=1)
30.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on rcs_endofcall e (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
31.	43.115	43.115	↑ 1.0	31830	1	→ Seq Scan on rcs_endofcall_20120202 e (cost=0.00..552.30 rows=31830 width=24) (actual time=0.007..43.115 rows=31830 loops=1)
32.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on rcs_endofcall_20120203 e (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
33.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on rcs_endofcall_20120204 e (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
34.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on rcs_endofcall_20120205 e (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
35.	0.002	0.002	↓ 0.0	0	1	→ Seq Scan on rcs_endofcall_20120206 e (cost=0.00..24.00 rows=1400 width=24) (actual time=0.002..0.002 rows=0 loops=1)
36.	0.879	25.228	↑ 1.0	135	1	→ Hash (cost=2924.81..2924.81 rows=137 width=60) (actual time=25.228..25.228 rows=135 loops=1)
37.	0.365	24.349	↑ 1.0	136	1	→ Append (cost=0.00..2924.81 rows=137 width=60) (actual time=0.064..24.349 rows=136 loops=1)
38.	0.005	0.005	↓ 0.0	0	1	→ Index Scan using rcs_radiotraffic_pkey on rcs_radiotraffic a (cost=0.00..9.76 rows=1 width=144) (actual time=0.005..0.005 rows=0 loops=1) Index Cond: (opcode = 1) Filter: (talkgroupid = 405203)
39.	23.963	23.963	↓ 1.0	136	1	→ Seq Scan on rcs_radiotraffic_20120202 a (cost=0.00..2875.99 rows=132 width=57) (actual time=0.052..23.963 rows=136 loops=1) Filter: ((opcode = 1) AND (talkgroupid = 405203))
40.	0.007	0.007	↓ 0.0	0	1	→ Index Scan using rcs_radiotraffic_20120203_pkey on rcs_radiotraffic_20120203 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.007..0.007 rows=0 loops=1) Index Cond: (opcode = 1) Filter: (talkgroupid = 405203)
41.	0.003	0.003	↓ 0.0	0	1	→ Index Scan using rcs_radiotraffic_20120204_pkey on rcs_radiotraffic_20120204 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.003..0.003 rows=0 loops=1) Index Cond: (opcode = 1) Filter: (talkgroupid = 405203)
42.	0.003	0.003	↓ 0.0	0	1	→ Index Scan using rcs_radiotraffic_20120205_pkey on rcs_radiotraffic_20120205 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.003..0.003 rows=0 loops=1) Index Cond: (opcode = 1) Filter: (talkgroupid = 405203)
43.	0.003	0.003	↓ 0.0	0	1	→ Index Scan using rcs_radiotraffic_20120206_pkey on rcs_radiotraffic_20120206 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.003..0.003 rows=0 loops=1) Index Cond: (opcode = 1) Filter: (talkgroupid = 405203)
44.	0.013	0.027	↑ 58.3	6	1	→ Hash (cost=13.50..13.50 rows=350 width=102) (actual time=0.027..0.027 rows=6 loops=1)
45.	0.014	0.014	↑ 58.3	6	1	→ Seq Scan on rcs_basestation b (cost=0.00..13.50 rows=350 width=102) (actual time=0.005..0.014 rows=6 loops=1)
46.	0.015	0.027	↑ 146.7	6	1	→ Hash (cost=18.80..18.80 rows=880 width=62) (actual time=0.027..0.027 rows=6 loops=1)
47.	0.012	0.012	↑ 146.7	6	1	→ Seq Scan on rcs_refcalltype c (cost=0.00..18.80 rows=880 width=62) (actual time=0.004..0.012 rows=6 loops=1)

QUERY PLAN
Sort  (cost=7164.37..7165.66 rows=517 width=357) (actual time=233.346..233.963 rows=516 loops=1)
  Sort Key: a.eventtime
  Sort Method:  quicksort  Memory: 125kB
  ->  HashAggregate  (cost=7135.90..7141.07 rows=517 width=357) (actual time=231.347..232.205 rows=516 loops=1)
        ->  Append  (cost=99.90..7116.51 rows=517 width=357) (actual time=0.233..229.733 rows=516 loops=1)
              ->  Hash Left Join  (cost=99.90..3090.19 rows=384 width=382) (actual time=0.229..41.792 rows=386 loops=1)
                    Hash Cond: (a.activebusystatus = d.activebusystatus)
                    ->  Hash Left Join  (cost=76.17..2863.43 rows=384 width=288) (actual time=0.152..35.673 rows=386 loops=1)
                          Hash Cond: ((a.cmdtype = t.cmdtype) AND (a.opcode = t.opcode))
                          ->  Hash Left Join  (cost=47.67..2761.90 rows=384 width=224) (actual time=0.092..33.488 rows=386 loops=1)
                                Hash Cond: (a.calltype = c.calltype)
                                ->  Hash Left Join  (cost=17.88..2726.82 rows=384 width=168) (actual time=0.059..32.364 rows=386 loops=1)
                                      Hash Cond: (a.sourceradiorbsid = b.rbsid)
                                      ->  Append  (cost=0.00..2703.66 rows=384 width=70) (actual time=0.024..31.214 rows=386 loops=1)
                                            ->  Seq Scan on rcs_radiotraffic a  (cost=0.00..12.50 rows=1 width=156) (actual time=0.002..0.002 rows=0 loops=1)
                                                  Filter: (talkgroupid = 405203)
                                            ->  Seq Scan on rcs_radiotraffic_20120202 a  (cost=0.00..2641.16 rows=379 width=69) (actual time=0.016..30.259 rows=386 loops=1)
                                                  Filter: (talkgroupid = 405203)
                                            ->  Seq Scan on rcs_radiotraffic_20120203 a  (cost=0.00..12.50 rows=1 width=156) (actual time=0.002..0.002 rows=0 loops=1)
                                                  Filter: (talkgroupid = 405203)
                                            ->  Seq Scan on rcs_radiotraffic_20120204 a  (cost=0.00..12.50 rows=1 width=156) (actual time=0.002..0.002 rows=0 loops=1)
                                                  Filter: (talkgroupid = 405203)
                                            ->  Seq Scan on rcs_radiotraffic_20120205 a  (cost=0.00..12.50 rows=1 width=156) (actual time=0.001..0.001 rows=0 loops=1)
                                                  Filter: (talkgroupid = 405203)
                                            ->  Seq Scan on rcs_radiotraffic_20120206 a  (cost=0.00..12.50 rows=1 width=156) (actual time=0.001..0.001 rows=0 loops=1)
                                                  Filter: (talkgroupid = 405203)
                                      ->  Hash  (cost=13.50..13.50 rows=350 width=102) (actual time=0.024..0.024 rows=6 loops=1)
                                            ->  Seq Scan on rcs_basestation b  (cost=0.00..13.50 rows=350 width=102) (actual time=0.004..0.011 rows=6 loops=1)
                                ->  Hash  (cost=18.80..18.80 rows=880 width=62) (actual time=0.023..0.023 rows=6 loops=1)
                                      ->  Seq Scan on rcs_refcalltype c  (cost=0.00..18.80 rows=880 width=62) (actual time=0.003..0.011 rows=6 loops=1)
                          ->  Hash  (cost=17.40..17.40 rows=740 width=80) (actual time=0.049..0.049 rows=16 loops=1)
                                ->  Seq Scan on rcs_refcmdtype t  (cost=0.00..17.40 rows=740 width=80) (actual time=0.003..0.023 rows=16 loops=1)
                    ->  Hash  (cost=16.10..16.10 rows=610 width=102) (actual time=0.022..0.022 rows=6 loops=1)
                          ->  Seq Scan on rcs_refactivebusy d  (cost=0.00..16.10 rows=610 width=102) (actual time=0.003..0.011 rows=6 loops=1)
              ->  Subquery Scan "*SELECT* 2"  (cost=2974.54..4022.48 rows=133 width=286) (actual time=25.690..186.663 rows=130 loops=1)
                    ->  Hash Join  (cost=2974.54..4021.15 rows=133 width=286) (actual time=25.684..186.313 rows=130 loops=1)
                          Hash Cond: (a.calltype = c.calltype)
                          ->  Nested Loop  (cost=2944.74..3921.02 rows=133 width=230) (actual time=25.587..184.045 rows=130 loops=1)
                                ->  Index Scan using rcs_refcmdtype_pkey on rcs_refcmdtype t  (cost=0.00..8.27 rows=1 width=76) (actual time=0.012..0.016 rows=1 loops=1)
                                      Index Cond: ((cmdtype = 7) AND (opcode = 1))
                                ->  Hash Join  (cost=2944.74..3911.42 rows=133 width=162) (actual time=25.506..183.632 rows=130 loops=1)
                                      Hash Cond: (a.sourceradiorbsid = b.rbsid)
                                      ->  Hash Join  (cost=2926.86..3891.72 rows=133 width=64) (actual time=25.464..183.215 rows=135 loops=1)
                                            Hash Cond: ((e.callno = a.callno) AND (e.starttime = a.starttime))
                                            ->  Append  (cost=0.00..672.30 rows=38830 width=24) (actual time=0.014..116.954 rows=31830 loops=1)
                                                  ->  Seq Scan on rcs_endofcall e  (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
                                                  ->  Seq Scan on rcs_endofcall_20120202 e  (cost=0.00..552.30 rows=31830 width=24) (actual time=0.007..43.115 rows=31830 loops=1)
                                                  ->  Seq Scan on rcs_endofcall_20120203 e  (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
                                                  ->  Seq Scan on rcs_endofcall_20120204 e  (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
                                                  ->  Seq Scan on rcs_endofcall_20120205 e  (cost=0.00..24.00 rows=1400 width=24) (actual time=0.001..0.001 rows=0 loops=1)
                                                  ->  Seq Scan on rcs_endofcall_20120206 e  (cost=0.00..24.00 rows=1400 width=24) (actual time=0.002..0.002 rows=0 loops=1)
                                            ->  Hash  (cost=2924.81..2924.81 rows=137 width=60) (actual time=25.228..25.228 rows=135 loops=1)
                                                  ->  Append  (cost=0.00..2924.81 rows=137 width=60) (actual time=0.064..24.349 rows=136 loops=1)
                                                        ->  Index Scan using rcs_radiotraffic_pkey on rcs_radiotraffic a  (cost=0.00..9.76 rows=1 width=144) (actual time=0.005..0.005 rows=0 loops=1)
                                                              Index Cond: (opcode = 1)
                                                              Filter: (talkgroupid = 405203)
                                                        ->  Seq Scan on rcs_radiotraffic_20120202 a  (cost=0.00..2875.99 rows=132 width=57) (actual time=0.052..23.963 rows=136 loops=1)
                                                              Filter: ((opcode = 1) AND (talkgroupid = 405203))
                                                        ->  Index Scan using rcs_radiotraffic_20120203_pkey on rcs_radiotraffic_20120203 a  (cost=0.00..9.76 rows=1 width=144) (actual time=0.007..0.007 rows=0 loops=1)
                                                              Index Cond: (opcode = 1)
                                                              Filter: (talkgroupid = 405203)
                                                        ->  Index Scan using rcs_radiotraffic_20120204_pkey on rcs_radiotraffic_20120204 a  (cost=0.00..9.76 rows=1 width=144) (actual time=0.003..0.003 rows=0 loops=1)
                                                              Index Cond: (opcode = 1)
                                                              Filter: (talkgroupid = 405203)
                                                        ->  Index Scan using rcs_radiotraffic_20120205_pkey on rcs_radiotraffic_20120205 a  (cost=0.00..9.76 rows=1 width=144) (actual time=0.003..0.003 rows=0 loops=1)
                                                              Index Cond: (opcode = 1)
                                                              Filter: (talkgroupid = 405203)
                                                        ->  Index Scan using rcs_radiotraffic_20120206_pkey on rcs_radiotraffic_20120206 a  (cost=0.00..9.76 rows=1 width=144) (actual time=0.003..0.003 rows=0 loops=1)
                                                              Index Cond: (opcode = 1)
                                                              Filter: (talkgroupid = 405203)
                                      ->  Hash  (cost=13.50..13.50 rows=350 width=102) (actual time=0.027..0.027 rows=6 loops=1)
                                            ->  Seq Scan on rcs_basestation b  (cost=0.00..13.50 rows=350 width=102) (actual time=0.005..0.014 rows=6 loops=1)
                          ->  Hash  (cost=18.80..18.80 rows=880 width=62) (actual time=0.027..0.027 rows=6 loops=1)
                                ->  Seq Scan on rcs_refcalltype c  (cost=0.00..18.80 rows=880 width=62) (actual time=0.004..0.012 rows=6 loops=1)
Total runtime: 235.330 ms

Per node type stats

node type	count	sum of times	% of query
Append	4	76.423 ms	32.7 %
Hash	7	0.969 ms	0.4 %
Hash Join	3	43.664 ms	18.7 %
Hash Left Join	4	10.460 ms	4.5 %
HashAggregate	1	2.472 ms	1.1 %
Index Scan	6	0.037 ms	0.0 %
Nested Loop	1	0.397 ms	0.2 %
Seq Scan	19	97.433 ms	41.6 %
Sort	1	1.758 ms	0.8 %
Subquery Scan "SELECT 2"	1	0.350 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
rcs_basestation	2	0.025 ms	0.0 %
Seq Scan	2	0.025 ms	100.0 %
rcs_endofcall	1	0.001 ms	0.0 %
Seq Scan	1	0.001 ms	100.0 %
rcs_endofcall_20120202	1	43.115 ms	18.4 %
Seq Scan	1	43.115 ms	100.0 %
rcs_endofcall_20120203	1	0.001 ms	0.0 %
Seq Scan	1	0.001 ms	100.0 %
rcs_endofcall_20120204	1	0.001 ms	0.0 %
Seq Scan	1	0.001 ms	100.0 %
rcs_endofcall_20120205	1	0.001 ms	0.0 %
Seq Scan	1	0.001 ms	100.0 %
rcs_endofcall_20120206	1	0.002 ms	0.0 %
Seq Scan	1	0.002 ms	100.0 %
rcs_radiotraffic	2	0.007 ms	0.0 %
Index Scan	1	0.005 ms	71.4 %
Seq Scan	1	0.002 ms	28.6 %
rcs_radiotraffic_20120202	2	54.222 ms	23.2 %
Seq Scan	2	54.222 ms	100.0 %
rcs_radiotraffic_20120203	2	0.009 ms	0.0 %
Index Scan	1	0.007 ms	77.8 %
Seq Scan	1	0.002 ms	22.2 %
rcs_radiotraffic_20120204	2	0.005 ms	0.0 %
Index Scan	1	0.003 ms	60.0 %
Seq Scan	1	0.002 ms	40.0 %
rcs_radiotraffic_20120205	2	0.004 ms	0.0 %
Index Scan	1	0.003 ms	75.0 %
Seq Scan	1	0.001 ms	25.0 %
rcs_radiotraffic_20120206	2	0.004 ms	0.0 %
Index Scan	1	0.003 ms	75.0 %
Seq Scan	1	0.001 ms	25.0 %
rcs_refactivebusy	1	0.011 ms	0.0 %
Seq Scan	1	0.011 ms	100.0 %
rcs_refcalltype	2	0.023 ms	0.0 %
Seq Scan	2	0.023 ms	100.0 %
rcs_refcmdtype	2	0.039 ms	0.0 %
Index Scan	1	0.016 ms	41.0 %
Seq Scan	1	0.023 ms	59.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ovM

Colorize:

Columns visibility:

Per node type stats

Per table stats