explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Zdr

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

Sort (cost=2,503.46..2,503.75 rows=113 width=373) (actual time=1.547..1.547 rows=0 loops=1)

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

HashAggregate (cost=2,498.48..2,499.61 rows=113 width=373) (actual time=1.536..1.536 rows=0 loops=1)

3. 0.006 1.531 ↓ 0.0 0 1

Append (cost=83.05..2,494.24 rows=113 width=373) (actual time=1.531..1.531 rows=0 loops=1)

4. 0.004 0.677 ↓ 0.0 0 1

Hash Left Join (cost=83.05..1,305.60 rows=112 width=374) (actual time=0.677..0.677 rows=0 loops=1)

  • Hash Cond: ((a.cmdtype = t.cmdtype) AND (a.opcode = t.opcode))
5. 0.004 0.673 ↓ 0.0 0 1

Hash Left Join (cost=54.55..1,198.12 rows=112 width=310) (actual time=0.673..0.673 rows=0 loops=1)

  • Hash Cond: (a.calltype = c.calltype)
6. 0.003 0.669 ↓ 0.0 0 1

Hash Left Join (cost=24.75..1,166.78 rows=112 width=254) (actual time=0.669..0.669 rows=0 loops=1)

  • Hash Cond: (a.sourceradiorbsid = b.rbsid)
7. 0.003 0.666 ↓ 0.0 0 1

Hash Left Join (cost=23.73..1,165.32 rows=112 width=249) (actual time=0.666..0.666 rows=0 loops=1)

  • Hash Cond: (a.activebusystatus = d.activebusystatus)
8. 0.295 0.663 ↓ 0.0 0 1

Append (cost=0.00..1,140.06 rows=112 width=155) (actual time=0.663..0.663 rows=0 loops=1)

9. 0.012 0.012 ↓ 0.0 0 1

