#	exclusive	inclusive	rows x	rows	loops	node
1.	2371.804	22892.500	↓ 22.6	164340	1	→ HashAggregate (cost=35063.97..139291.25 rows=7285 width=26) (actual time=2705.698..22892.500 rows=164340 loops=1)
2.	802.969	2114.616	↓ 41.1	299365	1	→ Hash Join (cost=1.16..34972.91 rows=7285 width=26) (actual time=83.925..2114.616 rows=299365 loops=1) Hash Cond: (a.sourceradiorbsid = b.rbsid)
3.	697.876	1311.603	↓ 1.4	299365	1	→ Append (cost=0.00..34118.34 rows=208149 width=16) (actual time=83.853..1311.603 rows=299365 loops=1)
4.	0.052	0.052	↓ 0.0	0	1	→ Seq Scan on rcs_radiotraffic a (cost=0.00..4.80 rows=1 width=16) (actual time=0.052..0.052 rows=0 loops=1) Filter: ((eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone) AND (cmdtype = 17) AND (opcode = ANY ('{1,2,3,4,5}'::integer[])))
5.	531.179	613.675	↓ 1.4	299365	1	→ Bitmap Heap Scan on rcs_radiotraffic_20120427 a (cost=11896.02..34113.54 rows=208148 width=16) (actual time=83.795..613.675 rows=299365 loops=1) Recheck Cond: ((cmdtype = 17) AND (opcode = ANY ('{1,2,3,4,5}'::integer[])) AND (eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone))
6.	82.496	82.496	↓ 1.4	299365	1	→ Bitmap Index Scan on rcs_radiotraffic_20120427_pkey (cost=0.00..11843.98 rows=208148 width=0) (actual time=82.496..82.496 rows=299365 loops=1) Index Cond: ((cmdtype = 17) AND (opcode = ANY ('{1,2,3,4,5}'::integer[])) AND (eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone))
7.	0.016	0.044	↑ 1.0	7	1	→ Hash (cost=1.07..1.07 rows=7 width=14) (actual time=0.044..0.044 rows=7 loops=1)
8.	0.028	0.028	↑ 1.0	7	1	→ Seq Scan on rcs_basestation b (cost=0.00..1.07 rows=7 width=14) (actual time=0.019..0.028 rows=7 loops=1)
9.						SubPlan (forHashAggregate)
10.	2136.420	18406.080	↑ 2.0	2	164340	→ Unique (cost=14.27..14.29 rows=4 width=4) (actual time=0.101..0.112 rows=2 loops=164340)
11.	2793.780	16269.660	↑ 1.0	4	164340	→ Sort (cost=14.27..14.28 rows=4 width=4) (actual time=0.095..0.099 rows=4 loops=164340) Sort Key: b.siteid Sort Method: quicksort Memory: 17kB
12.	2465.100	13475.880	↑ 1.0	4	164340	→ Result (cost=0.00..14.23 rows=4 width=4) (actual time=0.054..0.082 rows=4 loops=164340)
13.	3779.820	11010.780	↑ 1.0	4	164340	→ Append (cost=0.00..14.23 rows=4 width=4) (actual time=0.049..0.067 rows=4 loops=164340)
14.	3122.460	3122.460	↓ 0.0	0	164340	→ Seq Scan on rcs_requestedsite b (cost=0.00..2.03 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=164340) Filter: ((eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone) AND ($0 = callno))
15.	4108.500	4108.500	↓ 1.3	4	164340	→ Index Scan using rcs_requestedsite_20120427_pkey on rcs_requestedsite_20120427 b (cost=0.00..12.20 rows=3 width=4) (actual time=0.016..0.025 rows=4 loops=164340) Index Cond: (($0 = callno) AND (eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone))

