explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PBam : TST

Settings
# exclusive inclusive rows x rows loops node
1. 167,049.916 167,049.916 ↑ 7.8 884,957 1

CTE Scan on stitched_data_phase1 ph1 (cost=41,584,998,773.43..41,616,310,875.97 rows=6,896,939 width=11,479) (actual time=154,855.208..167,049.916 rows=884,957 loops=1)

  • Filter: (rank = 1)
  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
2.          

CTE session_details

3. 831.099 19,673.892 ↑ 1.0 632,716 1

WindowAgg (cost=612,882.73..666,695.21 rows=633,088 width=4,280) (actual time=18,757.209..19,673.892 rows=632,716 loops=1)

  • Buffers: shared hit=36 read=472447 written=3
4. 708.603 18,842.793 ↑ 1.0 632,716 1

Sort (cost=612,882.73..614,465.45 rows=633,088 width=122) (actual time=18,757.186..18,842.793 rows=632,716 loops=1)

  • Sort Key: sd_.ms_source_id, (COALESCE(sd_.replaces_dialog_id_time, sd_.session_id_time)), (COALESCE(sd_.replaces_dialog_id_seq, sd_.session_id_seq)), sd_.replaces_dialog_id_time DESC NULLS LAST
  • Sort Method: quicksort Memory: 138145kB
  • Buffers: shared hit=36 read=472447 written=3
5. 376.815 18,134.190 ↑ 1.0 632,716 1

Hash Join (cost=73,362.59..551,878.23 rows=633,088 width=122) (actual time=2,811.107..18,134.19 rows=632,716 loops=1)

  • Buffers: shared hit=36 read=472447 written=3
6. 55.068 14,946.879 ↓ 1.0 632,716 1

Append (cost=0..415,342.56 rows=631,580 width=82) (actual time=0.378..14,946.879 rows=632,716 loops=1)

  • Buffers: shared hit=18 read=405849 written=3