Index Scan using eventtime_idx on rcs_radiotraffic a (cost=0.00..8.27 rows=1 width=156) (actual time=0.012..0.012 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. 0.004 0.004 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120212_pkey on rcs_radiotraffic_20120212 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.004..0.004 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))
11. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120213_pkey on rcs_radiotraffic_20120213 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))
12. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120214_pkey on rcs_radiotraffic_20120214 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_20120215_pkey on rcs_radiotraffic_20120215 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_20120216_pkey on rcs_radiotraffic_20120216 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.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120217_pkey on rcs_radiotraffic_20120217 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))
16. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120218_pkey on rcs_radiotraffic_20120218 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))
17. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120219_pkey on rcs_radiotraffic_20120219 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))
18. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120220_pkey on rcs_radiotraffic_20120220 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))
19. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120221_pkey on rcs_radiotraffic_20120221 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))
20. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120222_pkey on rcs_radiotraffic_20120222 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))
21. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120223_pkey on rcs_radiotraffic_20120223 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))
22. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120224_pkey on rcs_radiotraffic_20120224 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))
23. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120225_pkey on rcs_radiotraffic_20120225 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))
24. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120226_pkey on rcs_radiotraffic_20120226 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))
25. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120227_pkey on rcs_radiotraffic_20120227 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))
26. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120228_pkey on rcs_radiotraffic_20120228 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))
27. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120229_pkey on rcs_radiotraffic_20120229 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))
28. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120301_pkey on rcs_radiotraffic_20120301 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))
29. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120302_pkey on rcs_radiotraffic_20120302 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))
30. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120303_pkey on rcs_radiotraffic_20120303 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))
31. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120304_pkey on rcs_radiotraffic_20120304 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))
32. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120305_pkey on rcs_radiotraffic_20120305 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))
33. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120306_pkey on rcs_radiotraffic_20120306 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))
34. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120307_pkey on rcs_radiotraffic_20120307 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))
35. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120308_pkey on rcs_radiotraffic_20120308 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))
36. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120309_pkey on rcs_radiotraffic_20120309 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))
37. 0.004 0.004 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120310_pkey on rcs_radiotraffic_20120310 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.004..0.004 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))
38. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120311_pkey on rcs_radiotraffic_20120311 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))
39. 0.004 0.004 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120312_pkey on rcs_radiotraffic_20120312 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.004..0.004 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))
40. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120313_pkey on rcs_radiotraffic_20120313 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))
41. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120314_pkey on rcs_radiotraffic_20120314 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))
42. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120315_pkey on rcs_radiotraffic_20120315 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))
43. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120316_pkey on rcs_radiotraffic_20120316 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))
44. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120317_pkey on rcs_radiotraffic_20120317 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))
45. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120318_pkey on rcs_radiotraffic_20120318 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))
46. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120319_pkey on rcs_radiotraffic_20120319 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))
47. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120320_pkey on rcs_radiotraffic_20120320 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))
48. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120321_pkey on rcs_radiotraffic_20120321 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))
49. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120322_pkey on rcs_radiotraffic_20120322 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))
50. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120323_pkey on rcs_radiotraffic_20120323 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))
51. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120324_pkey on rcs_radiotraffic_20120324 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))
52. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120325_pkey on rcs_radiotraffic_20120325 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))
53. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120326_pkey on rcs_radiotraffic_20120326 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))
54. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120327_pkey on rcs_radiotraffic_20120327 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))
55. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120328_pkey on rcs_radiotraffic_20120328 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))
56. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120329_pkey on rcs_radiotraffic_20120329 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))
57. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120330_pkey on rcs_radiotraffic_20120330 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))
58. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120331_pkey on rcs_radiotraffic_20120331 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))
59. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120401_pkey on rcs_radiotraffic_20120401 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))
60. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120402_pkey on rcs_radiotraffic_20120402 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))
61. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120403_pkey on rcs_radiotraffic_20120403 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))
62. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120404_pkey on rcs_radiotraffic_20120404 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))
63. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120405_pkey on rcs_radiotraffic_20120405 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))
64. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120406_pkey on rcs_radiotraffic_20120406 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))
65. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120407_pkey on rcs_radiotraffic_20120407 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))
66. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120408_pkey on rcs_radiotraffic_20120408 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))
67. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120409_pkey on rcs_radiotraffic_20120409 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))
68. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120410_pkey on rcs_radiotraffic_20120410 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))
69. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120411_pkey on rcs_radiotraffic_20120411 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))
70. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120412_pkey on rcs_radiotraffic_20120412 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))
71. 0.028 0.028 ↓ 0.0 0 1