"HashAggregate  (cost=35063.97..139291.25 rows=7285 width=26) (actual time=2705.698..22892.500 rows=164340 loops=1)"
"  ->  Hash Join  (cost=1.16..34972.91 rows=7285 width=26) (actual time=83.925..2114.616 rows=299365 loops=1)"
"        Hash Cond: (a.sourceradiorbsid = b.rbsid)"
"        ->  Append  (cost=0.00..34118.34 rows=208149 width=16) (actual time=83.853..1311.603 rows=299365 loops=1)"
"              ->  Seq Scan on rcs_radiotraffic a  (cost=0.00..4.80 rows=1 width=16) (actual time=0.052..0.052 rows=0 loops=1)"
"                    Filter: ((eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone) AND (cmdtype = 17) AND (opcode = ANY ('{1,2,3,4,5}'::integer[])))"
"              ->  Bitmap Heap Scan on rcs_radiotraffic_20120427 a  (cost=11896.02..34113.54 rows=208148 width=16) (actual time=83.795..613.675 rows=299365 loops=1)"
"                    Recheck Cond: ((cmdtype = 17) AND (opcode = ANY ('{1,2,3,4,5}'::integer[])) AND (eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone))"
"                    ->  Bitmap Index Scan on rcs_radiotraffic_20120427_pkey  (cost=0.00..11843.98 rows=208148 width=0) (actual time=82.496..82.496 rows=299365 loops=1)"
"                          Index Cond: ((cmdtype = 17) AND (opcode = ANY ('{1,2,3,4,5}'::integer[])) AND (eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone))"
"        ->  Hash  (cost=1.07..1.07 rows=7 width=14) (actual time=0.044..0.044 rows=7 loops=1)"
"              ->  Seq Scan on rcs_basestation b  (cost=0.00..1.07 rows=7 width=14) (actual time=0.019..0.028 rows=7 loops=1)"
"  SubPlan 1"
"    ->  Unique  (cost=14.27..14.29 rows=4 width=4) (actual time=0.101..0.112 rows=2 loops=164340)"
"          ->  Sort  (cost=14.27..14.28 rows=4 width=4) (actual time=0.095..0.099 rows=4 loops=164340)"
"                Sort Key: b.siteid"
"                Sort Method:  quicksort  Memory: 17kB"
"                ->  Result  (cost=0.00..14.23 rows=4 width=4) (actual time=0.054..0.082 rows=4 loops=164340)"
"                      ->  Append  (cost=0.00..14.23 rows=4 width=4) (actual time=0.049..0.067 rows=4 loops=164340)"
"                            ->  Seq Scan on rcs_requestedsite b  (cost=0.00..2.03 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=164340)"
"                                  Filter: ((eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone) AND ($0 = callno))"
"                            ->  Index Scan using rcs_requestedsite_20120427_pkey on rcs_requestedsite_20120427 b  (cost=0.00..12.20 rows=3 width=4) (actual time=0.016..0.025 rows=4 loops=164340)"
"                                  Index Cond: (($0 = callno) AND (eventtime >= '2012-04-27 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-04-27 10:00:00'::timestamp without time zone))"

Per node type stats

node type	count	sum of times	% of query
Append	2	4477.696 ms	19.6 %
Bitmap Heap Scan	1	531.179 ms	2.3 %
Bitmap Index Scan	1	82.496 ms	0.4 %
Hash	1	0.016 ms	0.0 %
Hash Join	1	802.969 ms	3.5 %
HashAggregate	1	2371.804 ms	10.4 %
Index Scan	1	4108.500 ms	17.9 %
Result	1	2465.100 ms	10.8 %
Seq Scan	3	3122.540 ms	13.6 %
Sort	1	2793.780 ms	12.2 %
Unique	1	2136.420 ms	9.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
rcs_basestation	1	0.028 ms	0.0 %
Seq Scan	1	0.028 ms	100.0 %
rcs_radiotraffic	1	0.052 ms	0.0 %
Seq Scan	1	0.052 ms	100.0 %
rcs_radiotraffic_20120427	1	531.179 ms	2.3 %
Bitmap Heap Scan	1	531.179 ms	100.0 %
rcs_requestedsite	1	3122.460 ms	13.6 %
Seq Scan	1	3122.460 ms	100.0 %
rcs_requestedsite_20120427	1	4108.500 ms	17.9 %
Index Scan	1	4108.500 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nWf

Colorize:

Columns visibility:

Per node type stats

Per table stats