explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nWf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 2,371.804 22,892.500 ↓ 22.6 164,340 1

HashAggregate (cost=35,063.97..139,291.25 rows=7,285 width=26) (actual time=2,705.698..22,892.500 rows=164,340 loops=1)

2. 802.969 2,114.616 ↓ 41.1 299,365 1

Hash Join (cost=1.16..34,972.91 rows=7,285 width=26) (actual time=83.925..2,114.616 rows=299,365 loops=1)

  • Hash Cond: (a.sourceradiorbsid = b.rbsid)
3. 697.876 1,311.603 ↓ 1.4 299,365 1

Append (cost=0.00..34,118.34 rows=208,149 width=16) (actual time=83.853..1,311.603 rows=299,365 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 299,365 1

Bitmap Heap Scan on rcs_radiotraffic_20120427 a (cost=11,896.02..34,113.54 rows=208,148 width=16) (actual time=83.795..613.675 rows=299,365 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 299,365 1

Bitmap Index Scan on rcs_radiotraffic_20120427_pkey (cost=0.00..11,843.98 rows=208,148 width=0) (actual time=82.496..82.496 rows=299,365 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. 2,136.420 18,406.080 ↑ 2.0 2 164,340

Unique (cost=14.27..14.29 rows=4 width=4) (actual time=0.101..0.112 rows=2 loops=164,340)

11. 2,793.780 16,269.660 ↑ 1.0 4 164,340

Sort (cost=14.27..14.28 rows=4 width=4) (actual time=0.095..0.099 rows=4 loops=164,340)

  • Sort Key: b.siteid
  • Sort Method: quicksort Memory: 17kB
12. 2,465.100 13,475.880 ↑ 1.0 4 164,340

Result (cost=0.00..14.23 rows=4 width=4) (actual time=0.054..0.082 rows=4 loops=164,340)

13. 3,779.820 11,010.780 ↑ 1.0 4 164,340

Append (cost=0.00..14.23 rows=4 width=4) (actual time=0.049..0.067 rows=4 loops=164,340)

14. 3,122.460 3,122.460 ↓ 0.0 0 164,340

Seq Scan on rcs_requestedsite b (cost=0.00..2.03 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=164,340)

  • 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. 4,108.500 4,108.500 ↓ 1.3 4 164,340

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=164,340)

  • 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))