Seq Scan on rcs_radiotraffic_20120413 a (cost=0.00..3.19 rows=1 width=66) (actual time=0.028..0.028 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))
72. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120414_pkey on rcs_radiotraffic_20120414 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))
73. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120415_pkey on rcs_radiotraffic_20120415 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))
74. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120416_pkey on rcs_radiotraffic_20120416 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))
75. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120417_pkey on rcs_radiotraffic_20120417 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))
76. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120418_pkey on rcs_radiotraffic_20120418 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))
77. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120419_pkey on rcs_radiotraffic_20120419 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))
78. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120420_pkey on rcs_radiotraffic_20120420 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))
79. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120421_pkey on rcs_radiotraffic_20120421 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))
80. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120422_pkey on rcs_radiotraffic_20120422 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))
81. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120423_pkey on rcs_radiotraffic_20120423 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))
82. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120424_pkey on rcs_radiotraffic_20120424 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))
83. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120425_pkey on rcs_radiotraffic_20120425 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))
84. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120426_pkey on rcs_radiotraffic_20120426 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))
85. 0.004 0.004 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120427_pkey on rcs_radiotraffic_20120427 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.004..0.004 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))
86. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120428_pkey on rcs_radiotraffic_20120428 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))
87. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120429_pkey on rcs_radiotraffic_20120429 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))
88. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120430_pkey on rcs_radiotraffic_20120430 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))
89. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120501_pkey on rcs_radiotraffic_20120501 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))
90. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120502_pkey on rcs_radiotraffic_20120502 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.002..0.002 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))
91. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120503_pkey on rcs_radiotraffic_20120503 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))
92. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120504_pkey on rcs_radiotraffic_20120504 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))
93. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120505_pkey on rcs_radiotraffic_20120505 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.002..0.002 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))
94. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120506_pkey on rcs_radiotraffic_20120506 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))
95. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120507_pkey on rcs_radiotraffic_20120507 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))
96. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120508_pkey on rcs_radiotraffic_20120508 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))
97. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120509_pkey on rcs_radiotraffic_20120509 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))
98. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120510_pkey on rcs_radiotraffic_20120510 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))
99. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120511_pkey on rcs_radiotraffic_20120511 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))
100. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120512_pkey on rcs_radiotraffic_20120512 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))
101. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120513_pkey on rcs_radiotraffic_20120513 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))
102. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120514_pkey on rcs_radiotraffic_20120514 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.002..0.002 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))
103. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120515_pkey on rcs_radiotraffic_20120515 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))
104. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120516_pkey on rcs_radiotraffic_20120516 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))
105. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120517_pkey on rcs_radiotraffic_20120517 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.002..0.002 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))
106. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120518_pkey on rcs_radiotraffic_20120518 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))
107. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120519_pkey on rcs_radiotraffic_20120519 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.002..0.002 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))
108. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120520_pkey on rcs_radiotraffic_20120520 a (cost=0.00..10.26 rows=1 width=156) (actual time=0.002..0.002 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))
109. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120521_pkey on rcs_radiotraffic_20120521 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))
110. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120522_pkey on rcs_radiotraffic_20120522 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))
111. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120523_pkey on rcs_radiotraffic_20120523 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))
112. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120524_pkey on rcs_radiotraffic_20120524 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))
113. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120525_pkey on rcs_radiotraffic_20120525 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))
114. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120526_pkey on rcs_radiotraffic_20120526 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))
115. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120527_pkey on rcs_radiotraffic_20120527 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))
116. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120528_pkey on rcs_radiotraffic_20120528 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))
117. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120529_pkey on rcs_radiotraffic_20120529 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))
118. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120530_pkey on rcs_radiotraffic_20120530 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))
119. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120531_pkey on rcs_radiotraffic_20120531 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))
120. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120601_pkey on rcs_radiotraffic_20120601 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))
121. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.10..16.10 rows=610 width=102) (actual time=.. rows= loops=0)

122. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_refactivebusy d (cost=0.00..16.10 rows=610 width=102) (actual time=.. rows= loops=0)

123. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.01..1.01 rows=1 width=9) (actual time=.. rows= loops=0)

124. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_basestation b (cost=0.00..1.01 rows=1 width=9) (actual time=.. rows= loops=0)

125. 0.000 0.000 ↓ 0.0 0

Hash (cost=18.80..18.80 rows=880 width=62) (actual time=.. rows= loops=0)

126. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_refcalltype c (cost=0.00..18.80 rows=880 width=62) (actual time=.. rows= loops=0)

127. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.40..17.40 rows=740 width=80) (actual time=.. rows= loops=0)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on rcs_refcmdtype t (cost=0.00..17.40 rows=740 width=80) (actual time=.. rows= loops=0)

129. 0.004 0.848 ↓ 0.0 0 1

Subquery Scan "*SELECT* 2" (cost=0.00..1,187.53 rows=1 width=260) (actual time=0.848..0.848 rows=0 loops=1)

130. 0.003 0.844 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,187.52 rows=1 width=260) (actual time=0.844..0.844 rows=0 loops=1)

  • Join Filter: ((a.callno = e.callno) AND (a.starttime = e.starttime))
131. 0.004 0.841 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,117.50 rows=1 width=256) (actual time=0.841..0.841 rows=0 loops=1)

132. 0.067 0.837 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,116.90 rows=1 width=200) (actual time=0.837..0.837 rows=0 loops=1)

133. 0.108 0.740 ↓ 15.0 15 1

Nested Loop (cost=0.00..1,108.62 rows=1 width=132) (actual time=0.325..0.740 rows=15 loops=1)

  • Join Filter: (a.sourceradiorbsid = b.rbsid)
134. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on rcs_basestation b (cost=0.00..1.01 rows=1 width=9) (actual time=0.002..0.004 rows=1 loops=1)

135. 0.335 0.628 ↑ 5.3 26 1

