explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mRr

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.016 1396.004 ↓ 0.0 0 1

Sort (cost=5848.74..5848.76 rows=7 width=166) (actual time=1396.004..1396.004 rows=0 loops=1)

  • Sort Key: a.eventtime
  • Sort Method: quicksort Memory: 17kB
2. 0.006 1395.988 ↓ 0.0 0 1

HashAggregate (cost=5848.58..5848.65 rows=7 width=166) (actual time=1395.988..1395.988 rows=0 loops=1)

3. 0.007 1395.982 ↓ 0.0 0 1

Append (cost=0.00..5848.31 rows=7 width=166) (actual time=1395.982..1395.982 rows=0 loops=1)

4. 0.005 40.834 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..2959.22 rows=6 width=179) (actual time=40.834..40.834 rows=0 loops=1)

  • Join Filter: (a.calltype = c.calltype)
5. 0.005 40.829 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..2949.32 rows=6 width=168) (actual time=40.829..40.829 rows=0 loops=1)

  • Join Filter: ((a.cmdtype = t.cmdtype) AND (a.opcode = t.opcode))
6. 0.004 40.824 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..2940.92 rows=6 width=158) (actual time=40.824..40.824 rows=0 loops=1)

  • Join Filter: (a.sourceradiorbsid = b.rbsid)
7. 0.004 40.820 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..2934.11 rows=6 width=155) (actual time=40.820..40.820 rows=0 loops=1)

  • Join Filter: (a.activebusystatus = d.activebusystatus)
8. 0.019 40.816 ↓ 0.0 0 1

Append (cost=0.00..2927.30 rows=6 width=141) (actual time=40.816..40.816 rows=0 loops=1)

9. 0.010 0.010 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_pkey on rcs_radiotraffic a (cost=0.00..10.26 rows=1 width=156) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
10. 40.772 40.772 ↓ 0.0 0 1

Seq Scan on rcs_radiotraffic_20120202 a (cost=0.00..2875.99 rows=1 width=69) (actual time=40.772..40.772 rows=0 loops=1)

  • Filter: ((eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
11. 0.006 0.006 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120203_pkey on rcs_radiotraffic_20120203 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
12. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120204_pkey on rcs_radiotraffic_20120204 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
13. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120205_pkey on rcs_radiotraffic_20120205 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
14. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120206_pkey on rcs_radiotraffic_20120206 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_refactivebusy d (cost=0.00..1.06 rows=6 width=22) (actual time=.. rows= loops=0)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_basestation b (cost=0.00..1.06 rows=6 width=7) (actual time=.. rows= loops=0)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_refcmdtype t (cost=0.00..1.16 rows=16 width=26) (actual time=.. rows= loops=0)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_refcalltype c (cost=0.00..1.06 rows=6 width=17) (actual time=.. rows= loops=0)

19. 0.004 1355.141 ↓ 0.0 0 1

Subquery Scan "*SELECT* 2" (cost=2.27..2889.04 rows=1 width=89) (actual time=1355.141..1355.141 rows=0 loops=1)

20. 0.004 1355.137 ↓ 0.0 0 1

Nested Loop (cost=2.27..2889.03 rows=1 width=89) (actual time=1355.137..1355.137 rows=0 loops=1)

21. 318.777 1355.133 ↓ 0.0 0 1

Nested Loop (cost=2.27..2887.26 rows=1 width=75) (actual time=1355.133..1355.133 rows=0 loops=1)

  • Join Filter: ((a.callno = e.callno) AND (a.starttime = e.starttime))
22. 72.672 305.948 ↓ 899.5 26086 1

Hash Join (cost=2.27..2826.10 rows=29 width=71) (actual time=0.153..305.948 rows=26086 loops=1)

  • Hash Cond: (a.calltype = c.calltype)
23. 79.884 233.251 ↓ 27.4 26372 1

Hash Join (cost=1.14..2821.06 rows=963 width=60) (actual time=0.102..233.251 rows=26372 loops=1)

  • Hash Cond: (a.sourceradiorbsid = b.rbsid)
24. 74.275 153.343 ↓ 1.0 32224 1

Append (cost=0.00..2689.96 rows=32089 width=57) (actual time=0.050..153.343 rows=32224 loops=1)

25. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (opcode = 1)
26. 79.053 79.053 ↓ 1.0 32224 1

Seq Scan on rcs_radiotraffic_20120202 a (cost=0.00..2641.16 rows=32084 width=57) (actual time=0.041..79.053 rows=32224 loops=1)

  • Filter: (opcode = 1)
27. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (opcode = 1)
28. 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)
29. 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)
30. 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)
31. 0.013 0.024 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=7) (actual time=0.024..0.024 rows=6 loops=1)

