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