Append (cost=0.00..1,105.87 rows=139 width=127) (actual time=0.266..0.628 rows=26 loops=1)

136. 0.003 0.003 ↓ 0.0 0 1

Index Scan using radioactivity_idx 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: (a.opcode = 1)
137. 0.004 0.004 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120210_pkey on rcs_radiotraffic_20120210 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
138. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120211_pkey on rcs_radiotraffic_20120211 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
139. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120212_pkey on rcs_radiotraffic_20120212 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
140. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120213_pkey on rcs_radiotraffic_20120213 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
141. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120214_pkey on rcs_radiotraffic_20120214 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
142. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120215_pkey on rcs_radiotraffic_20120215 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
143. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120216_pkey on rcs_radiotraffic_20120216 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
144. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120217_pkey on rcs_radiotraffic_20120217 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
145. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120218_pkey on rcs_radiotraffic_20120218 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
146. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120219_pkey on rcs_radiotraffic_20120219 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
147. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120220_pkey on rcs_radiotraffic_20120220 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
148. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120221_pkey on rcs_radiotraffic_20120221 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
149. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120222_pkey on rcs_radiotraffic_20120222 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
150. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120223_pkey on rcs_radiotraffic_20120223 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
151. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120224_pkey on rcs_radiotraffic_20120224 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
152. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120225_pkey on rcs_radiotraffic_20120225 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
153. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120226_pkey on rcs_radiotraffic_20120226 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
154. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120227_pkey on rcs_radiotraffic_20120227 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
155. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120228_pkey on rcs_radiotraffic_20120228 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
156. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120229_pkey on rcs_radiotraffic_20120229 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
157. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120301_pkey on rcs_radiotraffic_20120301 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
158. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120302_pkey on rcs_radiotraffic_20120302 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
159. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120303_pkey on rcs_radiotraffic_20120303 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
160. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120304_pkey on rcs_radiotraffic_20120304 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
161. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120305_pkey on rcs_radiotraffic_20120305 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
162. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120306_pkey on rcs_radiotraffic_20120306 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
163. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120307_pkey on rcs_radiotraffic_20120307 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
164. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120308_pkey on rcs_radiotraffic_20120308 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
165. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120309_pkey on rcs_radiotraffic_20120309 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
166. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120310_pkey on rcs_radiotraffic_20120310 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
167. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120311_pkey on rcs_radiotraffic_20120311 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
168. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120312_pkey on rcs_radiotraffic_20120312 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
169. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120313_pkey on rcs_radiotraffic_20120313 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
170. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120314_pkey on rcs_radiotraffic_20120314 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
171. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120315_pkey on rcs_radiotraffic_20120315 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
172. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120316_pkey on rcs_radiotraffic_20120316 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
173. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120317_pkey on rcs_radiotraffic_20120317 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
174. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120318_pkey on rcs_radiotraffic_20120318 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
175. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120319_pkey on rcs_radiotraffic_20120319 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
176. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120320_pkey on rcs_radiotraffic_20120320 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
177. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120321_pkey on rcs_radiotraffic_20120321 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
178. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120322_pkey on rcs_radiotraffic_20120322 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
179. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120323_pkey on rcs_radiotraffic_20120323 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
180. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120324_pkey on rcs_radiotraffic_20120324 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
181. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120325_pkey on rcs_radiotraffic_20120325 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
182. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120326_pkey on rcs_radiotraffic_20120326 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
183. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120327_pkey on rcs_radiotraffic_20120327 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
184. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120328_pkey on rcs_radiotraffic_20120328 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
185. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120329_pkey on rcs_radiotraffic_20120329 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
186. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120330_pkey on rcs_radiotraffic_20120330 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
187. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120331_pkey on rcs_radiotraffic_20120331 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
188. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120401_pkey on rcs_radiotraffic_20120401 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
189. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120402_pkey on rcs_radiotraffic_20120402 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
190. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120403_pkey on rcs_radiotraffic_20120403 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
191. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120404_pkey on rcs_radiotraffic_20120404 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
192. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120405_pkey on rcs_radiotraffic_20120405 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
193. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120406_pkey on rcs_radiotraffic_20120406 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
194. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120407_pkey on rcs_radiotraffic_20120407 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
195. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120408_pkey on rcs_radiotraffic_20120408 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
196. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120409_pkey on rcs_radiotraffic_20120409 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
197. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120410_pkey on rcs_radiotraffic_20120410 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
198. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120411_pkey on rcs_radiotraffic_20120411 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
199. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120412_pkey on rcs_radiotraffic_20120412 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
200. 0.053 0.053 ↑ 1.0 26 1