32. 0.011 0.011 ↑ 1.0 6 1

Seq Scan on rcs_basestation b (cost=0.00..1.06 rows=6 width=7) (actual time=0.003..0.011 rows=6 loops=1)

33. 0.013 0.025 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=17) (actual time=0.025..0.025 rows=6 loops=1)

34. 0.012 0.012 ↑ 1.0 6 1

Seq Scan on rcs_refcalltype c (cost=0.00..1.06 rows=6 width=17) (actual time=0.004..0.012 rows=6 loops=1)

35. 391.290 730.408 ↓ 0.0 0 26086

Append (cost=0.00..2.02 rows=6 width=24) (actual time=0.028..0.028 rows=0 loops=26086)

36. 52.172 52.172 ↓ 0.0 0 26086

Index Scan using endofcall_callnostart_idx on rcs_endofcall e (cost=0.00..0.28 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=26086)

  • Index Cond: ((e.callno = a.callno) AND (e.starttime = a.starttime))
  • Filter: ((e.eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (e.eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
37. 78.258 78.258 ↓ 0.0 0 26086

Index Scan using rcs_endofcall_20120202_pkey on rcs_endofcall_20120202 e (cost=0.00..0.33 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=26086)

  • Index Cond: ((e.callno = a.callno) AND (e.eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (e.eventtime <= '2012-02-03 12:00:00'::timestamp without time zone))
38. 52.172 52.172 ↓ 0.0 0 26086

Index Scan using rcs_endofcall_20120203_pkey on rcs_endofcall_20120203 e (cost=0.00..0.35 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=26086)

  • Index Cond: ((e.eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (e.eventtime <= '2012-02-03 12:00:00'::timestamp without time zone) AND (e.callno = a.callno))
39. 52.172 52.172 ↓ 0.0 0 26086

Index Scan using rcs_endofcall_20120204_pkey on rcs_endofcall_20120204 e (cost=0.00..0.35 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=26086)

  • Index Cond: ((e.eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (e.eventtime <= '2012-02-03 12:00:00'::timestamp without time zone) AND (e.callno = a.callno))
40. 52.172 52.172 ↓ 0.0 0 26086

Index Scan using rcs_endofcall_20120205_pkey on rcs_endofcall_20120205 e (cost=0.00..0.35 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=26086)

  • Index Cond: ((e.eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (e.eventtime <= '2012-02-03 12:00:00'::timestamp without time zone) AND (e.callno = a.callno))
41. 52.172 52.172 ↓ 0.0 0 26086

Index Scan using rcs_endofcall_20120206_pkey on rcs_endofcall_20120206 e (cost=0.00..0.35 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=26086)

  • Index Cond: ((e.eventtime >= '2012-02-03 00:00:00'::timestamp without time zone) AND (e.eventtime <= '2012-02-03 12:00:00'::timestamp without time zone) AND (e.callno = a.callno))
42. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_refcmdtype t (cost=0.00..1.24 rows=1 width=22) (actual time=.. rows= loops=0)

  • Filter: ((t.opcode = 1) AND (t.cmdtype = 7))