explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ovM

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 1.758 233.963 ↑ 1.0 516 1

Sort (cost=7,164.37..7,165.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=7,135.90..7,141.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..7,116.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..3,090.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..2,863.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..2,761.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..2,726.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..2,703.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..2,641.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=2,974.54..4,022.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=2,974.54..4,021.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=2,944.74..3,921.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=2,944.74..3,911.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=2,926.86..3,891.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 31,830 1

Append (cost=0.00..672.30 rows=38,830 width=24) (actual time=0.014..116.954 rows=31,830 loops=1)

30. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rcs_endofcall e (cost=0.00..24.00 rows=1,400 width=24) (actual time=0.001..0.001 rows=0 loops=1)

31. 43.115 43.115 ↑ 1.0 31,830 1

Seq Scan on rcs_endofcall_20120202 e (cost=0.00..552.30 rows=31,830 width=24) (actual time=0.007..43.115 rows=31,830 loops=1)

32. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rcs_endofcall_20120203 e (cost=0.00..24.00 rows=1,400 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=1,400 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=1,400 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=1,400 width=24) (actual time=0.002..0.002 rows=0 loops=1)

36. 0.879 25.228 ↑ 1.0 135 1

Hash (cost=2,924.81..2,924.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..2,924.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..2,875.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)