Seq Scan on rcs_radiotraffic_20120413 a (cost=0.00..2.99 rows=26 width=54) (actual time=0.004..0.053 rows=26 loops=1)

  • Filter: (a.opcode = 1)
201. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120414_pkey on rcs_radiotraffic_20120414 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
202. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120415_pkey on rcs_radiotraffic_20120415 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
203. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120416_pkey on rcs_radiotraffic_20120416 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
204. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120417_pkey on rcs_radiotraffic_20120417 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
205. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120418_pkey on rcs_radiotraffic_20120418 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
206. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120419_pkey on rcs_radiotraffic_20120419 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
207. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120420_pkey on rcs_radiotraffic_20120420 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
208. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120421_pkey on rcs_radiotraffic_20120421 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
209. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120422_pkey on rcs_radiotraffic_20120422 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
210. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120423_pkey on rcs_radiotraffic_20120423 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
211. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120424_pkey on rcs_radiotraffic_20120424 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
212. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120425_pkey on rcs_radiotraffic_20120425 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
213. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120426_pkey on rcs_radiotraffic_20120426 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
214. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120427_pkey on rcs_radiotraffic_20120427 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
215. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120428_pkey on rcs_radiotraffic_20120428 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
216. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120429_pkey on rcs_radiotraffic_20120429 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
217. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120430_pkey on rcs_radiotraffic_20120430 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
218. 0.001 0.001 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120501_pkey on rcs_radiotraffic_20120501 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
219. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120502_pkey on rcs_radiotraffic_20120502 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
220. 0.001 0.001 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120503_pkey on rcs_radiotraffic_20120503 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
221. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120504_pkey on rcs_radiotraffic_20120504 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
222. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120505_pkey on rcs_radiotraffic_20120505 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
223. 0.001 0.001 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120506_pkey on rcs_radiotraffic_20120506 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
224. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120507_pkey on rcs_radiotraffic_20120507 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
225. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120508_pkey on rcs_radiotraffic_20120508 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
226. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120509_pkey on rcs_radiotraffic_20120509 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
227. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120510_pkey on rcs_radiotraffic_20120510 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
228. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120511_pkey on rcs_radiotraffic_20120511 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
229. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120512_pkey on rcs_radiotraffic_20120512 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
230. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120513_pkey on rcs_radiotraffic_20120513 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
231. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120514_pkey on rcs_radiotraffic_20120514 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
232. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120515_pkey on rcs_radiotraffic_20120515 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
233. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120516_pkey on rcs_radiotraffic_20120516 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
234. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120517_pkey on rcs_radiotraffic_20120517 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
235. 0.003 0.003 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120518_pkey on rcs_radiotraffic_20120518 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
236. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120519_pkey on rcs_radiotraffic_20120519 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
237. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120520_pkey on rcs_radiotraffic_20120520 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
238. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120521_pkey on rcs_radiotraffic_20120521 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
239. 0.016 0.016 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120522_pkey on rcs_radiotraffic_20120522 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
240. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120523_pkey on rcs_radiotraffic_20120523 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
241. 0.001 0.001 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120524_pkey on rcs_radiotraffic_20120524 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
242. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120525_pkey on rcs_radiotraffic_20120525 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
243. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120526_pkey on rcs_radiotraffic_20120526 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
244. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120527_pkey on rcs_radiotraffic_20120527 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
245. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120528_pkey on rcs_radiotraffic_20120528 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
246. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120529_pkey on rcs_radiotraffic_20120529 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
247. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120530_pkey on rcs_radiotraffic_20120530 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
248. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120531_pkey on rcs_radiotraffic_20120531 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
249. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rcs_radiotraffic_20120601_pkey on rcs_radiotraffic_20120601 a (cost=0.00..9.76 rows=1 width=144) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (a.opcode = 1)
250. 0.030 0.030 ↓ 0.0 0 15