7. 40.814 40.814 ↓ 1.0 35,941 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_06 sd_ (cost=0..1,848.12 rows=35,934 width=82) (actual time=0.378..40.814 rows=35,941 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1308
8. 54.338 54.338 ↓ 1.0 40,426 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_07 sd__1 (cost=0..2,359.39 rows=40,418 width=82) (actual time=0.493..54.338 rows=40,426 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1752
9. 62.985 62.985 ↓ 1.0 42,838 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_08 sd__2 (cost=0..2,272.57 rows=42,830 width=82) (actual time=0.378..62.985 rows=42,838 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1629
10. 8,065.497 8,065.497 ↑ 1.0 43,737 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_09 sd__3 (cost=0..216,868.45 rows=44,421 width=82) (actual time=0.78..8,065.497 rows=43,737 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=216202
11. 12.386 12.386 ↑ 1.0 678 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_10 sd__4 (cost=0..243.17 rows=678 width=82) (actual time=0.408..12.386 rows=678 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=233
12. 3.645 3.645 ↓ 1.0 3,096 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_11 sd__5 (cost=0..142.44 rows=3,095 width=82) (actual time=1.165..3.645 rows=3,096 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=95
13. 1.544 1.544 ↑ 1.0 1,435 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_12 sd__6 (cost=0..67.53 rows=1,435 width=82) (actual time=0.463..1.544 rows=1,435 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=45
14. 85.371 85.371 ↓ 1.0 40,456 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_13 sd__7 (cost=0..2,557.84 rows=40,448 width=82) (actual time=0.4..85.371 rows=40,456 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1950
15. 38.172 38.172 ↓ 1.0 41,141 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_14 sd__8 (cost=0..1,949.12 rows=41,133 width=82) (actual time=0.432..38.172 rows=41,141 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1331
16. 392.771 392.771 ↓ 1.0 42,211 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_15 sd__9 (cost=0..12,169.17 rows=42,203 width=82) (actual time=0.719..392.771 rows=42,211 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=11536
17. 4,286.256 4,286.256 ↓ 1.0 40,089 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_16 sd__10 (cost=0..116,553.23 rows=38,807 width=82) (actual time=3.419..4,286.256 rows=40,089 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=115971 written=3
18. 1,411.595 1,411.595 ↓ 1.0 39,907 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_17 sd__11 (cost=0..40,700.14 rows=39,468 width=82) (actual time=0.733..1,411.595 rows=39,907 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=40107
19. 3.725 3.725 ↓ 1.0 3,122 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_18 sd__12 (cost=0..149.83 rows=3,121 width=82) (actual time=0.705..3.725 rows=3,122 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=102
20. 1.991 1.991 ↑ 1.0 1,109 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_19 sd__13 (cost=0..57.63 rows=1,109 width=82) (actual time=0.771..1.991 rows=1,109 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=40
21. 47.347 47.347 ↓ 1.0 39,807 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_20 sd__14 (cost=0..2,131.11 rows=39,799 width=82) (actual time=1.337..47.347 rows=39,807 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1533
22. 42.363 42.363 ↓ 1.0 42,578 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_21 sd__15 (cost=0..1,984.67 rows=42,570 width=82) (actual time=0.727..42.363 rows=42,578 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1345
23. 46.996 46.996 ↓ 1.0 41,373 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_22 sd__16 (cost=0..2,150.6 rows=41,365 width=82) (actual time=0.617..46.996 rows=41,373 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1529
24. 212.342 212.342 ↓ 1.0 43,399 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_23 sd__17 (cost=0..6,736.98 rows=43,390 width=82) (actual time=0.621..212.342 rows=43,399 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=6085
25. 35.588 35.588 ↓ 1.0 42,733 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_24 sd__18 (cost=0..2,064.99 rows=42,725 width=82) (actual time=0.723..35.588 rows=42,733 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1423
26. 3.599 3.599 ↓ 1.0 3,440 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_25 sd__19 (cost=0..163.6 rows=3,439 width=82) (actual time=0.732..3.599 rows=3,440 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=111
27. 2.368 2.368 ↑ 1.0 1,283 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_26 sd__20 (cost=0..67.25 rows=1,283 width=82) (actual time=0.559..2.368 rows=1,283 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=47
28. 40.118 40.118 ↓ 1.0 41,917 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_27 sd__21 (cost=0..2,104.76 rows=41,909 width=82) (actual time=0.649..40.118 rows=41,917 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1475
29. 62.422 2,810.496 ↑ 1.0 207,338 1

Hash (cost=69,730.16..69,730.16 rows=207,567 width=38) (actual time=2,810.496..2,810.496 rows=207,338 loops=1)

  • Buffers: shared hit=18 read=66598
30. 15.942 2,748.074 ↑ 1.0 207,338 1

Append (cost=0..69,730.16 rows=207,567 width=38) (actual time=0.372..2,748.074 rows=207,338 loops=1)

  • Buffers: shared hit=18 read=66598
31. 7.356 7.356 ↓ 1.0 12,400 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_06 voip (cost=0..399 rows=12,398 width=38) (actual time=0.371..7.356 rows=12,400 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=212
32. 9.307 9.307 ↓ 1.0 14,097 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_07 voip_1 (cost=0..513.45 rows=14,094 width=38) (actual time=0.342..9.307 rows=14,097 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=301
33. 10.868 10.868 ↓ 1.0 13,762 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_08 voip_2 (cost=0..463.43 rows=13,759 width=38) (actual time=0.326..10.868 rows=13,762 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=256
34. 1,589.125 1,589.125 ↑ 1.0 14,090 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_09 voip_3 (cost=0..35,091.44 rows=14,360 width=38) (actual time=0.619..1,589.125 rows=14,090 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=34876
35. 2.205 2.205 ↑ 1.0 296 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_10 voip_4 (cost=0..42.44 rows=296 width=38) (actual time=0.394..2.205 rows=296 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=38
36. 1.418 1.418 ↑ 1.0 1,262 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_11 voip_5 (cost=0..35.93 rows=1,262 width=38) (actual time=0.333..1.418 rows=1,262 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=16
37. 0.782 0.782 ↑ 1.0 305 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_12 voip_6 (cost=0..9.57 rows=305 width=38) (actual time=0.416..0.782 rows=305 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=4
38. 15.150 15.150 ↓ 1.0 12,840 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_13 voip_7 (cost=0..468.6 rows=12,837 width=38) (actual time=0.386..15.15 rows=12,840 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=275
39. 10.695 10.695 ↓ 1.0 13,380 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_14 voip_8 (cost=0..457.7 rows=13,377 width=38) (actual time=0.451..10.695 rows=13,380 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=256
40. 53.242 53.242 ↓ 1.0 14,080 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_15 voip_9 (cost=0..1,650.2 rows=14,077 width=38) (actual time=0.635..53.242 rows=14,080 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1439
41. 681.604 681.604 ↓ 1.0 13,677 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_16 voip_10 (cost=0..19,847.15 rows=13,674 width=38) (actual time=1.341..681.604 rows=13,677 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=19642
42. 268.633 268.633 ↓ 1.0 13,440 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_17 voip_11 (cost=0..7,177.6 rows=13,437 width=38) (actual time=0.345..268.633 rows=13,440 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=6975
43. 1.344 1.344 ↑ 1.0 1,276 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_18 voip_12 (cost=0..36.14 rows=1,276 width=38) (actual time=0.6..1.344 rows=1,276 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=16
44. 0.825 0.825 ↑ 1.0 296 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_19 voip_13 (cost=0..9.44 rows=296 width=38) (actual time=0.432..0.825 rows=296 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=4
45. 9.111 9.111 ↓ 1.0 12,567 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_20 voip_14 (cost=0..435.5 rows=12,564 width=38) (actual time=0.414..9.111 rows=12,567 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=246
46. 5.895 5.895 ↓ 1.0 13,868 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_21 voip_15 (cost=0..423.02 rows=13,865 width=38) (actual time=0.43..5.895 rows=13,868 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=214
47. 11.328 11.328 ↓ 1.0 13,980 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_22 voip_16 (cost=0..465.7 rows=13,977 width=38) (actual time=0.309..11.328 rows=13,980 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=255
48. 37.889 37.889 ↓ 1.0 14,010 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_23 voip_17 (cost=0..1,339.15 rows=14,007 width=38) (actual time=0.408..37.889 rows=14,010 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1128
49. 5.370 5.370 ↓ 1.0 13,238 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_24 voip_18 (cost=0..403.57 rows=13,235 width=38) (actual time=0.347..5.37 rows=13,238 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=204
50. 1.609 1.609 ↑ 1.0 1,336 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_25 voip_19 (cost=0..38.04 rows=1,336 width=38) (actual time=0.943..1.609 rows=1,336 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=17
51. 2.134 2.134 ↑ 1.0 310 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_26 voip_20 (cost=0..9.65 rows=310 width=38) (actual time=1.721..2.134 rows=310 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=4
52. 6.242 6.242 ↓ 1.0 12,828 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_27 voip_21 (cost=0..413.42 rows=12,825 width=38) (actual time=0.389..6.242 rows=12,828 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=220
53.          

CTE conference_session_details

54. 305.397 10,243.374 ↑ 1.0 233,598 1

WindowAgg (cost=338,391.39..348,916.71 rows=233,896 width=2,747) (actual time=9,896.788..10,243.374 rows=233,598 loops=1)

  • Buffers: shared hit=23 read=226217
55. 318.079 9,937.977 ↑ 1.0 233,598 1

Sort (cost=338,391.39..338,976.13 rows=233,896 width=194) (actual time=9,896.771..9,937.977 rows=233,598 loops=1)

  • Sort Key: csd_.ms_source_id, (COALESCE(csd_.replaces_dialog_id_time, csd_.session_id_time)), (COALESCE(csd_.replaces_dialog_id_seq, csd_.session_id_seq)), csd_.replaces_dialog_id_time DESC NULLS LAST
  • Sort Method: quicksort Memory: 68194kB
  • Buffers: shared hit=23 read=226217
56. 139.856 9,619.898 ↑ 1.0 233,598 1

Hash Join (cost=101,590.29..317,533.12 rows=233,896 width=194) (actual time=3,442.31..9,619.898 rows=233,598 loops=1)

  • Buffers: shared hit=23 read=226217
57. 116.538 7,746.646 ↑ 1.0 233,594 1

Hash Join (cost=50,122.81..252,448.36 rows=233,896 width=166) (actual time=1,708.775..7,746.646 rows=233,594 loops=1)

  • Buffers: shared hit=23 read=178927
58. 56.199 5,922.170 ↑ 1.0 233,594 1

Hash Join (cost=1.4..189,943.36 rows=233,896 width=142) (actual time=0.708..5,922.17 rows=233,594 loops=1)

  • Buffers: shared hit=23 read=131797
59. 20.571 5,865.954 ↑ 1.0 233,594 1

Append (cost=0..188,604.83 rows=233,896 width=125) (actual time=0.677..5,865.954 rows=233,594 loops=1)

  • Buffers: shared hit=22 read=131797
60. 15.913 15.913 ↓ 1.0 8,405 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_06 csd_ (cost=0..585.08 rows=8,403 width=125) (actual time=0.677..15.913 rows=8,405 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=458
61. 21.342 21.342 ↓ 1.0 11,446 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_07 csd__1 (cost=0..944.69 rows=11,444 width=125) (actual time=0.705..21.342 rows=11,446 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=772
62. 24.829 24.829 ↓ 1.0 13,556 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_08 csd__2 (cost=0..1,081.34 rows=13,553 width=125) (actual time=0.663..24.829 rows=13,556 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=877
63. 3,397.162 3,397.162 ↑ 1.0 17,262 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_09 csd__3 (cost=0..93,126.13 rows=17,406 width=125) (actual time=0.751..3,397.162 rows=17,262 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=92865
64. 2.687 2.687 ↑ 1.0 174 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_10 csd__4 (cost=0..34.61 rows=174 width=125) (actual time=0.378..2.687 rows=174 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=31
65. 2.555 2.555 ↑ 1.0 2,056 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_11 csd__5 (cost=0..102.84 rows=2,056 width=125) (actual time=0.717..2.555 rows=2,056 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=71
66. 2.784 2.784 ↑ 1.0 2,448 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_12 csd__6 (cost=0..119.72 rows=2,448 width=125) (actual time=0.858..2.784 rows=2,448 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=82
67. 27.886 27.886 ↓ 1.0 14,369 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_13 csd__7 (cost=0..1,175.54 rows=14,366 width=125) (actual time=0.666..27.886 rows=14,369 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=959
68. 25.190 25.190 ↓ 1.0 15,357 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_14 csd__8 (cost=0..1,203.36 rows=15,354 width=125) (actual time=0.724..25.19 rows=15,357 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=972
69. 85.953 85.953 ↓ 1.0 15,318 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_15 csd__9 (cost=0..2,929.77 rows=15,315 width=125) (actual time=0.64..85.953 rows=15,318 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2699
70. 952.939 1,416.051 ↑ 1.0 15,428 1

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_16 csd__10 (cost=26,392.58..62,678.14 rows=15,623 width=125) (actual time=464.004..1,416.051 rows=15,428 loops=1)

  • Heap Blocks: exact=2670
  • Buffers: shared hit=2 read=9165
71. 463.112 463.112 ↑ 1.0 15,428 1

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_16_pkey (cost=0..26,388.67 rows=15,623 width=0) (actual time=463.112..463.112 rows=15,428 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=6495
72. 527.197 527.197 ↓ 1.0 14,059 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_17 csd__11 (cost=0..14,792.89 rows=14,056 width=125) (actual time=0.821..527.197 rows=14,059 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=14581
73. 6.538 6.538 ↑ 1.0 2,203 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_18 csd__12 (cost=0..121.05 rows=2,203 width=125) (actual time=0.676..6.538 rows=2,203 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=87
74. 2.826 2.826 ↑ 1.0 2,058 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_19 csd__13 (cost=0..111.87 rows=2,058 width=125) (actual time=0.647..2.826 rows=2,058 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=80
75. 24.326 24.326 ↓ 1.0 15,368 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_20 csd__14 (cost=0..1,122.52 rows=15,365 width=125) (actual time=0.714..24.326 rows=15,368 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=891
76. 26.224 26.224 ↓ 1.0 15,901 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_21 csd__15 (cost=0..983.51 rows=15,898 width=125) (actual time=0.666..26.224 rows=15,901 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=744
77. 33.000 33.000 ↓ 1.0 15,872 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_22 csd__16 (cost=0..1,010.08 rows=15,869 width=125) (actual time=0.638..33 rows=15,872 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=771
78. 137.731 137.731 ↓ 1.0 16,695 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_23 csd__17 (cost=0..4,205.43 rows=16,692 width=125) (actual time=4.078..137.731 rows=16,695 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=3954
79. 33.411 33.411 ↓ 1.0 15,816 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_24 csd__18 (cost=0..947.24 rows=15,813 width=125) (actual time=0.965..33.411 rows=15,816 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=709
80. 2.231 2.231 ↑ 1.0 2,250 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_25 csd__19 (cost=0..122.75 rows=2,250 width=125) (actual time=0.708..2.231 rows=2,250 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=88
81. 3.697 3.697 ↑ 1.0 1,992 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_26 csd__20 (cost=0..110.88 rows=1,992 width=125) (actual time=0.647..3.697 rows=1,992 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=80
82. 25.850 25.850 ↓ 1.0 15,561 1

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_27 csd__21 (cost=0..1,095.41 rows=15,558 width=125) (actual time=0.656..25.85 rows=15,561 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=861
83. 0.006 0.017 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=21) (actual time=0.017..0.017 rows=16 loops=1)

  • Buffers: shared hit=1
84. 0.011 0.011 ↑ 1.0 16 1

Seq Scan on ms_uri_types_sfb_cdr ut (cost=0..1.16 rows=16 width=21) (actual time=0.008..0.011 rows=16 loops=1)

  • Buffers: shared hit=1
85. 22.872 1,707.938 ↓ 1.0 89,409 1

Hash (cost=48,556.8..48,556.8 rows=89,406 width=30) (actual time=1,707.938..1,707.938 rows=89,409 loops=1)

  • Buffers: shared read=47130
86. 6.510 1,685.066 ↓ 1.0 89,409 1

Append (cost=0..48,556.8 rows=89,406 width=30) (actual time=1.002..1,685.066 rows=89,409 loops=1)

  • Buffers: shared read=47130
87. 1.217 1.217 ↑ 1.0 154 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_05 fjl (cost=0..20.02 rows=155 width=30) (actual time=1.002..1.217 rows=154 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=13
88. 3.966 3.966 ↑ 1.0 3,284 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_06 fjl_1 (cost=0..151.26 rows=3,284 width=30) (actual time=0.579..3.966 rows=3,284 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=102
89. 6.218 6.218 ↓ 1.0 4,237 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_07 fjl_2 (cost=0..222.56 rows=4,236 width=30) (actual time=0.68..6.218 rows=4,237 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=159
90. 7.381 7.381 ↓ 1.0 4,934 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_08 fjl_3 (cost=0..262.01 rows=4,933 width=30) (actual time=0.76..7.381 rows=4,934 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=188
91. 775.044 775.044 ↓ 1.0 6,335 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_09 fjl_4 (cost=0..21,698.03 rows=6,334 width=30) (actual time=0.715..775.044 rows=6,335 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=21603
92. 0.881 0.881 ↓ 1.0 89 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_10 fjl_5 (cost=0..6.33 rows=88 width=30) (actual time=0.385..0.881 rows=89 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=5
93. 1.782 1.782 ↑ 1.0 1,033 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_11 fjl_6 (cost=0..40.49 rows=1,033 width=30) (actual time=0.617..1.782 rows=1,033 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=25
94. 1.546 1.546 ↑ 1.0 1,145 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_12 fjl_7 (cost=0..46.17 rows=1,145 width=30) (actual time=0.678..1.546 rows=1,145 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=29
95. 8.212 8.212 ↓ 1.0 5,349 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_13 fjl_8 (cost=0..327.24 rows=5,348 width=30) (actual time=0.739..8.212 rows=5,349 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=247
96. 8.148 8.148 ↓ 1.0 5,707 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_14 fjl_9 (cost=0..313.61 rows=5,706 width=30) (actual time=0.805..8.148 rows=5,707 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=228
97. 19.222 19.222 ↓ 1.0 5,663 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_15 fjl_10 (cost=0..654.94 rows=5,662 width=30) (actual time=0.698..19.222 rows=5,663 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=570
98. 533.549 533.549 ↓ 1.0 5,675 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_16 fjl_11 (cost=0..15,100.12 rows=5,674 width=30) (actual time=1.29..533.549 rows=5,675 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=15015
99. 230.610 230.610 ↓ 1.0 5,244 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_17 fjl_12 (cost=0..6,767.66 rows=5,243 width=30) (actual time=0.68..230.61 rows=5,244 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=6689
100. 1.706 1.706 ↑ 1.0 1,052 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_18 fjl_13 (cost=0..44.78 rows=1,052 width=30) (actual time=0.755..1.706 rows=1,052 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=29
101. 1.549 1.549 ↑ 1.0 1,018 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_19 fjl_14 (cost=0..41.27 rows=1,018 width=30) (actual time=0.724..1.549 rows=1,018 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=26
102. 8.912 8.912 ↓ 1.0 5,830 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_20 fjl_15 (cost=0..333.45 rows=5,829 width=30) (actual time=0.761..8.912 rows=5,830 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=246
103. 6.410 6.410 ↓ 1.0 5,904 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_21 fjl_16 (cost=0..285.56 rows=5,903 width=30) (actual time=0.64..6.41 rows=5,904 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=197
104. 6.097 6.097 ↓ 1.0 5,914 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_22 fjl_17 (cost=0..266.71 rows=5,913 width=30) (actual time=0.658..6.097 rows=5,914 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=178
105. 31.725 31.725 ↓ 1.0 6,088 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_23 fjl_18 (cost=0..1,035.32 rows=6,087 width=30) (actual time=0.716..31.725 rows=6,088 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=944
106. 5.969 5.969 ↓ 1.0 5,963 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_24 fjl_19 (cost=0..260.44 rows=5,962 width=30) (actual time=0.615..5.969 rows=5,963 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=171
107. 2.302 2.302 ↑ 1.0 1,074 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_25 fjl_20 (cost=0..47.11 rows=1,074 width=30) (actual time=0.722..2.302 rows=1,074 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=31
108. 1.456 1.456 ↑ 1.0 1,012 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_26 fjl_21 (cost=0..43.18 rows=1,012 width=30) (actual time=0.67..1.456 rows=1,012 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=28
109. 6.845 6.845 ↓ 1.0 5,877 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_27 fjl_22 (cost=0..289.15 rows=5,876 width=30) (actual time=0.678..6.845 rows=5,877 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=201
110. 7.809 7.809 ↑ 1.0 828 1

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_28 fjl_23 (cost=0..299.38 rows=839 width=30) (actual time=0.734..7.809 rows=828 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=206
111. 30.874 1,733.396 ↑ 1.0 123,788 1

Hash (cost=49,285.05..49,285.05 rows=124,711 width=30) (actual time=1,733.396..1,733.396 rows=123,788 loops=1)

  • Buffers: shared read=47290
112. 8.923 1,702.522 ↓ 1.0 124,716 1

Append (cost=0..49,285.05 rows=124,711 width=30) (actual time=0.849..1,702.522 rows=124,716 loops=1)

  • Buffers: shared read=47290
113. 2.596 2.596 ↑ 1.0 125 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_05 mjl (cost=0..11.46 rows=126 width=30) (actual time=0.848..2.596 rows=125 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=6
114. 3.214 3.214 ↑ 1.0 4,571 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_06 mjl_1 (cost=0..169.56 rows=4,571 width=30) (actual time=0.579..3.214 rows=4,571 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=101
115. 6.266 6.266 ↓ 1.0 6,328 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_07 mjl_2 (cost=0..264.92 rows=6,327 width=30) (actual time=0.662..6.266 rows=6,328 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=170
116. 6.686 6.686 ↓ 1.0 7,260 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_08 mjl_3 (cost=0..309.9 rows=7,259 width=30) (actual time=0.734..6.686 rows=7,260 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=201
117. 762.444 762.444 ↓ 1.0 9,417 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_09 mjl_4 (cost=0..21,610.26 rows=9,416 width=30) (actual time=0.662..762.444 rows=9,417 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=21469
118. 0.709 0.709 ↑ 1.0 60 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_10 mjl_5 (cost=0..3.9 rows=60 width=30) (actual time=0.332..0.709 rows=60 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=3
119. 1.229 1.229 ↑ 1.0 745 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_11 mjl_6 (cost=0..24.17 rows=745 width=30) (actual time=0.019..1.229 rows=745 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=13
120. 3.222 3.222 ↑ 1.0 1,005 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_12 mjl_7 (cost=0..33.08 rows=1,005 width=30) (actual time=0.678..3.222 rows=1,005 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=18
121. 8.413 8.413 ↓ 1.0 7,807 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_13 mjl_8 (cost=0..376.11 rows=7,806 width=30) (actual time=0.646..8.413 rows=7,807 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=259
122. 7.864 7.864 ↓ 1.0 8,113 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_14 mjl_9 (cost=0..329.69 rows=8,112 width=30) (actual time=0.597..7.864 rows=8,113 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=208
123. 27.631 27.631 ↓ 1.0 8,213 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_15 mjl_10 (cost=0..871.19 rows=8,212 width=30) (actual time=0.635..27.631 rows=8,213 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=748
124. 552.542 552.542 ↓ 1.0 8,241 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_16 mjl_11 (cost=0..15,548.61 rows=8,240 width=30) (actual time=2.45..552.542 rows=8,241 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=15425
125. 222.207 222.207 ↓ 1.0 7,562 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_17 mjl_12 (cost=0..6,488.43 rows=7,561 width=30) (actual time=0.76..222.207 rows=7,562 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=6375
126. 1.484 1.484 ↑ 1.0 873 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_18 mjl_13 (cost=0..31.09 rows=873 width=30) (actual time=0.669..1.484 rows=873 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=18
127. 2.037 2.037 ↑ 1.0 758 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_19 mjl_14 (cost=0..25.37 rows=758 width=30) (actual time=0.754..2.037 rows=758 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=14
128. 9.590 9.590 ↓ 1.0 8,230 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_20 mjl_15 (cost=0..379.45 rows=8,229 width=30) (actual time=0.729..9.59 rows=8,230 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=256
129. 7.599 7.599 ↓ 1.0 8,475 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_21 mjl_16 (cost=0..305.12 rows=8,474 width=30) (actual time=0.646..7.599 rows=8,475 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=178
130. 5.486 5.486 ↓ 1.0 8,225 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_22 mjl_17 (cost=0..295.38 rows=8,224 width=30) (actual time=0.631..5.486 rows=8,225 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=172
131. 34.107 34.107 ↓ 1.0 9,051 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_23 mjl_18 (cost=0..1,145.76 rows=9,050 width=30) (actual time=1.316..34.107 rows=9,051 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=1010
132. 7.348 7.348 ↓ 1.0 8,653 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_24 mjl_19 (cost=0..317.79 rows=8,652 width=30) (actual time=0.699..7.348 rows=8,653 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=188
133. 4.177 4.177 ↑ 1.0 900 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_25 mjl_20 (cost=0..30.5 rows=900 width=30) (actual time=2.575..4.177 rows=900 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=17
134. 1.248 1.248 ↑ 1.0 707 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_26 mjl_21 (cost=0..23.61 rows=707 width=30) (actual time=0.694..1.248 rows=707 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=13
135. 7.613 7.613 ↓ 1.0 8,385 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_27 mjl_22 (cost=0..331.77 rows=8,384 width=30) (actual time=0.665..7.613 rows=8,385 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=206
136. 7.887 7.887 ↑ 1.0 1,012 1

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_28 mjl_23 (cost=0..357.9 rows=1,020 width=30) (actual time=0.688..7.887 rows=1,012 loops=1)

  • Filter: ((session_id_time >= '2020-01-05 16:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-28 07:59:59'::timestamp without time zone))
  • Buffers: shared read=222
137.          

CTE sessions_united

138. 76.132 33,736.150 ↓ 266.6 843,946 1

Append (cost=0..29,324.95 rows=3,166 width=4,931) (actual time=18,757.216..33,736.15 rows=843,946 loops=1)

  • Buffers: shared hit=1835719 read=708402 written=3
139. 20,416.812 20,416.812 ↓ 193.8 613,334 1

CTE Scan on session_details sd__22 (cost=0..14,244.48 rows=3,165 width=4,931) (actual time=18,757.215..20,416.812 rows=613,334 loops=1)

  • Filter: (rn = 1)
  • Buffers: shared hit=36 read=472447 written=3
140. 263.544 13,243.206 ↓ 230,612.0 230,612 1

Nested Loop (cost=9,596.18..15,048.81 rows=1 width=5,433) (actual time=10,259.065..13,243.206 rows=230,612 loops=1)

  • Buffers: shared hit=1835683 read=235955
141. 87.897 11,595.990 ↓ 230,612.0 230,612 1

Nested Loop (cost=9,595.76..15,048.29 rows=1 width=3,289) (actual time=10,259.04..11,595.99 rows=230,612 loops=1)

  • Buffers: shared hit=921145 read=235496
142. 225.698 11,046.869 ↓ 230,612.0 230,612 1

Hash Join (cost=9,595.34..15,045.05 rows=1 width=3,240) (actual time=10,259.019..11,046.869 rows=230,612 loops=1)

  • Buffers: shared hit=23 read=235099
143. 10,459.025 10,459.025 ↓ 199.8 233,591 1

CTE Scan on conference_session_details csd__22 (cost=0..5,262.66 rows=1,169 width=3,206) (actual time=9,896.792..10,459.025 rows=233,591 loops=1)

  • Filter: (rn = 1)
  • Buffers: shared hit=23 read=226217
144. 10.919 362.146 ↑ 1.0 20,381 1

Hash (cost=9,187.72..9,187.72 rows=20,381 width=75) (actual time=362.146..362.146 rows=20,381 loops=1)

  • Buffers: shared read=8882
145. 1.984 351.227 ↑ 1.0 20,381 1

Append (cost=0..9,187.72 rows=20,381 width=75) (actual time=0.806..351.227 rows=20,381 loops=1)

  • Buffers: shared read=8882
146. 1.550 1.550 ↑ 1.0 724 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_06 c (cost=0..25.86 rows=724 width=75) (actual time=0.805..1.55 rows=724 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=15
147. 1.461 1.461 ↑ 1.0 895 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_07 c_1 (cost=0..32.42 rows=895 width=75) (actual time=0.714..1.461 rows=895 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=19
148. 7.885 7.885 ↑ 1.0 1,089 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_08 c_2 (cost=0..41.34 rows=1,089 width=75) (actual time=4.214..7.885 rows=1,089 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=25
149. 159.003 159.003 ↑ 1.0 1,382 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_09 c_3 (cost=0..4,298.73 rows=1,382 width=75) (actual time=0.709..159.003 rows=1,382 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=4278
150. 0.441 0.441 ↑ 1.0 32 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_10 c_4 (cost=0..2.48 rows=32 width=75) (actual time=0.422..0.441 rows=32 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=2
151. 2.532 2.532 ↑ 1.0 345 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_11 c_5 (cost=0..12.18 rows=345 width=75) (actual time=1.17..2.532 rows=345 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=7
152. 1.319 1.319 ↑ 1.0 366 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_12 c_6 (cost=0..13.49 rows=366 width=75) (actual time=0.604..1.319 rows=366 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=8
153. 2.653 2.653 ↑ 1.0 1,195 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_13 c_7 (cost=0..64.92 rows=1,195 width=75) (actual time=0.666..2.653 rows=1,195 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=47
154. 3.260 3.260 ↑ 1.0 1,300 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_14 c_8 (cost=0..74.5 rows=1,300 width=75) (actual time=1.473..3.26 rows=1,300 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=55
155. 5.556 5.556 ↑ 1.0 1,274 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_15 c_9 (cost=0..145.11 rows=1,274 width=75) (actual time=0.586..5.556 rows=1,274 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=126
156. 109.026 109.026 ↑ 1.0 1,287 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_16 c_10 (cost=0..2,942.3 rows=1,287 width=75) (actual time=0.79..109.026 rows=1,287 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=2923
157. 32.704 32.704 ↑ 1.0 1,171 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_17 c_11 (cost=0..982.57 rows=1,171 width=75) (actual time=0.864..32.704 rows=1,171 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=965
158. 1.050 1.050 ↑ 1.0 346 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_18 c_12 (cost=0..13.19 rows=346 width=75) (actual time=0.679..1.05 rows=346 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=8
159. 1.198 1.198 ↑ 1.0 342 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_19 c_13 (cost=0..14.13 rows=342 width=75) (actual time=0.739..1.198 rows=342 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=9
160. 1.875 1.875 ↑ 1.0 1,298 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_20 c_14 (cost=0..63.47 rows=1,298 width=75) (actual time=0.749..1.875 rows=1,298 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=44
161. 1.738 1.738 ↑ 1.0 1,333 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_21 c_15 (cost=0..54 rows=1,333 width=75) (actual time=0.742..1.738 rows=1,333 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=34
162. 1.945 1.945 ↑ 1.0 1,368 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_22 c_16 (cost=0..61.52 rows=1,368 width=75) (actual time=0.644..1.945 rows=1,368 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=41
163. 6.564 6.564 ↑ 1.0 1,355 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_23 c_17 (cost=0..211.32 rows=1,355 width=75) (actual time=0.673..6.564 rows=1,355 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=191
164. 2.022 2.022 ↑ 1.0 1,266 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_24 c_18 (cost=0..47.99 rows=1,266 width=75) (actual time=0.645..2.022 rows=1,266 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=29
165. 1.017 1.017 ↑ 1.0 354 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_25 c_19 (cost=0..14.31 rows=354 width=75) (actual time=0.623..1.017 rows=354 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=9
166. 2.778 2.778 ↑ 1.0 349 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_26 c_20 (cost=0..13.23 rows=349 width=75) (actual time=0.623..2.778 rows=349 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=8
167. 1.666 1.666 ↑ 1.0 1,310 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_27 c_21 (cost=0..58.65 rows=1,310 width=75) (actual time=0.686..1.666 rows=1,310 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=39
168. 461.224 461.224 ↑ 1.0 1 230,612

Index Scan using ms_users_sfb_cdr_pkey on ms_users_sfb_cdr u (cost=0.42..3.24 rows=1 width=57) (actual time=0.002..0.002 rows=1 loops=230,612)

  • Index Cond: ((ms_source_id = c.ms_source_id) AND (user_id = c.organizer_id))
  • Buffers: shared hit=921122 read=397
169. 1,383.672 1,383.672 ↑ 1.0 1 230,612

Index Scan using ad_users_pkey on ad_users uad (cost=0.42..0.52 rows=1 width=70) (actual time=0.006..0.006 rows=1 loops=230,612)

  • Index Cond: (lower((u.email)::text) = (email_new)::text)
  • Buffers: shared hit=914538 read=459
170.          

CTE session_details_with_media_line

171. 3,418.610 84,288.307 ↑ 8.4 882,594 1

WindowAgg (cost=35,315,818.75..40,333,007.27 rows=7,446,662 width=5,769) (actual time=80,782.457..84,288.307 rows=882,594 loops=1)

  • Buffers: shared hit=57402840 read=809309 written=3
172. 1,090.723 80,869.697 ↑ 8.4 882,594 1

Sort (cost=35,315,818.75..35,334,435.41 rows=7,446,662 width=5,158) (actual time=80,782.423..80,869.697 rows=882,594 loops=1)

  • Sort Key: sd.ms_source_id, sd.conf_session_id_time, sd.conf_session_id_seq
  • Sort Method: quicksort Memory: 464929kB
  • Buffers: shared hit=57402836 read=809309 written=3
173. 1,179.680 79,778.974 ↑ 8.4 882,594 1

WindowAgg (cost=17,805,107.31..17,972,657.2 rows=7,446,662 width=5,158) (actual time=78,382.807..79,778.974 rows=882,594 loops=1)

  • Buffers: shared hit=57402836 read=809309 written=3
174. 2,152.844 78,599.294 ↑ 8.4 882,594 1

Sort (cost=17,805,107.31..17,823,723.96 rows=7,446,662 width=5,126) (actual time=78,382.783..78,599.294 rows=882,594 loops=1)

  • Sort Key: sd.ms_source_id, sd.session_id_time, sd.session_id_seq
  • Sort Method: quicksort Memory: 410805kB
  • Buffers: shared hit=57402836 read=809309 written=3
175. 1,018.279 76,446.450 ↑ 8.4 882,594 1

Merge Join (cost=396,164.13..563,753.76 rows=7,446,662 width=5,126) (actual time=75,103.71..76,446.45 rows=882,594 loops=1)

  • Buffers: shared hit=57402836 read=809309 written=3
176. 4,453.150 71,434.127 ↓ 266.6 843,946 1

Sort (cost=244,324.84..244,332.76 rows=3,166 width=5,050) (actual time=71,225.782..71,434.127 rows=843,946 loops=1)

  • Sort Key: (md5((d1.external_id)::text)), d1.ms_source_id
  • Sort Method: quicksort Memory: 437311kB
  • Buffers: shared hit=57402836 read=779908 written=3
177. 1,303.061 66,980.977 ↓ 266.6 843,946 1

Nested Loop (cost=0.28..244,140.76 rows=3,166 width=5,050) (actual time=18,767.487..66,980.977 rows=843,946 loops=1)

  • Buffers: shared hit=57402836 read=779908 written=3
178. 34,451.914 34,451.914 ↓ 266.6 843,946 1

CTE Scan on sessions_united sd (cost=0..63.32 rows=3,166 width=4,919) (actual time=18,757.22..34,451.914 rows=843,946 loops=1)

  • Buffers: shared hit=1835719 read=708402 written=3
179. 4,219.730 31,226.002 ↑ 24.0 1 843,946

Append (cost=0.28..76.85 rows=24 width=143) (actual time=0.023..0.037 rows=1 loops=843,946)

  • Buffers: shared hit=55567117 read=71506
180. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_05_pkey on ms_dialogs_sfb_cdr_p2020_01_05 d1 (cost=0.28..0.39 rows=1 width=151) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1687892
181. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_06_pkey on ms_dialogs_sfb_cdr_p2020_01_06 d1_1 (cost=0.41..2.55 rows=1 width=143) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2553370 read=1293
182. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_07_pkey on ms_dialogs_sfb_cdr_p2020_01_07 d1_2 (cost=0.41..2.82 rows=1 width=142) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2556393 read=1423
183. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_08_pkey on ms_dialogs_sfb_cdr_p2020_01_08 d1_3 (cost=0.41..2.77 rows=1 width=143) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2558196 read=1490
184. 4,219.730 4,219.730 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_09_pkey on ms_dialogs_sfb_cdr_p2020_01_09 d1_4 (cost=0.54..8.39 rows=1 width=142) (actual time=0.003..0.005 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=3410855 read=24848
185. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_10_pkey on ms_dialogs_sfb_cdr_p2020_01_10 d1_5 (cost=0.27..0.82 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1688051 read=152
186. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_11_pkey on ms_dialogs_sfb_cdr_p2020_01_11 d1_6 (cost=0.29..1.04 rows=1 width=148) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1692461 read=544
187. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_12_pkey on ms_dialogs_sfb_cdr_p2020_01_12 d1_7 (cost=0.29..0.85 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1691397 read=417
188. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_13_pkey on ms_dialogs_sfb_cdr_p2020_01_13 d1_8 (cost=0.42..3.96 rows=1 width=143) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2582777 read=3176
189. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_14_pkey on ms_dialogs_sfb_cdr_p2020_01_14 d1_9 (cost=0.42..4.01 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2584353 read=3257
190. 1,687.892 1,687.892 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_15_pkey on ms_dialogs_sfb_cdr_p2020_01_15 d1_10 (cost=0.42..4.8 rows=1 width=143) (actual time=0.001..0.002 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2585087 read=3618
191. 1,687.892 1,687.892 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_16_pkey on ms_dialogs_sfb_cdr_p2020_01_16 d1_11 (cost=0.42..6.54 rows=1 width=143) (actual time=0.002..0.002 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2582562 read=5173
192. 1,687.892 1,687.892 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_17_pkey on ms_dialogs_sfb_cdr_p2020_01_17 d1_12 (cost=0.42..5.3 rows=1 width=144) (actual time=0.001..0.002 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2581430 read=3856
193. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_18_pkey on ms_dialogs_sfb_cdr_p2020_01_18 d1_13 (cost=0.29..1.05 rows=1 width=152) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1692577 read=556
194. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_19_pkey on ms_dialogs_sfb_cdr_p2020_01_19 d1_14 (cost=0.29..0.84 rows=1 width=149) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1690682 read=404
195. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_20_pkey on ms_dialogs_sfb_cdr_p2020_01_20 d1_15 (cost=0.42..4.04 rows=1 width=143) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2583082 read=3293
196. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_21_pkey on ms_dialogs_sfb_cdr_p2020_01_21 d1_16 (cost=0.42..4.13 rows=1 width=143) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2586084 read=3419
197. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_22_pkey on ms_dialogs_sfb_cdr_p2020_01_22 d1_17 (cost=0.42..4.04 rows=1 width=142) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2585099 read=3320
198. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_23_pkey on ms_dialogs_sfb_cdr_p2020_01_23 d1_18 (cost=0.42..4.29 rows=1 width=143) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2587667 read=3588
199. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_24_pkey on ms_dialogs_sfb_cdr_p2020_01_24 d1_19 (cost=0.42..4.07 rows=1 width=144) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2586376 read=3340
200. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_25_pkey on ms_dialogs_sfb_cdr_p2020_01_25 d1_20 (cost=0.29..1.04 rows=1 width=151) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1692931 read=549
201. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_26_pkey on ms_dialogs_sfb_cdr_p2020_01_26 d1_21 (cost=0.29..0.85 rows=1 width=147) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=1690776 read=407
202. 1,687.892 1,687.892 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_27_pkey on ms_dialogs_sfb_cdr_p2020_01_27 d1_22 (cost=0.42..4.1 rows=1 width=143) (actual time=0.002..0.002 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2585183 read=3381
203. 843.946 843.946 ↓ 0.0 0 843,946

Index Scan using ms_dialogs_sfb_cdr_p2020_01_28_pkey on ms_dialogs_sfb_cdr_p2020_01_28 d1_23 (cost=0.42..4.17 rows=1 width=143) (actual time=0.001..0.001 rows=0 loops=843,946)

  • Index Cond: ((ms_source_id = sd.ms_source_id) AND (sd.session_id_time = session_id_time) AND (session_id_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (session_id_time < '2020-01-29 00:00:00'::timestamp without time zone) AND (sd.session_id_seq = session_id_seq))
  • Buffers: shared hit=2531836 read=2
204. 2,299.970 3,994.044 ↑ 1.0 467,744 1

Sort (cost=151,839.29..153,015.33 rows=470,415 width=203) (actual time=3,877.914..3,994.044 rows=467,744 loops=1)

  • Sort Key: (md5((d.dialog_id)::text)), d.ms_source_id
  • Sort Method: quicksort Memory: 159360kB
  • Buffers: shared read=29401
205. 486.588 1,694.074 ↑ 1.0 467,744 1

Hash Join (cost=25,677.49..107,517.79 rows=470,415 width=203) (actual time=609.807..1,694.074 rows=467,744 loops=1)

  • Buffers: shared read=29401
206. 35.133 600.365 ↓ 1.0 467,752 1

Append (cost=0..24,524.28 rows=467,661 width=80) (actual time=0.438..600.365 rows=467,752 loops=1)

  • Buffers: shared read=17508
207. 0.465 0.465 ↑ 1.0 36 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_05 ml_in (cost=0..2.54 rows=36 width=81) (actual time=0.437..0.465 rows=36 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=2
208. 2.908 2.908 ↑ 1.0 1,669 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_06 ml_in_1 (cost=0..86.03 rows=1,669 width=80) (actual time=0.8..2.908 rows=1,669 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=61
209. 3.011 3.011 ↑ 1.0 1,662 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_07 ml_in_2 (cost=0..87.93 rows=1,662 width=80) (actual time=0.706..3.011 rows=1,662 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=63
210. 3.598 3.598 ↑ 1.0 1,604 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_08 ml_in_3 (cost=0..80.06 rows=1,604 width=80) (actual time=0.759..3.598 rows=1,604 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=56
211. 24.866 24.866 ↓ 1.0 17,915 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_09 ml_in_4 (cost=0..965.72 rows=17,912 width=80) (actual time=0.654..24.866 rows=17,915 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=697
212. 2.566 2.566 ↑ 1.0 1,026 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_10 ml_in_5 (cost=0..61.39 rows=1,026 width=80) (actual time=0.808..2.566 rows=1,026 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=46
213. 5.112 5.112 ↓ 1.0 3,065 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_11 ml_in_6 (cost=0..183.97 rows=3,064 width=80) (actual time=0.656..5.112 rows=3,065 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=138
214. 2.805 2.805 ↑ 1.0 1,521 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_12 ml_in_7 (cost=0..90.81 rows=1,521 width=80) (actual time=0.785..2.805 rows=1,521 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=68
215. 44.758 44.758 ↓ 1.0 34,516 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_13 ml_in_8 (cost=0..1,822.74 rows=34,509 width=80) (actual time=0.692..44.758 rows=34,516 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1305
216. 56.611 56.611 ↓ 1.0 35,552 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_14 ml_in_9 (cost=0..1,859.28 rows=35,545 width=80) (actual time=0.91..56.611 rows=35,552 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1326
217. 44.411 44.411 ↓ 1.0 36,396 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_15 ml_in_10 (cost=0..1,889.94 rows=36,389 width=80) (actual time=0.719..44.411 rows=36,396 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1344
218. 40.552 40.552 ↓ 1.0 35,889 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_16 ml_in_11 (cost=0..1,720.34 rows=35,882 width=80) (actual time=0.776..40.552 rows=35,889 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1182
219. 35.660 35.660 ↓ 1.0 33,677 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_17 ml_in_12 (cost=0..1,681.15 rows=33,670 width=80) (actual time=0.759..35.66 rows=33,677 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1176
220. 4.378 4.378 ↓ 1.0 3,280 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_18 ml_in_13 (cost=0..186.2 rows=3,279 width=80) (actual time=0.728..4.378 rows=3,280 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=137
221. 1.805 1.805 ↑ 1.0 1,260 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_19 ml_in_14 (cost=0..66.9 rows=1,260 width=80) (actual time=0.576..1.805 rows=1,260 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=48
222. 36.035 36.035 ↓ 1.0 34,037 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_20 ml_in_15 (cost=0..1,806.56 rows=34,030 width=80) (actual time=0.733..36.035 rows=34,037 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1296
223. 36.951 36.951 ↓ 1.0 37,402 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_21 ml_in_16 (cost=0..1,993.03 rows=37,395 width=80) (actual time=0.726..36.951 rows=37,402 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1432
224. 47.805 47.805 ↓ 1.0 36,933 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_22 ml_in_17 (cost=0..1,949.99 rows=36,926 width=80) (actual time=0.675..47.805 rows=36,933 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1396
225. 36.711 36.711 ↓ 1.0 38,468 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_23 ml_in_18 (cost=0..2,017.02 rows=38,460 width=80) (actual time=0.688..36.711 rows=38,468 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1440
226. 42.221 42.221 ↓ 1.0 34,871 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_24 ml_in_19 (cost=0..1,849.07 rows=34,864 width=80) (actual time=0.764..42.221 rows=34,871 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1326
227. 4.785 4.785 ↓ 1.0 3,447 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_25 ml_in_20 (cost=0..200.7 rows=3,446 width=80) (actual time=0.669..4.785 rows=3,447 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=149
228. 2.636 2.636 ↑ 1.0 1,221 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_26 ml_in_21 (cost=0..66.31 rows=1,221 width=80) (actual time=0.797..2.636 rows=1,221 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=48
229. 35.857 35.857 ↓ 1.0 34,590 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_27 ml_in_22 (cost=0..1,830.85 rows=34,583 width=80) (actual time=0.695..35.857 rows=34,590 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1312
230. 48.725 48.725 ↓ 1.0 37,715 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_28 ml_in_23 (cost=0..2,025.72 rows=37,708 width=80) (actual time=0.69..48.725 rows=37,715 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1460
231. 156.884 607.121 ↓ 1.0 424,183 1

Hash (cost=18,255.74..18,255.74 rows=424,100 width=137) (actual time=607.121..607.121 rows=424,183 loops=1)

  • Buffers: shared read=11893
232. 29.700 450.237 ↓ 1.0 424,183 1

Append (cost=0..18,255.74 rows=424,100 width=137) (actual time=1.627..450.237 rows=424,183 loops=1)

  • Buffers: shared read=11893
233. 1.632 1.632 ↑ 1.0 36 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_05 d (cost=0..1.54 rows=36 width=137) (actual time=1.626..1.632 rows=36 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1
234. 2.656 2.656 ↑ 1.0 1,597 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_06 d_1 (cost=0..66.95 rows=1,597 width=139) (actual time=0.749..2.656 rows=1,597 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=43
235. 5.260 5.260 ↑ 1.0 1,553 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_07 d_2 (cost=0..62.3 rows=1,553 width=138) (actual time=2.038..5.26 rows=1,553 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=39
236. 2.803 2.803 ↑ 1.0 1,442 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_08 d_3 (cost=0..60.63 rows=1,442 width=137) (actual time=0.623..2.803 rows=1,442 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=39
237. 24.796 24.796 ↓ 1.0 16,342 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_09 d_4 (cost=0..766.13 rows=16,339 width=137) (actual time=0.7..24.796 rows=16,342 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=521
238. 3.327 3.327 ↑ 1.0 1,055 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_10 d_5 (cost=0..56.83 rows=1,055 width=141) (actual time=0.592..3.327 rows=1,055 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=41
239. 4.165 4.165 ↓ 1.0 3,023 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_11 d_6 (cost=0..145.34 rows=3,022 width=141) (actual time=0.608..4.165 rows=3,023 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=100
240. 3.236 3.236 ↑ 1.0 1,403 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_12 d_7 (cost=0..63.05 rows=1,403 width=134) (actual time=0.726..3.236 rows=1,403 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=42
241. 25.578 25.578 ↓ 1.0 31,160 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_13 d_8 (cost=0..1,337.4 rows=31,154 width=137) (actual time=0.664..25.578 rows=31,160 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=870
242. 29.824 29.824 ↓ 1.0 32,220 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_14 d_9 (cost=0..1,393.3 rows=32,214 width=137) (actual time=0.628..29.824 rows=32,220 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=910
243. 29.437 29.437 ↓ 1.0 32,991 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_15 d_10 (cost=0..1,390.87 rows=32,984 width=137) (actual time=0.693..29.437 rows=32,991 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=896
244. 21.477 21.477 ↓ 1.0 32,562 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_16 d_11 (cost=0..1,242.43 rows=32,556 width=137) (actual time=0.664..21.477 rows=32,562 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=754
245. 24.149 24.149 ↓ 1.0 30,595 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_17 d_12 (cost=0..1,275.92 rows=30,589 width=137) (actual time=0.741..24.149 rows=30,595 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=817
246. 4.334 4.334 ↓ 1.0 3,177 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_18 d_13 (cost=0..154.66 rows=3,176 width=140) (actual time=0.764..4.334 rows=3,177 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=107
247. 1.675 1.675 ↑ 1.0 1,226 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_19 d_14 (cost=0..51.39 rows=1,226 width=137) (actual time=0.672..1.675 rows=1,226 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=33
248. 26.844 26.844 ↓ 1.0 30,725 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_20 d_15 (cost=0..1,328.88 rows=30,719 width=137) (actual time=0.706..26.844 rows=30,725 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=868
249. 29.588 29.588 ↓ 1.0 33,724 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_21 d_16 (cost=0..1,474.86 rows=33,717 width=137) (actual time=0.688..29.588 rows=33,724 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=969
250. 36.207 36.207 ↓ 1.0 33,348 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_22 d_17 (cost=0..1,457.22 rows=33,341 width=137) (actual time=0.574..36.207 rows=33,348 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=957
251. 38.844 38.844 ↓ 1.0 34,404 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_23 d_18 (cost=0..1,472.06 rows=34,397 width=137) (actual time=0.701..38.844 rows=34,404 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=956
252. 41.558 41.558 ↓ 1.0 31,725 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_24 d_19 (cost=0..1,400.88 rows=31,719 width=137) (actual time=0.703..41.558 rows=31,725 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=925
253. 5.232 5.232 ↓ 1.0 3,401 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_25 d_20 (cost=0..165.01 rows=3,400 width=140) (actual time=0.778..5.232 rows=3,401 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=114
254. 2.296 2.296 ↑ 1.0 1,217 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_26 d_21 (cost=0..51.25 rows=1,217 width=137) (actual time=0.753..2.296 rows=1,217 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=33
255. 26.384 26.384 ↓ 1.0 31,221 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_27 d_22 (cost=0..1,344.32 rows=31,215 width=137) (actual time=0.763..26.384 rows=31,221 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=876
256. 29.235 29.235 ↓ 1.0 34,036 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_28 d_23 (cost=0..1,492.54 rows=34,029 width=137) (actual time=0.62..29.235 rows=34,036 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=982
257.          

CTE user_agent_def

258. 0.024 0.057 ↑ 1.0 42 1

HashAggregate (cost=1.77..2.19 rows=42 width=13) (actual time=0.052..0.057 rows=42 loops=1)

  • Group Key: uad_1.ua_type, uad_1.ua_category, uad_1.ms_source_id
  • Buffers: shared read=1
259. 0.033 0.033 ↑ 1.0 44 1

Seq Scan on ms_user_agent_def_sfb_cdr uad_1 (cost=0..1.44 rows=44 width=13) (actual time=0.03..0.033 rows=44 loops=1)

  • Buffers: shared read=1
260.          

CTE user_agent

261. 4.380 6.807 ↓ 1.0 6,514 1

HashAggregate (cost=363.31..428.02 rows=6,471 width=84) (actual time=5.268..6.807 rows=6,514 loops=1)

  • Group Key: ua.user_agent_key, ua.user_agent, ua.ua_type, uad_2.ua_category, ua.ms_source_id
  • Buffers: shared read=99
262. 1.436 2.427 ↓ 1.0 6,528 1

Hash Join (cost=2.1..282.42 rows=6,471 width=84) (actual time=0.072..2.427 rows=6,528 loops=1)

  • Buffers: shared read=99
263. 0.954 0.954 ↓ 1.0 6,514 1

Seq Scan on ms_user_agent_sfb_qoe ua (cost=0..162.71 rows=6,471 width=77) (actual time=0.028..0.954 rows=6,514 loops=1)

  • Buffers: shared read=98
264. 0.011 0.037 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=13) (actual time=0.037..0.037 rows=44 loops=1)

  • Buffers: shared read=1
265. 0.026 0.026 ↑ 1.0 44 1

Seq Scan on ms_user_agent_def_sfb_qoe uad_2 (cost=0..1.44 rows=44 width=13) (actual time=0.022..0.026 rows=44 loops=1)

  • Buffers: shared read=1
266.          

CTE audio_stream

267. 2,309.894 4,260.079 ↓ 1.9 697,597 1

GroupAggregate (cost=108,531.53..141,412.38 rows=371,400 width=217) (actual time=1,903.107..4,260.079 rows=697,597 loops=1)

  • Group Key: s.ms_source_id, s.conference_date_time, s.session_seq, s.media_line_label, s.stream_id, s.sender_is_caller_pai
  • Buffers: shared hit=4288 read=26617 dirtied=4
268. 695.359 1,950.185 ↓ 1.0 697,597 1

Sort (cost=108,531.53..110,275.17 rows=697,457 width=48) (actual time=1,902.913..1,950.185 rows=697,597 loops=1)

  • Sort Key: s.ms_source_id, s.conference_date_time, s.session_seq, s.media_line_label, s.stream_id, s.sender_is_caller_pai
  • Sort Method: quicksort Memory: 121032kB
  • Buffers: shared hit=4247 read=26617 dirtied=4
269. 141.181 1,254.826 ↓ 1.0 697,597 1

Hash Join (cost=1.75..40,837.24 rows=697,457 width=48) (actual time=0.575..1,254.826 rows=697,597 loops=1)

  • Buffers: shared hit=109 read=26417
270. 49.493 1,113.624 ↓ 1.0 697,597 1

Append (cost=0..36,901.96 rows=697,457 width=42) (actual time=0.409..1,113.624 rows=697,597 loops=1)

  • Buffers: shared hit=21 read=26417
271. 0.441 0.441 ↑ 1.0 70 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_05 s (cost=0..3.05 rows=70 width=43) (actual time=0.409..0.441 rows=70 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1
272. 4.953 4.953 ↓ 1.0 2,940 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_06 s_1 (cost=0..158.1 rows=2,939 width=42) (actual time=0.718..4.953 rows=2,940 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=113
273. 4.547 4.547 ↓ 1.0 2,791 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_07 s_2 (cost=0..145.87 rows=2,790 width=42) (actual time=0.737..4.547 rows=2,791 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=103
274. 4.479 4.479 ↓ 1.0 2,535 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_08 s_3 (cost=0..136.03 rows=2,534 width=42) (actual time=0.678..4.479 rows=2,535 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=97
275. 40.493 40.493 ↓ 1.0 29,635 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_09 s_4 (cost=0..1,619.53 rows=29,629 width=42) (actual time=0.689..40.493 rows=29,635 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1174
276. 0.030 0.030 ↑ 1.0 2 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_10 s_5 (cost=0..1.03 rows=2 width=43) (actual time=0.028..0.03 rows=2 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1
277. 8.601 8.601 ↓ 1.0 5,949 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_11 s_6 (cost=0..307.24 rows=5,948 width=42) (actual time=0.628..8.601 rows=5,949 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=217
278. 7.666 7.666 ↓ 1.0 2,548 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_12 s_7 (cost=0..110.22 rows=2,547 width=42) (actual time=0.829..7.666 rows=2,548 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=71
279. 69.768 69.768 ↓ 1.0 55,725 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_13 s_8 (cost=0..2,952.88 rows=55,714 width=42) (actual time=0.737..69.768 rows=55,725 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2116
280. 76.953 76.953 ↓ 1.0 57,970 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_14 s_9 (cost=0..3,088.55 rows=57,958 width=42) (actual time=0.823..76.953 rows=57,970 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2218
281. 73.307 73.307 ↓ 1.0 59,031 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_15 s_10 (cost=0..3,108.47 rows=59,019 width=42) (actual time=0.631..73.307 rows=59,031 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2222
282. 69.556 69.556 ↓ 1.0 57,934 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_16 s_11 (cost=0..2,909.01 rows=57,922 width=42) (actual time=0.756..69.556 rows=57,934 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=2040
283. 97.302 97.302 ↓ 1.0 55,305 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_17 s_12 (cost=0..2,897.57 rows=55,294 width=42) (actual time=0.39..97.302 rows=55,305 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2067
284. 8.934 8.934 ↓ 1.0 6,176 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_18 s_13 (cost=0..315.64 rows=6,175 width=42) (actual time=0.927..8.934 rows=6,176 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=222
285. 2.418 2.418 ↑ 1.0 2,369 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_19 s_14 (cost=0..95.53 rows=2,369 width=42) (actual time=0.542..2.418 rows=2,369 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=59
286. 72.871 72.871 ↓ 1.0 54,802 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_20 s_15 (cost=0..2,947.03 rows=54,791 width=42) (actual time=0.637..72.871 rows=54,802 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2124
287. 91.424 91.424 ↓ 1.0 60,253 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_21 s_16 (cost=0..3,243.8 rows=60,241 width=42) (actual time=0.661..91.424 rows=60,253 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2339
288. 78.420 78.420 ↓ 1.0 59,566 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_22 s_17 (cost=0..3,181.49 rows=59,554 width=42) (actual time=0.783..78.42 rows=59,566 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2287
289. 93.344 93.344 ↓ 1.0 60,980 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_23 s_18 (cost=0..3,231.7 rows=60,968 width=42) (actual time=3.578..93.344 rows=60,980 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2316
290. 77.073 77.073 ↓ 1.0 56,465 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_24 s_19 (cost=0..3,028.97 rows=56,454 width=42) (actual time=0.782..77.073 rows=56,465 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2181
291. 21.442 21.442 ↓ 1.0 6,603 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_25 s_20 (cost=0..342.05 rows=6,602 width=42) (actual time=3.306..21.442 rows=6,603 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=242
292. 13.989 13.989 ↑ 1.0 2,400 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_26 s_21 (cost=0..102 rows=2,400 width=42) (actual time=2.728..13.989 rows=2,400 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=65
293. 146.120 146.120 ↓ 1.0 55,548 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_27 s_22 (cost=0..2,976.22 rows=55,537 width=42) (actual time=2.874..146.12 rows=55,548 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=2143
294. 0.007 0.021 ↑ 1.0 30 1

Hash (cost=1.3..1.3 rows=30 width=10) (actual time=0.021..0.021 rows=30 loops=1)

  • Buffers: shared hit=1
295. 0.014 0.014 ↑ 1.0 30 1

Seq Scan on ms_payload_description_sfb_qoe pd (cost=0..1.3 rows=30 width=10) (actual time=0.009..0.014 rows=30 loops=1)

  • Buffers: shared hit=1
296.          

CTE video_stream

297. 101.890 205.583 ↑ 1.0 33,287 1

GroupAggregate (cost=4,604.19..6,519.12 rows=33,303 width=185) (actual time=101.601..205.583 rows=33,287 loops=1)

  • Group Key: s_23.ms_source_id, s_23.conference_date_time, s_23.session_seq, s_23.media_line_label, s_23.stream_id, s_23.sender_is_caller_pai
  • Buffers: shared hit=21 read=1403
298. 21.817 103.693 ↓ 1.0 33,309 1

Sort (cost=4,604.19..4,687.45 rows=33,303 width=40) (actual time=101.555..103.693 rows=33,309 loops=1)

  • Sort Key: s_23.ms_source_id, s_23.conference_date_time, s_23.session_seq, s_23.media_line_label, s_23.stream_id, s_23.sender_is_caller_pai
  • Sort Method: quicksort Memory: 6191kB
  • Buffers: shared hit=21 read=1403
299. 6.740 81.876 ↓ 1.0 33,309 1

Hash Join (cost=1.9..2,102.58 rows=33,303 width=40) (actual time=0.493..81.876 rows=33,309 loops=1)

  • Buffers: shared hit=2 read=1403
300. 2.534 75.114 ↓ 1.0 33,309 1

Append (cost=0.14..1,912.39 rows=33,303 width=34) (actual time=0.463..75.114 rows=33,309 loops=1)

  • Buffers: shared hit=1 read=1403
301. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ms_video_stream_sfb_qoe_p2020_01_05_pkey on ms_video_stream_sfb_qoe_p2020_01_05 s_23 (cost=0.14..9.75 rows=1 width=43) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1
302. 0.830 0.830 ↑ 1.0 95 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_06 s_24 (cost=0..4.42 rows=95 width=34) (actual time=0.45..0.83 rows=95 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=3
303. 1.422 1.422 ↑ 1.0 129 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_07 s_25 (cost=0..6.93 rows=129 width=34) (actual time=0.649..1.422 rows=129 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=5
304. 0.754 0.754 ↑ 1.0 123 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_08 s_26 (cost=0..5.84 rows=123 width=34) (actual time=0.332..0.754 rows=123 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=4
305. 3.995 3.995 ↑ 1.0 1,330 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_09 s_27 (cost=0..71.95 rows=1,330 width=34) (actual time=0.584..3.995 rows=1,330 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=52
306. 2.107 2.107 ↑ 1.0 1 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_10 s_28 (cost=0..1.01 rows=1 width=36) (actual time=2.107..2.107 rows=1 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1
307. 0.360 0.360 ↑ 1.0 28 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_11 s_29 (cost=0..1.42 rows=28 width=35) (actual time=0.349..0.36 rows=28 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1
308. 0.712 0.712 ↑ 1.0 121 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_12 s_30 (cost=0..5.81 rows=121 width=35) (actual time=0.316..0.712 rows=121 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=4
309. 4.664 4.664 ↑ 1.0 2,758 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_13 s_31 (cost=0..162.37 rows=2,758 width=34) (actual time=0.625..4.664 rows=2,758 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=121
310. 5.468 5.468 ↑ 1.0 2,741 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_14 s_32 (cost=0..153.12 rows=2,741 width=34) (actual time=0.691..5.468 rows=2,741 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=112
311. 4.772 4.772 ↓ 1.0 2,831 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_15 s_33 (cost=0..170.47 rows=2,830 width=34) (actual time=0.651..4.772 rows=2,831 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=128
312. 3.985 3.985 ↓ 1.0 2,763 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_16 s_34 (cost=0..133.44 rows=2,762 width=34) (actual time=0.727..3.985 rows=2,763 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=92
313. 4.588 4.588 ↑ 1.0 2,453 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_17 s_35 (cost=0..136.8 rows=2,453 width=34) (actual time=1.003..4.588 rows=2,453 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=100
314. 0.715 0.715 ↑ 1.0 76 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_18 s_36 (cost=0..4.14 rows=76 width=35) (actual time=0.344..0.715 rows=76 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=3
315. 0.356 0.356 ↑ 1.0 35 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_19 s_37 (cost=0..2.52 rows=35 width=34) (actual time=0.334..0.356 rows=35 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=2
316. 4.185 4.185 ↓ 1.0 2,893 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_20 s_38 (cost=0..173.39 rows=2,892 width=34) (actual time=0.701..4.185 rows=2,893 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=130
317. 6.821 6.821 ↓ 1.0 3,114 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_21 s_39 (cost=0..179.71 rows=3,113 width=34) (actual time=0.7..6.821 rows=3,114 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=133
318. 7.595 7.595 ↓ 1.0 2,855 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_22 s_40 (cost=0..170.82 rows=2,854 width=34) (actual time=1.831..7.595 rows=2,855 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=128
319. 6.204 6.204 ↓ 1.0 3,324 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_23 s_41 (cost=0..188.86 rows=3,323 width=34) (actual time=0.735..6.204 rows=3,324 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=139
320. 5.090 5.090 ↑ 1.0 2,734 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_24 s_42 (cost=0..156.01 rows=2,734 width=34) (actual time=0.681..5.09 rows=2,734 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=115
321. 0.438 0.438 ↑ 1.0 42 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_25 s_43 (cost=0..2.63 rows=42 width=35) (actual time=0.371..0.438 rows=42 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=2
322. 0.286 0.286 ↑ 1.0 4 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_26 s_44 (cost=0..1.06 rows=4 width=36) (actual time=0.284..0.286 rows=4 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1
323. 7.221 7.221 ↓ 1.0 2,859 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_27 s_45 (cost=0..169.88 rows=2,858 width=34) (actual time=0.662..7.221 rows=2,859 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=127
324. 0.012 0.022 ↑ 1.0 30 1

Hash (cost=1.3..1.3 rows=30 width=10) (actual time=0.022..0.022 rows=30 loops=1)

  • Buffers: shared hit=1
325. 0.010 0.010 ↑ 1.0 30 1

Seq Scan on ms_payload_description_sfb_qoe pd_1 (cost=0..1.3 rows=30 width=10) (actual time=0.006..0.01 rows=30 loops=1)

  • Buffers: shared hit=1
326.          

CTE app_sharing_stream

327. 203.566 374.456 ↓ 1.1 75,861 1

GroupAggregate (cost=9,964.55..14,197.69 rows=71,187 width=162) (actual time=166.155..374.456 rows=75,861 loops=1)

  • Group Key: s_46.ms_source_id, s_46.conference_date_time, s_46.session_seq, s_46.media_line_label, s_46.stream_id, s_46.sender_is_caller_pai
  • Buffers: shared hit=3 read=2261
328. 55.554 170.890 ↓ 1.0 75,861 1

Sort (cost=9,964.55..10,154.18 rows=75,850 width=44) (actual time=166.113..170.89 rows=75,861 loops=1)

  • Sort Key: s_46.ms_source_id, s_46.conference_date_time, s_46.session_seq, s_46.media_line_label, s_46.stream_id, s_46.sender_is_caller_pai
  • Sort Method: quicksort Memory: 8999kB
  • Buffers: shared hit=3 read=2261
329. 10.538 115.336 ↓ 1.0 75,861 1

Hash Join (cost=1.89..3,816.58 rows=75,850 width=44) (actual time=2.047..115.336 rows=75,861 loops=1)

  • Buffers: shared hit=3 read=2261
330. 5.677 104.779 ↓ 1.0 75,861 1

Append (cost=0.14..3,416.62 rows=75,850 width=38) (actual time=2.012..104.779 rows=75,861 loops=1)

  • Buffers: shared hit=2 read=2261
331. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ms_app_sharing_stream_sfb_qoe_p2020_01_05_pkey on ms_app_sharing_stream_sfb_qoe_p2020_01_05 s_46 (cost=0.14..8.85 rows=1 width=60) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1
332. 2.418 2.418 ↑ 1.0 204 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_06 s_47 (cost=0..8.06 rows=204 width=38) (actual time=1.993..2.418 rows=204 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=5
333. 1.117 1.117 ↑ 1.0 286 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_07 s_48 (cost=0..12.29 rows=286 width=38) (actual time=0.563..1.117 rows=286 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=8
334. 1.216 1.216 ↑ 1.0 249 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_08 s_49 (cost=0..10.73 rows=249 width=38) (actual time=0.664..1.216 rows=249 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=7
335. 3.779 3.779 ↓ 1.0 2,873 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_09 s_50 (cost=0..132.09 rows=2,872 width=38) (actual time=0.684..3.779 rows=2,873 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=89
336. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ms_app_sharing_stream_sfb_qoe_p2020_01_10_pkey on ms_app_sharing_stream_sfb_qoe_p2020_01_10 s_51 (cost=0.14..8.85 rows=1 width=60) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1
337. 0.358 0.358 ↑ 1.0 46 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_11 s_52 (cost=0..1.69 rows=46 width=38) (actual time=0.339..0.358 rows=46 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1
338. 1.054 1.054 ↑ 1.0 242 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_12 s_53 (cost=0..8.63 rows=242 width=38) (actual time=0.581..1.054 rows=242 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=5
339. 9.347 9.347 ↓ 1.0 6,231 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_13 s_54 (cost=0..283.47 rows=6,230 width=38) (actual time=0.506..9.347 rows=6,231 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=190
340. 6.792 6.792 ↓ 1.0 6,071 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_14 s_55 (cost=0..292.06 rows=6,070 width=38) (actual time=0.694..6.792 rows=6,071 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=201
341. 7.720 7.720 ↓ 1.0 6,669 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_15 s_56 (cost=0..312.03 rows=6,668 width=38) (actual time=0.714..7.72 rows=6,669 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=212
342. 6.386 6.386 ↓ 1.0 6,705 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_16 s_57 (cost=0..266.57 rows=6,704 width=38) (actual time=0.721..6.386 rows=6,705 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=166
343. 5.318 5.318 ↓ 1.0 5,595 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_17 s_58 (cost=0..214.93 rows=5,594 width=38) (actual time=0.695..5.318 rows=5,595 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=131
344. 0.765 0.765 ↓ 1.0 161 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_18 s_59 (cost=0..6.42 rows=160 width=38) (actual time=0.34..0.765 rows=161 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=4
345. 0.375 0.375 ↑ 1.0 80 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_19 s_60 (cost=0..3.2 rows=80 width=38) (actual time=0.337..0.375 rows=80 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=2
346. 6.659 6.659 ↓ 1.0 6,206 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_20 s_61 (cost=0..281.09 rows=6,205 width=38) (actual time=0.576..6.659 rows=6,206 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=188
347. 8.632 8.632 ↓ 1.0 6,816 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_21 s_62 (cost=0..314.24 rows=6,815 width=38) (actual time=0.8..8.632 rows=6,816 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=212
348. 11.514 11.514 ↓ 1.0 6,741 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_22 s_63 (cost=0..303.12 rows=6,740 width=38) (actual time=0.674..11.514 rows=6,741 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=202
349. 8.104 8.104 ↓ 1.0 7,342 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_23 s_64 (cost=0..330.13 rows=7,341 width=38) (actual time=0.672..8.104 rows=7,342 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=220
350. 7.900 7.900 ↓ 1.0 6,635 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_24 s_65 (cost=0..304.52 rows=6,634 width=38) (actual time=0.731..7.9 rows=6,635 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=205
351. 1.147 1.147 ↑ 1.0 195 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_25 s_66 (cost=0..7.92 rows=195 width=38) (actual time=0.699..1.147 rows=195 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=5
352. 0.402 0.402 ↑ 1.0 12 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_26 s_67 (cost=0..1.18 rows=12 width=38) (actual time=0.397..0.402 rows=12 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1
353. 8.076 8.076 ↓ 1.0 6,502 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_27 s_68 (cost=0..304.53 rows=6,501 width=38) (actual time=0.686..8.076 rows=6,502 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=207
354. 0.009 0.019 ↑ 1.0 30 1

Hash (cost=1.3..1.3 rows=30 width=10) (actual time=0.019..0.019 rows=30 loops=1)

  • Buffers: shared hit=1
355. 0.010 0.010 ↑ 1.0 30 1

Seq Scan on ms_payload_description_sfb_qoe pd_2 (cost=0..1.3 rows=30 width=10) (actual time=0.006..0.01 rows=30 loops=1)

  • Buffers: shared hit=1
356.          

CTE prepared_dataset

357. 4,613.352 139,580.466 ↑ 8.4 884,957 1

WindowAgg (cost=115,922,158.72..296,801,578.7 rows=7,446,662 width=10,503) (actual time=127,646.733..139,580.466 rows=884,957 loops=1)

  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
358. 6,092.142 127,887.458 ↑ 8.4 884,957 1

Sort (cost=115,922,158.72..115,940,775.37 rows=7,446,662 width=10,445) (actual time=127,646.632..127,887.458 rows=884,957 loops=1)

  • Sort Key: sd_ml.ms_source_id, sd_ml.dialog, sd_ml.media_line_label
  • Sort Method: quicksort Memory: 1072559kB
  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
359. 1,665.910 121,795.316 ↑ 8.4 884,957 1

WindowAgg (cost=81,550,137.47..81,754,920.67 rows=7,446,662 width=10,445) (actual time=120,070.547..121,795.316 rows=884,957 loops=1)

  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
360. 2,105.147 120,129.406 ↑ 8.4 884,957 1

Sort (cost=81,550,137.47..81,568,754.12 rows=7,446,662 width=10,413) (actual time=120,070.45..120,129.406 rows=884,957 loops=1)

  • Sort Key: sd_ml.ms_source_id, sd_ml.conf_session_id_time, sd_ml.conf_session_id_seq, sd_ml.conf_instance, sd_ml.conference_uri_id
  • Sort Method: quicksort Memory: 852974kB
  • Buffers: shared hit=57969183 read=987689 dirtied=211 written=124
361. 837.013 118,024.259 ↑ 8.4 884,957 1

Nested Loop (cost=315,887.43..47,484,710.92 rows=7,446,662 width=10,413) (actual time=95,159.139..118,024.259 rows=884,957 loops=1)

  • Buffers: shared hit=57969177 read=987689 dirtied=211 written=124
362. 853.310 117,187.246 ↑ 8.4 884,957 1

Nested Loop (cost=315,887.29..46,235,650.83 rows=7,446,662 width=9,881) (actual time=95,159.126..117,187.246 rows=884,957 loops=1)

  • Buffers: shared hit=57708311 read=987689 dirtied=211 written=124
363. 521.931 116,333.936 ↑ 8.4 884,957 1

Hash Join (cost=315,887.15..44,986,590.75 rows=7,446,662 width=9,349) (actual time=95,159.102..116,333.936 rows=884,957 loops=1)

  • Buffers: shared hit=57457722 read=987689 dirtied=211 written=124
364. 543.474 115,747.653 ↑ 8.4 884,957 1

Hash Join (cost=309,630.82..44,941,239.45 rows=7,446,662 width=9,336) (actual time=95,093.62..115,747.653 rows=884,957 loops=1)

  • Buffers: shared hit=57456162 read=987689 dirtied=211 written=124
365. 515.625 115,139.061 ↑ 8.4 884,957 1

Hash Join (cost=303,374.5..44,895,888.15 rows=7,446,662 width=9,323) (actual time=95,027.398..115,139.061 rows=884,957 loops=1)

  • Buffers: shared hit=57454602 read=987689 dirtied=211 written=124
366. 533.671 114,557.709 ↑ 8.4 884,957 1

Hash Join (cost=297,118.17..44,850,536.85 rows=7,446,662 width=9,314) (actual time=94,960.572..114,557.709 rows=884,957 loops=1)

  • Buffers: shared hit=57453042 read=987689 dirtied=211 written=124
367. 510.504 113,958.985 ↑ 8.4 884,957 1

Hash Join (cost=290,861.85..44,805,185.54 rows=7,446,662 width=9,305) (actual time=94,894.394..113,958.985 rows=884,957 loops=1)

  • Buffers: shared hit=57451482 read=987689 dirtied=211 written=124
368. 529.062 113,383.079 ↑ 8.4 884,957 1

Hash Join (cost=284,605.52..44,759,834.24 rows=7,446,662 width=9,292) (actual time=94,827.799..113,383.079 rows=884,957 loops=1)

  • Buffers: shared hit=57449922 read=987689 dirtied=211 written=124
369. 519.384 112,789.340 ↑ 8.4 884,957 1

Hash Join (cost=278,349.2..44,714,482.94 rows=7,446,662 width=9,279) (actual time=94,762.034..112,789.34 rows=884,957 loops=1)

  • Buffers: shared hit=57448362 read=987689 dirtied=211 written=124
370. 511.365 112,267.684 ↑ 8.4 884,957 1

Hash Join (cost=278,122.71..32,620,000.52 rows=7,446,662 width=8,623) (actual time=94,759.707..112,267.684 rows=884,957 loops=1)

  • Buffers: shared hit=57448362 read=987689 dirtied=211 written=124
371. 515.179 111,745.295 ↑ 8.4 884,957 1

Hash Join (cost=277,896.23..20,529,081.25 rows=7,446,662 width=7,965) (actual time=94,748.62..111,745.295 rows=884,957 loops=1)

  • Buffers: shared hit=57448362 read=987590 dirtied=211 written=124
372. 536.180 111,199.219 ↑ 8.4 884,957 1

Hash Join (cost=274,354.6..20,486,443.5 rows=7,446,662 width=7,952) (actual time=94,717.153..111,199.219 rows=884,957 loops=1)

  • Buffers: shared hit=57446738 read=987590 dirtied=211 written=124
373. 545.326 110,632.710 ↑ 8.4 884,957 1

Hash Join (cost=270,812.98..20,443,805.81 rows=7,446,662 width=7,939) (actual time=94,686.22..110,632.71 rows=884,957 loops=1)

  • Buffers: shared hit=57445114 read=987590 dirtied=211 written=124
374. 533.729 110,087.369 ↑ 8.4 884,957 1

Hash Join (cost=270,800.5..20,423,831.63 rows=7,446,662 width=7,821) (actual time=94,686.198..110,087.369 rows=884,957 loops=1)

  • Buffers: shared hit=57445113 read=987590 dirtied=211 written=124
375. 539.746 109,553.594 ↑ 8.4 884,957 1

Hash Join (cost=270,788.03..20,403,857.45 rows=7,446,662 width=7,703) (actual time=94,686.145..109,553.594 rows=884,957 loops=1)

  • Buffers: shared hit=57445112 read=987590 dirtied=211 written=124
376. 475.655 109,013.815 ↑ 8.4 884,957 1

Hash Join (cost=270,786.56..20,346,477.89 rows=7,446,662 width=7,559) (actual time=94,686.1..109,013.815 rows=884,957 loops=1)

  • Buffers: shared hit=57445112 read=987590 dirtied=211 written=124
377. 451.291 108,534.921 ↑ 8.4 884,957 1

Hash Join (cost=270,423.43..20,307,019.74 rows=7,446,662 width=7,517) (actual time=94,682.761..108,534.921 rows=884,957 loops=1)

  • Buffers: shared hit=57445007 read=987590 dirtied=211 written=124
378. 479.714 108,080.308 ↑ 8.4 884,957 1

Hash Join (cost=270,060.31..20,267,561.59 rows=7,446,662 width=7,475) (actual time=94,679.353..108,080.308 rows=884,957 loops=1)

  • Buffers: shared hit=57444902 read=987590 dirtied=211 written=124
379. 494.368 107,597.206 ↑ 8.4 884,957 1

Hash Join (cost=269,697.18..20,228,103.44 rows=7,446,662 width=7,433) (actual time=94,675.882..107,597.206 rows=884,957 loops=1)

  • Buffers: shared hit=57444797 read=987590 dirtied=211 written=124
380. 580.142 107,099.451 ↑ 8.4 884,957 1

Hash Join (cost=269,334.06..20,188,645.29 rows=7,446,662 width=7,391) (actual time=94,672.409..107,099.451 rows=884,957 loops=1)

  • Buffers: shared hit=57444692 read=987590 dirtied=211 written=124
381. 542.795 106,513.171 ↑ 8.4 884,957 1

Hash Join (cost=268,838.36..20,131,927.3 rows=7,446,662 width=7,175) (actual time=94,666.185..106,513.171 rows=884,957 loops=1)

  • Buffers: shared hit=57444547 read=987589 dirtied=211 written=124
382. 495.495 105,966.536 ↑ 8.4 884,957 1

Hash Join (cost=268,426.41..20,092,420.34 rows=7,446,662 width=7,103) (actual time=94,662.264..105,966.536 rows=884,957 loops=1)

  • Buffers: shared hit=57444402 read=987589 dirtied=211 written=124
383. 515.016 105,471.031 ↑ 8.4 884,957 1

Hash Join (cost=268,425.01..20,047,622.61 rows=7,446,662 width=7,088) (actual time=94,662.245..105,471.031 rows=884,957 loops=1)

  • Buffers: shared hit=57444401 read=987589 dirtied=211 written=124
384. 812.620 104,955.984 ↑ 8.4 884,957 1

Hash Join (cost=268,423.61..20,002,824.89 rows=7,446,662 width=7,073) (actual time=94,662.192..104,955.984 rows=884,957 loops=1)

  • Buffers: shared hit=57444400 read=987589 dirtied=211 written=124
385. 735.068 103,130.172 ↑ 8.4 884,957 1

Hash Join (cost=219,242.31..19,897,421.29 rows=7,446,662 width=6,973) (actual time=93,644.541..103,130.172 rows=884,957 loops=1)

  • Buffers: shared hit=57417436 read=987589 dirtied=211 written=124
386. 522.022 100,315.957 ↑ 8.4 884,957 1

Hash Join (cost=170,061.01..19,792,017.7 rows=7,446,662 width=6,873) (actual time=91,561.004..100,315.957 rows=884,957 loops=1)

  • Buffers: shared hit=57407200 read=970843 dirtied=4 written=3
387. 547.996 99,771.319 ↑ 8.4 883,593 1

Hash Join (cost=168,452.18..18,375,543.07 rows=7,446,662 width=6,733) (actual time=91,538.363..99,771.319 rows=883,593 loops=1)

  • Buffers: shared hit=57407200 read=970843 dirtied=4 written=3
388. 490.212 98,793.751 ↑ 8.4 882,912 1

Hash Join (cost=166,843.35..16,959,068.44 rows=7,446,662 width=6,593) (actual time=91,108.767..98,793.751 rows=882,912 loops=1)

  • Buffers: shared hit=57407197 read=968582 dirtied=4 written=3
389. 494.030 98,291.999 ↑ 8.4 882,911 1

Hash Join (cost=166,090.69..16,250,882.88 rows=7,446,662 width=6,429) (actual time=91,097.184..98,291.999 rows=882,911 loops=1)

  • Buffers: shared hit=57407197 read=968582 dirtied=4 written=3
390. 542.437 97,570.688 ↑ 8.4 882,910 1

Hash Join (cost=165,338.04..15,542,697.32 rows=7,446,662 width=6,265) (actual time=90,869.876..97,570.688 rows=882,910 loops=1)

  • Buffers: shared hit=57407176 read=967179 dirtied=4 written=3
391. 537.736 96,803.959 ↑ 8.4 882,694 1

Hash Join (cost=156,944.4..8,534,441.31 rows=7,446,662 width=6,069) (actual time=90,645.45..96,803.959 rows=882,694 loops=1)

  • Buffers: shared hit=57407149 read=967179 dirtied=4 written=3
392. 875.039 91,452.996 ↑ 8.4 882,594 1

Hash Join (cost=148,550.76..1,526,185.31 rows=7,446,662 width=5,873) (actual time=85,832.192..91,452.996 rows=882,594 loops=1)

  • Buffers: shared hit=57402861 read=940562 written=3
393. 85,532.769 85,532.769 ↑ 8.4 882,594 1

CTE Scan on session_details_with_media_line sd_ml (cost=0..148,933.24 rows=7,446,662 width=5,855) (actual time=80,782.465..85,532.769 rows=882,594 loops=1)

  • Buffers: shared hit=57402840 read=809309 written=3
394. 155.799 5,045.188 ↑ 1.0 528,942 1

Hash (cost=139,248.74..139,248.74 rows=531,544 width=30) (actual time=5,045.188..5,045.188 rows=528,942 loops=1)

  • Buffers: shared hit=21 read=131253
395. 36.707 4,889.389 ↑ 1.0 528,942 1

Append (cost=0..139,248.74 rows=531,544 width=30) (actual time=0.775..4,889.389 rows=528,942 loops=1)

  • Buffers: shared hit=21 read=131253
396. 1.333 1.333 ↑ 1.0 654 1

Seq Scan on ms_session_sfb_qoe_p2020_01_05 session_qoe (cost=0..23.81 rows=654 width=30) (actual time=0.774..1.333 rows=654 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=13
397. 18.369 18.369 ↓ 1.0 27,163 1

Seq Scan on ms_session_sfb_qoe_p2020_01_06 session_qoe_1 (cost=0..932.44 rows=27,158 width=30) (actual time=0.65..18.369 rows=27,163 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=524
398. 24.465 24.465 ↓ 1.0 31,234 1

Seq Scan on ms_session_sfb_qoe_p2020_01_07 session_qoe_2 (cost=0..1,091.51 rows=31,228 width=30) (actual time=0.697..24.465 rows=31,234 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=622
399. 24.681 24.681 ↓ 1.0 32,476 1

Seq Scan on ms_session_sfb_qoe_p2020_01_08 session_qoe_3 (cost=0..1,102.14 rows=32,470 width=30) (actual time=0.696..24.681 rows=32,476 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=614
400. 1,179.335 1,179.335 ↑ 1.0 34,313 1

Seq Scan on ms_session_sfb_qoe_p2020_01_09 session_qoe_4 (cost=0..33,755.92 rows=34,321 width=30) (actual time=0.706..1,179.335 rows=34,313 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=33241
401. 2.147 2.147 ↑ 1.0 557 1

Seq Scan on ms_session_sfb_qoe_p2020_01_10 session_qoe_5 (cost=0..35.36 rows=557 width=30) (actual time=0.55..2.147 rows=557 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=26
402. 3.442 3.442 ↓ 1.0 3,023 1

Seq Scan on ms_session_sfb_qoe_p2020_01_11 session_qoe_6 (cost=0..109.34 rows=3,022 width=30) (actual time=0.654..3.442 rows=3,023 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=63
403. 5.521 5.521 ↑ 1.0 1,403 1

Seq Scan on ms_session_sfb_qoe_p2020_01_12 session_qoe_7 (cost=0..52.05 rows=1,403 width=30) (actual time=0.7..5.521 rows=1,403 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=30
404. 39.157 39.157 ↓ 1.0 31,175 1

Seq Scan on ms_session_sfb_qoe_p2020_01_13 session_qoe_8 (cost=0..1,560.62 rows=31,169 width=30) (actual time=0.612..39.157 rows=31,175 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1092
405. 23.807 23.807 ↓ 1.0 32,220 1

Seq Scan on ms_session_sfb_qoe_p2020_01_14 session_qoe_9 (cost=0..1,213.3 rows=32,214 width=30) (actual time=0.656..23.807 rows=32,220 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=729
406. 179.056 179.056 ↓ 1.0 33,338 1

Seq Scan on ms_session_sfb_qoe_p2020_01_15 session_qoe_10 (cost=0..5,146.07 rows=33,331 width=30) (actual time=0.673..179.056 rows=33,338 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=4646
407. 2,229.345 2,229.345 ↑ 1.1 32,570 1

Seq Scan on ms_session_sfb_qoe_p2020_01_16 session_qoe_11 (cost=0..58,761.93 rows=35,255 width=30) (actual time=2.869..2,229.345 rows=32,570 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=58233
408. 864.163 864.163 ↓ 1.0 30,600 1

Seq Scan on ms_session_sfb_qoe_p2020_01_17 session_qoe_12 (cost=0..23,961 rows=30,594 width=30) (actual time=0.691..864.163 rows=30,600 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=23501
409. 2.325 2.325 ↓ 1.0 3,177 1

Seq Scan on ms_session_sfb_qoe_p2020_01_18 session_qoe_13 (cost=0..108.66 rows=3,176 width=30) (actual time=0.668..2.325 rows=3,177 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=60
410. 2.327 2.327 ↑ 1.0 1,226 1

Seq Scan on ms_session_sfb_qoe_p2020_01_19 session_qoe_14 (cost=0..46.39 rows=1,226 width=30) (actual time=0.587..2.327 rows=1,226 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=27
411. 22.237 22.237 ↓ 1.0 30,725 1

Seq Scan on ms_session_sfb_qoe_p2020_01_20 session_qoe_15 (cost=0..1,221.88 rows=30,719 width=30) (actual time=0.647..22.237 rows=30,725 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=760
412. 22.236 22.236 ↓ 1.0 33,724 1

Seq Scan on ms_session_sfb_qoe_p2020_01_21 session_qoe_16 (cost=0..1,268.86 rows=33,717 width=30) (actual time=0.67..22.236 rows=33,724 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=762
413. 25.914 25.914 ↓ 1.0 33,360 1

Seq Scan on ms_session_sfb_qoe_p2020_01_22 session_qoe_17 (cost=0..1,310.4 rows=33,353 width=30) (actual time=1.054..25.914 rows=33,360 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=809
414. 109.324 109.324 ↓ 1.0 34,404 1

Seq Scan on ms_session_sfb_qoe_p2020_01_23 session_qoe_18 (cost=0..3,733.06 rows=34,397 width=30) (actual time=0.682..109.324 rows=34,404 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=3216
415. 23.683 23.683 ↓ 1.0 31,725 1

Seq Scan on ms_session_sfb_qoe_p2020_01_24 session_qoe_19 (cost=0..1,187.88 rows=31,719 width=30) (actual time=0.764..23.683 rows=31,725 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=711
416. 3.338 3.338 ↓ 1.0 3,401 1

Seq Scan on ms_session_sfb_qoe_p2020_01_25 session_qoe_20 (cost=0..120.02 rows=3,400 width=30) (actual time=0.756..3.338 rows=3,401 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=68
417. 1.609 1.609 ↑ 1.0 1,217 1

Seq Scan on ms_session_sfb_qoe_p2020_01_26 session_qoe_21 (cost=0..46.25 rows=1,217 width=30) (actual time=0.764..1.609 rows=1,217 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=27
418. 22.886 22.886 ↓ 1.0 31,221 1

Seq Scan on ms_session_sfb_qoe_p2020_01_27 session_qoe_22 (cost=0..1,193.32 rows=31,215 width=30) (actual time=0.737..22.886 rows=31,221 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=724
419. 21.982 21.982 ↓ 1.0 34,036 1

Seq Scan on ms_session_sfb_qoe_p2020_01_28 session_qoe_23 (cost=0..1,266.54 rows=34,029 width=30) (actual time=0.665..21.982 rows=34,036 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=755
420. 142.785 4,813.227 ↓ 188.2 349,432 1

Hash (cost=8,356.5..8,356.5 rows=1,857 width=212) (actual time=4,813.227..4,813.227 rows=349,432 loops=1)

  • Buffers: shared hit=4288 read=26617 dirtied=4
421. 4,670.442 4,670.442 ↓ 188.2 349,432 1

CTE Scan on audio_stream caller_astr (cost=0..8,356.5 rows=1,857 width=212) (actual time=1,903.118..4,670.442 rows=349,432 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=4288 read=26617 dirtied=4
422. 120.686 224.292 ↓ 187.5 348,165 1

Hash (cost=8,356.5..8,356.5 rows=1,857 width=212) (actual time=224.291..224.292 rows=348,165 loops=1)

423. 103.606 103.606 ↓ 187.5 348,165 1

CTE Scan on audio_stream callee_astr (cost=0..8,356.5 rows=1,857 width=212) (actual time=0.003..103.606 rows=348,165 loops=1)

  • Filter: (sender_is_caller_pai = 0)
424. 4.021 227.281 ↓ 74.5 12,446 1

Hash (cost=749.32..749.32 rows=167 width=180) (actual time=227.281..227.281 rows=12,446 loops=1)

  • Buffers: shared hit=21 read=1403
425. 223.260 223.260 ↓ 74.5 12,446 1

CTE Scan on video_stream caller_vstr (cost=0..749.32 rows=167 width=180) (actual time=101.613..223.26 rows=12,446 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=21 read=1403
426. 6.586 11.540 ↓ 124.8 20,841 1

Hash (cost=749.32..749.32 rows=167 width=180) (actual time=11.54..11.54 rows=20,841 loops=1)

427. 4.954 4.954 ↓ 124.8 20,841 1

CTE Scan on video_stream callee_vstr (cost=0..749.32 rows=167 width=180) (actual time=0.002..4.954 rows=20,841 loops=1)

  • Filter: (sender_is_caller_pai = 0)
428. 12.958 429.572 ↓ 107.3 38,201 1

Hash (cost=1,601.71..1,601.71 rows=356 width=156) (actual time=429.572..429.572 rows=38,201 loops=1)

  • Buffers: shared hit=3 read=2261
429. 416.614 416.614 ↓ 107.3 38,201 1

CTE Scan on app_sharing_stream caller_appshstr (cost=0..1,601.71 rows=356 width=156) (actual time=166.197..416.614 rows=38,201 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=3 read=2261
430. 11.952 22.616 ↓ 105.8 37,660 1

Hash (cost=1,601.71..1,601.71 rows=356 width=156) (actual time=22.616..22.616 rows=37,660 loops=1)

431. 10.664 10.664 ↓ 105.8 37,660 1

CTE Scan on app_sharing_stream callee_appshstr (cost=0..1,601.71 rows=356 width=156) (actual time=0.002..10.664 rows=37,660 loops=1)

  • Filter: (sender_is_caller_pai = 0)
432. 206.856 2,079.147 ↑ 1.0 604,609 1

Hash (cost=40,062.37..40,062.37 rows=607,929 width=104) (actual time=2,079.147..2,079.147 rows=604,609 loops=1)

  • Buffers: shared hit=10236 read=16746 dirtied=207 written=121
433. 600.823 1,872.291 ↑ 1.0 604,609 1

Hash Join (cost=15,855.24..40,062.37 rows=607,929 width=104) (actual time=495.344..1,872.291 rows=604,609 loops=1)

  • Buffers: shared hit=10236 read=16746 dirtied=207 written=121
434. 777.371 777.371 ↑ 1.0 604,609 1

Seq Scan on ms_users_sfb_cdr u2 (cost=0..22,535.29 rows=607,929 width=69) (actual time=0.03..777.371 rows=604,609 loops=1)

  • Buffers: shared hit=8713 read=7743 written=41
435. 79.633 494.097 ↑ 1.0 237,250 1

Hash (cost=12,884.55..12,884.55 rows=237,655 width=70) (actual time=494.097..494.097 rows=237,250 loops=1)

  • Buffers: shared hit=1505 read=9003 dirtied=207 written=80
436. 414.464 414.464 ↑ 1.0 237,250 1

Seq Scan on ad_users uad2 (cost=0..12,884.55 rows=237,655 width=70) (actual time=0.527..414.464 rows=237,250 loops=1)

  • Buffers: shared hit=1505 read=9003 dirtied=207 written=80
437. 201.766 1,013.192 ↑ 1.0 604,609 1

Hash (cost=40,062.37..40,062.37 rows=607,929 width=104) (actual time=1,013.192..1,013.192 rows=604,609 loops=1)

  • Buffers: shared hit=26964
438. 598.152 811.426 ↑ 1.0 604,609 1

Hash Join (cost=15,855.24..40,062.37 rows=607,929 width=104) (actual time=137.601..811.426 rows=604,609 loops=1)

  • Buffers: shared hit=26964
439. 76.788 76.788 ↑ 1.0 604,609 1

Seq Scan on ms_users_sfb_cdr u1 (cost=0..22,535.29 rows=607,929 width=69) (actual time=0.012..76.788 rows=604,609 loops=1)

  • Buffers: shared hit=16456
440. 73.694 136.486 ↑ 1.0 237,250 1

Hash (cost=12,884.55..12,884.55 rows=237,655 width=70) (actual time=136.486..136.486 rows=237,250 loops=1)

  • Buffers: shared hit=10508
441. 62.792 62.792 ↑ 1.0 237,250 1

Seq Scan on ad_users uad1 (cost=0..12,884.55 rows=237,655 width=70) (actual time=0.007..62.792 rows=237,250 loops=1)

  • Buffers: shared hit=10508
442. 0.006 0.031 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=21) (actual time=0.031..0.031 rows=16 loops=1)

  • Buffers: shared hit=1
443. 0.025 0.025 ↑ 1.0 16 1

Seq Scan on ms_uri_types_sfb_cdr ut1 (cost=0..1.16 rows=16 width=21) (actual time=0.024..0.025 rows=16 loops=1)

  • Buffers: shared hit=1
444. 0.006 0.010 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=21) (actual time=0.01..0.01 rows=16 loops=1)

  • Buffers: shared hit=1
445. 0.004 0.004 ↑ 1.0 16 1

Seq Scan on ms_uri_types_sfb_cdr ut2 (cost=0..1.16 rows=16 width=21) (actual time=0.003..0.004 rows=16 loops=1)

  • Buffers: shared hit=1
446. 2.304 3.840 ↓ 1.0 10,756 1

Hash (cost=251.78..251.78 rows=10,678 width=76) (actual time=3.84..3.84 rows=10,756 loops=1)

  • Buffers: shared hit=145
447. 1.536 1.536 ↓ 1.0 10,756 1

Seq Scan on ms_client_versions_sfb_cdr caller_clv (cost=0..251.78 rows=10,678 width=76) (actual time=0.01..1.536 rows=10,756 loops=1)

  • Buffers: shared hit=145
448. 2.524 6.138 ↓ 1.0 10,756 1

Hash (cost=335.53..335.53 rows=10,678 width=222) (actual time=6.138..6.138 rows=10,756 loops=1)

  • Buffers: shared hit=145 read=1
449. 2.016 3.614 ↓ 1.0 10,756 1

Hash Join (cost=1.47..335.53 rows=10,678 width=222) (actual time=0.106..3.614 rows=10,756 loops=1)

  • Buffers: shared hit=145 read=1
450. 1.508 1.508 ↓ 1.0 10,756 1

Seq Scan on ms_client_versions_sfb_cdr callee_clv (cost=0..251.78 rows=10,678 width=76) (actual time=0.007..1.508 rows=10,756 loops=1)

  • Buffers: shared hit=145
451. 0.011 0.090 ↑ 1.0 42 1

Hash (cost=0.84..0.84 rows=42 width=152) (actual time=0.09..0.09 rows=42 loops=1)

  • Buffers: shared read=1
452. 0.079 0.079 ↑ 1.0 42 1

CTE Scan on user_agent_def callee_uad (cost=0..0.84 rows=42 width=152) (actual time=0.054..0.079 rows=42 loops=1)

  • Buffers: shared read=1
453. 1.997 3.387 ↑ 1.0 10,309 1

Hash (cost=208.25..208.25 rows=10,325 width=48) (actual time=3.387..3.387 rows=10,309 loops=1)

  • Buffers: shared hit=105
454. 1.390 1.390 ↑ 1.0 10,309 1

Seq Scan on ms_device_sfb_qoe dev_caller_cap (cost=0..208.25 rows=10,325 width=48) (actual time=0.021..1.39 rows=10,309 loops=1)

  • Buffers: shared hit=105
455. 2.028 3.388 ↑ 1.0 10,309 1

Hash (cost=208.25..208.25 rows=10,325 width=48) (actual time=3.388..3.388 rows=10,309 loops=1)

  • Buffers: shared hit=105
456. 1.360 1.360 ↑ 1.0 10,309 1

Seq Scan on ms_device_sfb_qoe dev_caller_ren (cost=0..208.25 rows=10,325 width=48) (actual time=0.009..1.36 rows=10,309 loops=1)

  • Buffers: shared hit=105
457. 2.032 3.322 ↑ 1.0 10,309 1

Hash (cost=208.25..208.25 rows=10,325 width=48) (actual time=3.322..3.322 rows=10,309 loops=1)

  • Buffers: shared hit=105
458. 1.290 1.290 ↑ 1.0 10,309 1

Seq Scan on ms_device_sfb_qoe dev_callee_cap (cost=0..208.25 rows=10,325 width=48) (actual time=0.007..1.29 rows=10,309 loops=1)

  • Buffers: shared hit=105
459. 1.975 3.239 ↑ 1.0 10,309 1

Hash (cost=208.25..208.25 rows=10,325 width=48) (actual time=3.239..3.239 rows=10,309 loops=1)

  • Buffers: shared hit=105
460. 1.264 1.264 ↑ 1.0 10,309 1

Seq Scan on ms_device_sfb_qoe dev_callee_ren (cost=0..208.25 rows=10,325 width=48) (actual time=0.006..1.264 rows=10,309 loops=1)

  • Buffers: shared hit=105
461. 0.012 0.033 ↑ 1.0 42 1

Hash (cost=0.84..0.84 rows=42 width=152) (actual time=0.033..0.033 rows=42 loops=1)

462. 0.021 0.021 ↑ 1.0 42 1

CTE Scan on user_agent_def caller_uad (cost=0..0.84 rows=42 width=152) (actual time=0.002..0.021 rows=42 loops=1)

463. 0.016 0.046 ↑ 2.6 43 1

Hash (cost=11.1..11.1 rows=110 width=122) (actual time=0.046..0.046 rows=43 loops=1)

  • Buffers: shared hit=1
464. 0.030 0.030 ↑ 2.6 43 1

Seq Scan on internal_client_type_mapping caller_ctm (cost=0..11.1 rows=110 width=122) (actual time=0.026..0.03 rows=43 loops=1)

  • Buffers: shared hit=1
465. 0.009 0.015 ↑ 2.6 43 1

Hash (cost=11.1..11.1 rows=110 width=122) (actual time=0.015..0.015 rows=43 loops=1)

  • Buffers: shared hit=1
466. 0.006 0.006 ↑ 2.6 43 1

Seq Scan on internal_client_type_mapping callee_ctm (cost=0..11.1 rows=110 width=122) (actual time=0.002..0.006 rows=43 loops=1)

  • Buffers: shared hit=1
467. 16.218 30.329 ↑ 1.0 76,289 1

Hash (cost=2,391.05..2,391.05 rows=76,705 width=19) (actual time=30.329..30.329 rows=76,289 loops=1)

  • Buffers: shared hit=1624
468. 14.111 14.111 ↑ 1.0 76,289 1

Seq Scan on ms_endpoint_sfb_qoe caller_endpoint (cost=0..2,391.05 rows=76,705 width=19) (actual time=0.017..14.111 rows=76,289 loops=1)

  • Buffers: shared hit=1624
469. 16.762 30.897 ↑ 1.0 76,289 1

Hash (cost=2,391.05..2,391.05 rows=76,705 width=19) (actual time=30.896..30.897 rows=76,289 loops=1)

  • Buffers: shared hit=1624
470. 14.135 14.135 ↑ 1.0 76,289 1

Seq Scan on ms_endpoint_sfb_qoe callee_endpoint (cost=0..2,391.05 rows=76,705 width=19) (actual time=0.008..14.135 rows=76,289 loops=1)

  • Buffers: shared hit=1624
471. 1.655 11.024 ↓ 1.0 6,514 1

Hash (cost=129.42..129.42 rows=6,471 width=668) (actual time=11.024..11.024 rows=6,514 loops=1)

  • Buffers: shared read=99
472. 9.369 9.369 ↓ 1.0 6,514 1

CTE Scan on user_agent caller_ua (cost=0..129.42 rows=6,471 width=668) (actual time=5.273..9.369 rows=6,514 loops=1)

  • Buffers: shared read=99
473. 1.424 2.272 ↓ 1.0 6,514 1

Hash (cost=129.42..129.42 rows=6,471 width=668) (actual time=2.272..2.272 rows=6,514 loops=1)

474. 0.848 0.848 ↓ 1.0 6,514 1

CTE Scan on user_agent callee_ua (cost=0..129.42 rows=6,471 width=668) (actual time=0.001..0.848 rows=6,514 loops=1)

475. 42.164 64.677 ↑ 1.0 185,409 1

Hash (cost=3,438.53..3,438.53 rows=187,853 width=19) (actual time=64.677..64.677 rows=185,409 loops=1)

  • Buffers: shared hit=1560
476. 22.513 22.513 ↑ 1.0 185,409 1

Seq Scan on ms_ip_address_sfb_qoe caller_subn (cost=0..3,438.53 rows=187,853 width=19) (actual time=0.025..22.513 rows=185,409 loops=1)

  • Buffers: shared hit=1560
477. 42.883 65.402 ↑ 1.0 185,409 1

Hash (cost=3,438.53..3,438.53 rows=187,853 width=19) (actual time=65.402..65.402 rows=185,409 loops=1)

  • Buffers: shared hit=1560
478. 22.519 22.519 ↑ 1.0 185,409 1

Seq Scan on ms_ip_address_sfb_qoe callee_subn (cost=0..3,438.53 rows=187,853 width=19) (actual time=0.011..22.519 rows=185,409 loops=1)

  • Buffers: shared hit=1560
479. 42.544 65.053 ↑ 1.0 185,409 1

Hash (cost=3,438.53..3,438.53 rows=187,853 width=19) (actual time=65.053..65.053 rows=185,409 loops=1)

  • Buffers: shared hit=1560
480. 22.509 22.509 ↑ 1.0 185,409 1

Seq Scan on ms_ip_address_sfb_qoe caller_refl_ip (cost=0..3,438.53 rows=187,853 width=19) (actual time=0.01..22.509 rows=185,409 loops=1)

  • Buffers: shared hit=1560
481. 42.945 65.727 ↑ 1.0 185,409 1

Hash (cost=3,438.53..3,438.53 rows=187,853 width=19) (actual time=65.727..65.727 rows=185,409 loops=1)

  • Buffers: shared hit=1560
482. 22.782 22.782 ↑ 1.0 185,409 1

Seq Scan on ms_ip_address_sfb_qoe callee_refl_ip (cost=0..3,438.53 rows=187,853 width=19) (actual time=0.009..22.782 rows=185,409 loops=1)

  • Buffers: shared hit=1560
483. 42.733 65.118 ↑ 1.0 185,409 1

Hash (cost=3,438.53..3,438.53 rows=187,853 width=19) (actual time=65.118..65.118 rows=185,409 loops=1)

  • Buffers: shared hit=1560
484. 22.385 22.385 ↑ 1.0 185,409 1

Seq Scan on ms_ip_address_sfb_qoe caller_ip (cost=0..3,438.53 rows=187,853 width=19) (actual time=0.011..22.385 rows=185,409 loops=1)

  • Buffers: shared hit=1560
485. 41.962 64.352 ↑ 1.0 185,409 1

Hash (cost=3,438.53..3,438.53 rows=187,853 width=19) (actual time=64.352..64.352 rows=185,409 loops=1)

  • Buffers: shared hit=1560
486. 22.390 22.390 ↑ 1.0 185,409 1

Seq Scan on ms_ip_address_sfb_qoe callee_ip (cost=0..3,438.53 rows=187,853 width=19) (actual time=0.011..22.39 rows=185,409 loops=1)

  • Buffers: shared hit=1560
487. 0.000 0.000 ↓ 0.0 0 884,957

Index Scan using idx_internal_network_region_mapping_network_network_ip on internal_network_region_mapping caller_locations (cost=0.14..0.16 rows=1 width=564) (actual time=0..0 rows=0 loops=884,957)

  • Index Cond: ((NULLIF((caller_ip.ip_address)::text, ''::text))::inet << ip)
  • Buffers: shared hit=250589
488. 0.000 0.000 ↓ 0.0 0 884,957

Index Scan using idx_internal_network_region_mapping_network_network_ip on internal_network_region_mapping callee_locations (cost=0.14..0.16 rows=1 width=564) (actual time=0..0 rows=0 loops=884,957)

  • Index Cond: ((NULLIF((callee_ip.ip_address)::text, ''::text))::inet << ip)
  • Buffers: shared hit=260866
489.          

SubPlan (for WindowAgg)

490. 1,769.914 3,539.828 ↑ 1.0 1 884,957

Aggregate (cost=12.05..12.06 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=884,957)

491. 884.957 1,769.914 ↓ 0.0 0 884,957

HashAggregate (cost=5.3..8.3 rows=300 width=32) (actual time=0.002..0.002 rows=0 loops=884,957)

  • Group Key: (unnest(caller_astr.codecs))
492. 884.957 884.957 ↓ 0.0 0 884,957

Append (cost=0..4.55 rows=300 width=32) (actual time=0.001..0.001 rows=0 loops=884,957)

493. 0.000 0.000 ↓ 0.0 0 884,957

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=884,957)

494. 0.000 0.000 ↑ 1.0 1 884,957

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=884,957)

495. 0.000 0.000 ↓ 0.0 0 884,957

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=884,957)

496. 0.000 0.000 ↑ 1.0 1 884,957

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=884,957)

497. 0.000 0.000 ↓ 0.0 0 884,957

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=884,957)

498. 0.000 0.000 ↑ 1.0 1 884,957

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=884,957)

499. 1,769.914 3,539.828 ↑ 1.0 1 884,957

Aggregate (cost=12.05..12.06 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=884,957)

500. 884.957 1,769.914 ↓ 0.0 0 884,957

HashAggregate (cost=5.3..8.3 rows=300 width=32) (actual time=0.002..0.002 rows=0 loops=884,957)

  • Group Key: (unnest(callee_astr.codecs))
501. 884.957 884.957 ↓ 0.0 0 884,957

Append (cost=0..4.55 rows=300 width=32) (actual time=0.001..0.001 rows=0 loops=884,957)

502. 0.000 0.000 ↓ 0.0 0 884,957

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=884,957)

503. 0.000 0.000 ↑ 1.0 1 884,957

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=884,957)

504. 0.000 0.000 ↓ 0.0 0 884,957

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=884,957)

505. 0.000 0.000 ↑ 1.0 1 884,957

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=884,957)

506. 0.000 0.000 ↓ 0.0 0 884,957

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=884,957)

507. 0.000 0.000 ↑ 1.0 1 884,957

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=884,957)

508.          

CTE stitched_data_phase1

509. 3,704.903 163,062.719 ↑ 1,558.7 884,957 1

WindowAgg (cost=38,760,310,223.14..41,246,656,691.18 rows=1,379,387,777 width=15,553) (actual time=154,855.196..163,062.719 rows=884,957 loops=1)

  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
510. 2,405.538 154,933.031 ↑ 1,558.7 884,957 1

Sort (cost=38,760,310,223.14..38,763,758,692.58 rows=1,379,387,777 width=26,721) (actual time=154,855.122..154,933.031 rows=884,957 loops=1)

  • Sort Key: d1_24.dialog, (COALESCE(d1_24.media_line_label, d2.media_line_label)), d1_24.ms_source_id
  • Sort Method: quicksort Memory: 1180927kB
  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
511. 2,407.037 152,527.493 ↑ 1,558.7 884,957 1

Merge Join (cost=87,314,446.58..7,018,967,164.32 rows=1,379,387,777 width=26,721) (actual time=149,875.591..152,527.493 rows=884,957 loops=1)

  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
512. 3,263.679 147,050.191 ↑ 8.4 884,957 1

Sort (cost=45,820,681.79..45,839,298.44 rows=7,446,662 width=14,059) (actual time=146,988.575..147,050.191 rows=884,957 loops=1)

  • Sort Key: d1_24.dialog
  • Sort Method: quicksort Memory: 1177645kB
  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
513. 143,786.512 143,786.512 ↑ 8.4 884,957 1

CTE Scan on prepared_dataset d1_24 (cost=0..148,933.24 rows=7,446,662 width=14,059) (actual time=127,646.744..143,786.512 rows=884,957 loops=1)

  • Buffers: shared hit=57969187 read=987689 dirtied=211 written=124
514. 130.297 3,070.265 ↑ 7.9 942,536 1

Materialize (cost=41,493,764.79..41,530,998.1 rows=7,446,662 width=12,700) (actual time=2,886.996..3,070.265 rows=942,536 loops=1)

515. 1,859.341 2,939.968 ↑ 9.4 792,368 1

Sort (cost=41,493,764.79..41,512,381.44 rows=7,446,662 width=12,700) (actual time=2,886.985..2,939.968 rows=792,368 loops=1)

  • Sort Key: d2.dialog
  • Sort Method: quicksort Memory: 617153kB
516. 1,080.627 1,080.627 ↑ 8.4 884,957 1

CTE Scan on prepared_dataset d2 (cost=0..148,933.24 rows=7,446,662 width=12,700) (actual time=0.006..1,080.627 rows=884,957 loops=1)

517.          

SubPlan (for WindowAgg)

518. 3,539.828 4,424.785 ↑ 1.0 1 884,957

Aggregate (cost=1.77..1.78 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=884,957)

519. 884.957 884.957 ↑ 8.3 12 884,957

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0.001 rows=12 loops=884,957)

520. 0.000 0.000 ↑ 1.0 1 884,957

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=884,957)

Planning time : 294.109 ms
Execution time : 167,680.019 ms