Index Scan using rcs_refcmdtype_pkey on rcs_refcmdtype t (cost=0.00..8.27 rows=1 width=76) (actual time=0.002..0.002 rows=0 loops=15)

  • Index Cond: ((t.cmdtype = 7) AND (t.opcode = 1))
251. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_refcalltype_pkey on rcs_refcalltype c (cost=0.00..0.58 rows=1 width=62) (actual time=.. rows= loops=0)

  • Index Cond: (c.calltype = a.calltype)
252. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..67.80 rows=114 width=24) (actual time=.. rows= loops=0)

253. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_pkey on rcs_endofcall e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
254. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120210_pkey on rcs_endofcall_20120210 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
255. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120211_pkey on rcs_endofcall_20120211 e (cost=0.00..0.67 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
256. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120212_pkey on rcs_endofcall_20120212 e (cost=0.00..0.67 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
257. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120213_pkey on rcs_endofcall_20120213 e (cost=0.00..0.67 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
258. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120214_pkey on rcs_endofcall_20120214 e (cost=0.00..0.67 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
259. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120215_pkey on rcs_endofcall_20120215 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
260. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120216_pkey on rcs_endofcall_20120216 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
261. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120217_pkey on rcs_endofcall_20120217 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
262. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120218_pkey on rcs_endofcall_20120218 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
263. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120219_pkey on rcs_endofcall_20120219 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
264. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120220_pkey on rcs_endofcall_20120220 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
265. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120221_pkey on rcs_endofcall_20120221 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
266. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120222_pkey on rcs_endofcall_20120222 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
267. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120223_pkey on rcs_endofcall_20120223 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
268. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120224_pkey on rcs_endofcall_20120224 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
269. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120225_pkey on rcs_endofcall_20120225 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
270. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120226_pkey on rcs_endofcall_20120226 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
271. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120227_pkey on rcs_endofcall_20120227 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
272. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120228_pkey on rcs_endofcall_20120228 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
273. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120229_pkey on rcs_endofcall_20120229 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
274. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120301_pkey on rcs_endofcall_20120301 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
275. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120302_pkey on rcs_endofcall_20120302 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
276. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120303_pkey on rcs_endofcall_20120303 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
277. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120304_pkey on rcs_endofcall_20120304 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
278. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120305_pkey on rcs_endofcall_20120305 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
279. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120306_pkey on rcs_endofcall_20120306 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
280. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120307_pkey on rcs_endofcall_20120307 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
281. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120308_pkey on rcs_endofcall_20120308 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
282. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120309_pkey on rcs_endofcall_20120309 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
283. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120310_pkey on rcs_endofcall_20120310 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
284. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120311_pkey on rcs_endofcall_20120311 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
285. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120312_pkey on rcs_endofcall_20120312 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
286. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120313_pkey on rcs_endofcall_20120313 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
287. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120314_pkey on rcs_endofcall_20120314 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
288. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120315_pkey on rcs_endofcall_20120315 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
289. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120316_pkey on rcs_endofcall_20120316 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
290. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120317_pkey on rcs_endofcall_20120317 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
291. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120318_pkey on rcs_endofcall_20120318 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
292. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120319_pkey on rcs_endofcall_20120319 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
293. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120320_pkey on rcs_endofcall_20120320 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
294. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120321_pkey on rcs_endofcall_20120321 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
295. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120322_pkey on rcs_endofcall_20120322 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
296. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120323_pkey on rcs_endofcall_20120323 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
297. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120324_pkey on rcs_endofcall_20120324 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
298. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120325_pkey on rcs_endofcall_20120325 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
299. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120326_pkey on rcs_endofcall_20120326 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
300. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120327_pkey on rcs_endofcall_20120327 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
301. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120328_pkey on rcs_endofcall_20120328 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
302. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120329_pkey on rcs_endofcall_20120329 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
303. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120330_pkey on rcs_endofcall_20120330 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
304. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120331_pkey on rcs_endofcall_20120331 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
305. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120401_pkey on rcs_endofcall_20120401 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
306. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120402_pkey on rcs_endofcall_20120402 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
307. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120403_pkey on rcs_endofcall_20120403 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
308. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120404_pkey on rcs_endofcall_20120404 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
309. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120405_pkey on rcs_endofcall_20120405 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
310. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120406_pkey on rcs_endofcall_20120406 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
311. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120407_pkey on rcs_endofcall_20120407 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
312. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120408_pkey on rcs_endofcall_20120408 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
313. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120409_pkey on rcs_endofcall_20120409 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
314. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120410_pkey on rcs_endofcall_20120410 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
315. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120411_pkey on rcs_endofcall_20120411 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
316. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120412_pkey on rcs_endofcall_20120412 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
317. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120413_pkey on rcs_endofcall_20120413 e (cost=0.00..0.36 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
318. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120414_pkey on rcs_endofcall_20120414 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
319. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120415_pkey on rcs_endofcall_20120415 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
320. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120416_pkey on rcs_endofcall_20120416 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
321. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120417_pkey on rcs_endofcall_20120417 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
322. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120418_pkey on rcs_endofcall_20120418 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
323. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120419_pkey on rcs_endofcall_20120419 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
324. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120420_pkey on rcs_endofcall_20120420 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
325. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120421_pkey on rcs_endofcall_20120421 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
326. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120422_pkey on rcs_endofcall_20120422 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
327. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120423_pkey on rcs_endofcall_20120423 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
328. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120424_pkey on rcs_endofcall_20120424 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
329. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120425_pkey on rcs_endofcall_20120425 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
330. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120426_pkey on rcs_endofcall_20120426 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
331. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120427_pkey on rcs_endofcall_20120427 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
332. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120428_pkey on rcs_endofcall_20120428 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
333. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120429_pkey on rcs_endofcall_20120429 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
334. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120430_pkey on rcs_endofcall_20120430 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
335. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120501_pkey on rcs_endofcall_20120501 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
336. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120502_pkey on rcs_endofcall_20120502 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
337. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120503_pkey on rcs_endofcall_20120503 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
338. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120504_pkey on rcs_endofcall_20120504 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
339. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120505_pkey on rcs_endofcall_20120505 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
340. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120506_pkey on rcs_endofcall_20120506 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
341. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120507_pkey on rcs_endofcall_20120507 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
342. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120508_pkey on rcs_endofcall_20120508 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
343. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120509_pkey on rcs_endofcall_20120509 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
344. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120510_pkey on rcs_endofcall_20120510 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
345. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120511_pkey on rcs_endofcall_20120511 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
346. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120512_pkey on rcs_endofcall_20120512 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
347. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120513_pkey on rcs_endofcall_20120513 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
348. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120514_pkey on rcs_endofcall_20120514 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
349. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120515_pkey on rcs_endofcall_20120515 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
350. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120516_pkey on rcs_endofcall_20120516 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
351. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120517_pkey on rcs_endofcall_20120517 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
352. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120518_pkey on rcs_endofcall_20120518 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
353. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120519_pkey on rcs_endofcall_20120519 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
354. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120520_pkey on rcs_endofcall_20120520 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
355. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120521_pkey on rcs_endofcall_20120521 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
356. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120522_pkey on rcs_endofcall_20120522 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
357. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120523_pkey on rcs_endofcall_20120523 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
358. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120524_pkey on rcs_endofcall_20120524 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
359. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120525_pkey on rcs_endofcall_20120525 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
360. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120526_pkey on rcs_endofcall_20120526 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
361. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120527_pkey on rcs_endofcall_20120527 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
362. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120528_pkey on rcs_endofcall_20120528 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
363. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120529_pkey on rcs_endofcall_20120529 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
364. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120530_pkey on rcs_endofcall_20120530 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
365. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120531_pkey on rcs_endofcall_20120531 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

  • 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))
366. 0.000 0.000 ↓ 0.0 0

Index Scan using rcs_endofcall_20120601_pkey on rcs_endofcall_20120601 e (cost=0.00..0.59 rows=1 width=24) (actual time=.. rows= loops=0)

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