explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zDA : KCC

Settings
# exclusive inclusive rows x rows loops node
1. 3,277,842.620 3,277,842.620 ↑ 1,588,064.7 4,687,692 1

CTE Scan on stitched_data_phase1 ph1 (cost=7.63302338106503e+16..7.63640311970573e+16 rows=7,444,358,239,439 width=11,479) (actual time=3,139,606.426..3,277,842.62 rows=4,687,692 loops=1)

  • Filter: (rank = 1)
  • Buffers: shared hit=679165379 read=1051183 dirtied=8 written=448, temp read=9696169 written=7397382
2.          

CTE session_details

3. 4,608.567 16,647.973 ↑ 1.0 2,716,890 1

WindowAgg (cost=1,236,998.49..1,468,019.39 rows=2,717,893 width=4,280) (actual time=10,991.597..16,647.973 rows=2,716,890 loops=1)

  • Buffers: shared hit=99569 read=152408, temp read=54684 written=54692
4. 3,879.395 12,039.406 ↑ 1.0 2,716,890 1

Sort (cost=1,236,998.49..1,243,793.22 rows=2,717,893 width=122) (actual time=10,991.568..12,039.406 rows=2,716,890 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: external merge Disk: 289720kB
  • Buffers: shared hit=99569 read=152408, temp read=54684 written=54692
5. 1,728.733 8,160.011 ↑ 1.0 2,716,890 1

Hash Join (cost=50,828.88..843,154.99 rows=2,717,893 width=122) (actual time=797.316..8,160.011 rows=2,716,890 loops=1)

  • Buffers: shared hit=99569 read=152408, temp read=18469 written=18467
6. 192.923 5,637.798 ↑ 1.0 2,716,890 1

Append (cost=0..266,595.54 rows=2,717,893 width=82) (actual time=0.025..5,637.798 rows=2,716,890 loops=1)

  • Buffers: shared hit=88266 read=137553
7. 1,107.082 1,107.082 ↑ 1.0 148,945 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_06 sd_ (cost=0..38,735.35 rows=150,460 width=82) (actual time=0.025..1,107.082 rows=148,945 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=4910 read=31568
8. 286.529 286.529 ↓ 1.0 168,180 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_07 sd__1 (cost=0..14,831.7 rows=168,146 width=82) (actual time=0.021..286.529 rows=168,180 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=5205 read=7104
9. 310.350 310.350 ↓ 1.0 170,968 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_08 sd__2 (cost=0..15,409.52 rows=170,934 width=82) (actual time=0.022..310.35 rows=170,968 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=5325 read=7520
10. 319.901 319.901 ↓ 1.0 174,639 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_09 sd__3 (cost=0..16,560.58 rows=174,604 width=82) (actual time=0.023..319.901 rows=174,639 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=5482 read=8459
11. 312.770 312.770 ↓ 1.0 149,289 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_10 sd__4 (cost=0..14,462.33 rows=149,259 width=82) (actual time=0.019..312.77 rows=149,289 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=4688 read=7535
12. 43.787 43.787 ↓ 1.0 15,644 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_11 sd__5 (cost=0..2,115.66 rows=15,641 width=82) (actual time=0.017..43.787 rows=15,644 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=541 read=1340
13. 39.419 39.419 ↓ 1.0 15,023 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_12 sd__6 (cost=0..1,701.35 rows=15,020 width=82) (actual time=0.021..39.419 rows=15,023 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=519 read=957
14. 280.837 280.837 ↓ 1.0 176,537 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_13 sd__7 (cost=0..15,009.06 rows=176,502 width=82) (actual time=0.026..280.837 rows=176,537 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=5614 read=6747
15. 312.031 312.031 ↓ 1.0 164,164 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_14 sd__8 (cost=0..14,084.46 rows=164,131 width=82) (actual time=0.02..312.031 rows=164,164 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=4761 read=6861
16. 76.291 76.291 ↓ 1.0 160,779 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_15 sd__9 (cost=0..7,289.68 rows=160,747 width=82) (actual time=0.018..76.291 rows=160,779 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=4020 read=858
17. 87.675 87.675 ↓ 1.0 170,618 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_16 sd__10 (cost=0..8,372.27 rows=170,584 width=82) (actual time=0.016..87.675 rows=170,618 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=4718 read=1095
18. 290.722 290.722 ↓ 1.0 150,396 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_17 sd__11 (cost=0..14,231.94 rows=150,366 width=82) (actual time=0.026..290.722 rows=150,396 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=4687 read=7289
19. 64.239 64.239 ↓ 1.0 16,493 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_18 sd__12 (cost=0..2,749.39 rows=16,490 width=82) (actual time=0.018..64.239 rows=16,493 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=572 read=1930
20. 78.234 78.234 ↓ 1.0 22,608 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_19 sd__13 (cost=0..3,462.12 rows=22,603 width=82) (actual time=0.02..78.234 rows=22,608 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=758 read=2365
21. 241.499 241.499 ↓ 1.0 170,807 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_20 sd__14 (cost=0..13,171.1 rows=170,773 width=82) (actual time=0.022..241.499 rows=170,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=5456 read=5153
22. 279.192 279.192 ↓ 1.0 178,480 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_21 sd__15 (cost=0..14,639.2 rows=178,444 width=82) (actual time=0.02..279.192 rows=178,480 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=5781 read=6181
23. 287.750 287.750 ↓ 1.0 172,217 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_22 sd__16 (cost=0..14,776.26 rows=172,183 width=82) (actual time=0.019..287.75 rows=172,217 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=5575 read=6618
24. 168.971 168.971 ↓ 1.0 166,353 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_23 sd__17 (cost=0..10,937.3 rows=166,320 width=82) (actual time=0.019..168.971 rows=166,353 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=5340 read=3102
25. 86.882 86.882 ↓ 1.0 135,767 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_24 sd__18 (cost=0..7,913.51 rows=135,740 width=82) (actual time=0.022..86.882 rows=135,767 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=4614 read=1263
26. 52.834 52.834 ↓ 1.0 15,088 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_25 sd__19 (cost=0..2,343.32 rows=15,085 width=82) (actual time=0.023..52.834 rows=15,088 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=628 read=1489
27. 50.366 50.366 ↓ 1.0 15,810 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_26 sd__20 (cost=0..2,090.15 rows=15,807 width=82) (actual time=0.018..50.366 rows=15,810 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=584 read=1269
28. 667.514 667.514 ↓ 1.0 158,085 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_27 sd__21 (cost=0..31,709.29 rows=158,054 width=82) (actual time=0.021..667.514 rows=158,085 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=8488 read=20850
29. 165.050 793.480 ↓ 1.0 612,061 1

Hash (cost=35,338.93..35,338.93 rows=611,940 width=38) (actual time=793.48..793.48 rows=612,061 loops=1)

  • Buffers: shared hit=11303 read=14855, temp written=2268
30. 42.541 628.430 ↓ 1.0 612,061 1

Append (cost=0..35,338.93 rows=611,940 width=38) (actual time=0.014..628.43 rows=612,061 loops=1)

  • Buffers: shared hit=11303 read=14855
31. 84.396 84.396 ↓ 1.0 33,449 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_06 voip (cost=0..3,479.74 rows=33,442 width=38) (actual time=0.014..84.396 rows=33,449 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=577 read=2401
32. 26.996 26.996 ↓ 1.0 36,711 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_07 voip_1 (cost=0..1,761.66 rows=36,704 width=38) (actual time=0.019..26.996 rows=36,711 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=573 read=638
33. 30.664 30.664 ↓ 1.0 36,534 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_08 voip_2 (cost=0..1,888.01 rows=36,527 width=38) (actual time=0.019..30.664 rows=36,534 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=568 read=772
34. 27.028 27.028 ↓ 1.0 37,675 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_09 voip_3 (cost=0..1,942.12 rows=37,667 width=38) (actual time=0.02..27.028 rows=37,675 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=642 read=735
35. 27.878 27.878 ↓ 1.0 31,603 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_10 voip_4 (cost=0..1,728.05 rows=31,597 width=38) (actual time=0.019..27.878 rows=31,603 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=560 read=694
36. 9.106 9.106 ↓ 1.0 8,220 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_11 voip_5 (cost=0..529.3 rows=8,218 width=38) (actual time=0.019..9.106 rows=8,220 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=187 read=219
37. 6.497 6.497 ↓ 1.0 8,687 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_12 voip_6 (cost=0..461.31 rows=8,685 width=38) (actual time=0.022..6.497 rows=8,687 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=197 read=134
38. 20.899 20.899 ↓ 1.0 37,002 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_13 voip_7 (cost=0..1,611.03 rows=36,995 width=38) (actual time=0.021..20.899 rows=37,002 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=629 read=427
39. 32.716 32.716 ↓ 1.0 36,503 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_14 voip_8 (cost=0..1,629.55 rows=36,496 width=38) (actual time=0.021..32.716 rows=36,503 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=558 read=524
40. 7.503 7.503 ↓ 1.0 34,248 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_15 voip_9 (cost=0..970.72 rows=34,241 width=38) (actual time=0.022..7.503 rows=34,248 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=446 read=11
41. 8.529 8.529 ↓ 1.0 36,585 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_16 voip_10 (cost=0..1,117.78 rows=36,578 width=38) (actual time=0.022..8.529 rows=36,585 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=534 read=35
42. 29.544 29.544 ↓ 1.0 32,237 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_17 voip_11 (cost=0..1,742.56 rows=32,231 width=38) (actual time=0.021..29.544 rows=32,237 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=575 read=684
43. 11.332 11.332 ↓ 1.0 9,156 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_18 voip_12 (cost=0..720.34 rows=9,154 width=38) (actual time=0.017..11.332 rows=9,156 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=216 read=367
44. 6.800 6.800 ↓ 1.0 9,984 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_19 voip_13 (cost=0..524.76 rows=9,982 width=38) (actual time=0.021..6.8 rows=9,984 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=213 read=162
45. 24.429 24.429 ↓ 1.0 35,186 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_20 voip_14 (cost=0..1,583.79 rows=35,179 width=38) (actual time=0.018..24.429 rows=35,186 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=610 read=446
46. 20.529 20.529 ↓ 1.0 36,335 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_21 voip_15 (cost=0..1,658.03 rows=36,328 width=38) (actual time=0.022..20.529 rows=36,335 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=634 read=479
47. 23.926 23.926 ↓ 1.0 36,600 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_22 voip_16 (cost=0..1,602 rows=36,593 width=38) (actual time=0.02..23.926 rows=36,600 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=618 read=435
48. 20.814 20.814 ↓ 1.0 36,618 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_23 voip_17 (cost=0..1,553.27 rows=36,611 width=38) (actual time=0.018..20.814 rows=36,618 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=620 read=384
49. 14.631 14.631 ↓ 1.0 28,901 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_24 voip_18 (cost=0..1,240.51 rows=28,895 width=38) (actual time=0.018..14.631 rows=28,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=523 read=284
50. 9.138 9.138 ↓ 1.0 7,636 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_25 voip_19 (cost=0..587.54 rows=7,634 width=38) (actual time=0.016..9.138 rows=7,636 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=205 read=268
51. 5.976 5.976 ↓ 1.0 8,622 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_26 voip_20 (cost=0..444.33 rows=8,620 width=38) (actual time=0.019..5.976 rows=8,622 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=179 read=136
52. 136.558 136.558 ↓ 1.0 33,569 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_27 voip_21 (cost=0..6,562.55 rows=33,563 width=38) (actual time=0.017..136.558 rows=33,569 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=1439 read=4620
53.          

CTE conference_session_details

54. 2,692.335 16,170.740 ↓ 1.0 1,669,162 1

WindowAgg (cost=1,293,585.78..1,368,683.4 rows=1,668,836 width=2,747) (actual time=12,738.278..16,170.74 rows=1,669,162 loops=1)

  • Buffers: shared hit=120178 read=263296, temp read=58774 written=58779
55. 2,895.788 13,478.405 ↓ 1.0 1,669,162 1

Sort (cost=1,293,585.78..1,297,757.87 rows=1,668,836 width=193) (actual time=12,738.258..13,478.405 rows=1,669,162 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: external merge Disk: 292624kB
  • Buffers: shared hit=120178 read=263296, temp read=58774 written=58779
56. 480.664 10,582.617 ↓ 1.0 1,669,162 1

Gather (cost=184,993.74..1,027,560.5 rows=1,668,836 width=193) (actual time=4,804.511..10,582.617 rows=1,669,162 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=120178 read=263296, temp read=22196 written=22192
57. 804.435 10,101.953 ↑ 1.2 834,581 2 / 2

Hash Join (cost=183,993.74..859,676.9 rows=981,668 width=193) (actual time=4,771.955..10,101.953 rows=834,581 loops=2)

  • Buffers: shared hit=120178 read=263296, temp read=22196 written=22192
58. 454.309 7,117.771 ↑ 1.2 834,392 2 / 2

Hash Join (cost=89,895.04..471,637.24 rows=981,668 width=165) (actual time=2,587.688..7,117.771 rows=834,392 loops=2)

  • Buffers: shared hit=63497 read=206659
59. 204.247 4,080.180 ↑ 1.2 834,390 2 / 2

Hash Join (cost=1.73..163,386.43 rows=981,668 width=141) (actual time=0.382..4,080.18 rows=834,390 loops=2)

  • Buffers: shared hit=21 read=143238
60. 66.295 3,875.903 ↑ 1.2 834,390 2 / 2

Append (cost=0..157,984.94 rows=981,668 width=125) (actual time=0.333..3,875.903 rows=834,390 loops=2)

  • Buffers: shared hit=19 read=143238
61. 494.993 494.993 ↑ 1.2 38,638 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_06 csd_ (cost=0..18,155.84 rows=45,447 width=125) (actual time=0.332..494.993 rows=38,638 loops=2)

  • 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=17473
62. 135.211 135.211 ↑ 1.2 50,287 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_07 csd__1 (cost=0..6,842.42 rows=59,149 width=125) (actual time=0.711..135.211 rows=50,287 loops=2)

  • 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=5954
63. 136.978 136.978 ↑ 1.2 52,358 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_08 csd__2 (cost=0..6,814.96 rows=61,585 width=125) (actual time=0.637..136.978 rows=52,358 loops=2)

  • 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=5890
64. 153.592 153.592 ↑ 1.2 55,804 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_09 csd__3 (cost=0..7,265.78 rows=65,639 width=125) (actual time=0.638..153.592 rows=55,804 loops=2)

  • 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=6280
65. 187.983 187.983 ↑ 1.2 44,412 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_10 csd__4 (cost=0..7,178.74 rows=52,239 width=125) (actual time=0.635..187.983 rows=44,412 loops=2)

  • 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=6394
66. 14.600 14.600 ↑ 1.2 835 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_11 csd__5 (cost=0..507.74 rows=982 width=125) (actual time=0.652..14.6 rows=835 loops=2)

  • 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=492
67. 4.536 4.536 ↑ 1.2 1,484 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_12 csd__6 (cost=0..192.2 rows=1,746 width=125) (actual time=0.663..4.536 rows=1,484 loops=2)

  • 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=166
68. 118.664 118.664 ↑ 1.2 53,983 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_13 csd__7 (cost=0..6,346.64 rows=63,497 width=125) (actual time=0.602..118.664 rows=53,983 loops=2)

  • 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=5393
69. 152.411 152.411 ↑ 1.2 52,506 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_14 csd__8 (cost=0..7,277.58 rows=61,759 width=125) (actual time=0.665..152.411 rows=52,506 loops=2)

  • 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=6350
70. 81.546 81.546 ↑ 1.2 52,276 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_15 csd__9 (cost=0..4,618.51 rows=61,488 width=125) (actual time=0.604..81.546 rows=52,276 loops=2)

  • 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=3696
71. 107.853 107.853 ↑ 1.2 56,457 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_16 csd__10 (cost=0..5,842.3 rows=66,407 width=125) (actual time=0.736..107.853 rows=56,457 loops=2)

  • 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=4845
72. 159.523 159.523 ↑ 1.2 47,070 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_17 csd__11 (cost=0..7,545.66 rows=55,366 width=125) (actual time=0.671..159.523 rows=47,070 loops=2)

  • 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=6714
73. 7.840 7.840 ↑ 1.2 1,106 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_18 csd__12 (cost=0..429.51 rows=1,301 width=125) (actual time=0.651..7.84 rows=1,106 loops=2)

  • 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=409
74. 21.619 21.619 ↑ 1.2 2,644 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_19 csd__13 (cost=0..877.66 rows=3,110 width=125) (actual time=0.445..21.619 rows=2,644 loops=2)

  • 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=830
75. 144.899 144.899 ↑ 1.2 53,363 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_20 csd__14 (cost=0..7,304.7 rows=62,768 width=125) (actual time=0.644..144.899 rows=53,363 loops=2)

  • 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=6362
76. 148.928 148.928 ↑ 1.2 58,228 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_21 csd__15 (cost=0..7,414.56 rows=68,491 width=125) (actual time=0.684..148.928 rows=58,228 loops=2)

  • 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=6386
77. 182.352 182.352 ↑ 1.2 55,838 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_22 csd__16 (cost=0..8,211.39 rows=65,679 width=125) (actual time=0.669..182.352 rows=55,838 loops=2)

  • 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=7225
78. 146.791 146.791 ↑ 1.2 53,093 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_23 csd__17 (cost=0..6,437.94 rows=62,450 width=125) (actual time=0.767..146.791 rows=53,093 loops=2)

  • 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=5500
79. 118.030 118.030 ↑ 1.2 43,454 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_24 csd__18 (cost=0..6,019.84 rows=51,113 width=125) (actual time=0.615..118.03 rows=43,454 loops=2)

  • 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=5252
80. 7.390 7.390 ↑ 1.2 1,128 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_25 csd__19 (cost=0..237.91 rows=1,328 width=125) (actual time=0.627..7.39 rows=1,128 loops=2)

  • 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=217
81. 15.522 15.522 ↑ 1.2 1,732 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_26 csd__20 (cost=0..553.56 rows=2,036 width=125) (actual time=0.625..15.522 rows=1,732 loops=2)

  • 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=522
82. 1,268.347 1,268.347 ↑ 1.2 57,694 2 / 2

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_27 csd__21 (cost=0..41,909.53 rows=68,088 width=125) (actual time=0.631..1,268.347 rows=57,694 loops=2)

  • 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=40888
83. 0.011 0.030 ↑ 1.0 29 2 / 2

Hash (cost=1.29..1.29 rows=29 width=20) (actual time=0.03..0.03 rows=29 loops=2)

  • Buffers: shared hit=2
84. 0.019 0.019 ↑ 1.0 29 2 / 2

Seq Scan on ms_uri_types_sfb_cdr ut (cost=0..1.29 rows=29 width=20) (actual time=0.015..0.019 rows=29 loops=2)

  • Buffers: shared hit=2
85. 190.624 2,583.282 ↓ 1.0 656,605 2 / 2

Hash (cost=73,919.62..73,919.62 rows=656,382 width=30) (actual time=2,583.282..2,583.282 rows=656,605 loops=2)

  • Buffers: shared hit=63467 read=63421
86. 47.986 2,392.658 ↓ 1.0 656,605 2 / 2

Append (cost=0..73,919.62 rows=656,382 width=30) (actual time=0.379..2,392.658 rows=656,605 loops=2)

  • Buffers: shared hit=63467 read=63421
87. 6.110 6.110 ↑ 1.0 239 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_05 fjl (cost=0..208.48 rows=239 width=30) (actual time=0.379..6.11 rows=239 loops=2)

  • 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 hit=191 read=189
88. 165.375 165.375 ↓ 1.0 31,817 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_06 fjl_1 (cost=0..5,390.26 rows=31,811 width=30) (actual time=0.327..165.375 rows=31,817 loops=2)

  • 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 hit=4913 read=4913
89. 49.361 49.361 ↓ 1.0 40,196 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_07 fjl_2 (cost=0..2,203.94 rows=40,189 width=30) (actual time=0.691..49.361 rows=40,196 loops=2)

  • 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 hit=1602 read=1600
90. 50.045 50.045 ↓ 1.0 41,489 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_08 fjl_3 (cost=0..2,305.34 rows=41,481 width=30) (actual time=0.627..50.045 rows=41,489 loops=2)

  • 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 hit=1684 read=1682
91. 63.814 63.814 ↓ 1.0 44,316 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_09 fjl_4 (cost=0..2,751.74 rows=44,308 width=30) (actual time=0.709..63.814 rows=44,316 loops=2)

  • 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 hit=2088 read=2086
92. 50.055 50.055 ↓ 1.0 35,100 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_10 fjl_5 (cost=0..2,217.5 rows=35,094 width=30) (actual time=0.629..50.055 rows=35,100 loops=2)

  • 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 hit=1692 read=1690
93. 4.495 4.495 ↑ 1.0 789 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_11 fjl_6 (cost=0..122.83 rows=789 width=30) (actual time=0.682..4.495 rows=789 loops=2)

  • 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 hit=112 read=110
94. 3.695 3.695 ↑ 1.0 1,302 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_12 fjl_7 (cost=0..68.53 rows=1,302 width=30) (actual time=1.397..3.695 rows=1,302 loops=2)

  • 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 hit=49 read=49
95. 50.524 50.524 ↓ 1.0 42,869 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_13 fjl_8 (cost=0..2,413.03 rows=42,861 width=30) (actual time=0.636..50.524 rows=42,869 loops=2)

  • 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 hit=1771 read=1769
96. 61.197 61.197 ↓ 1.0 40,689 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_14 fjl_9 (cost=0..2,344.34 rows=40,682 width=30) (actual time=0.674..61.197 rows=40,689 loops=2)

  • 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 hit=1735 read=1733
97. 34.551 34.551 ↓ 1.0 39,200 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_15 fjl_10 (cost=0..1,579 rows=39,193 width=30) (actual time=1.532..34.551 rows=39,200 loops=2)

  • 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 hit=991 read=991
98. 51.293 51.293 ↓ 1.0 43,315 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_16 fjl_11 (cost=0..2,244.72 rows=43,307 width=30) (actual time=1.6..51.293 rows=43,315 loops=2)

  • 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 hit=1595 read=1595
99. 55.973 55.973 ↓ 1.0 36,617 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_17 fjl_12 (cost=0..2,374.26 rows=36,610 width=30) (actual time=0.609..55.973 rows=36,617 loops=2)

  • 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 hit=1826 read=1824
100. 3.271 3.271 ↑ 1.0 927 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_18 fjl_13 (cost=0..92.91 rows=927 width=30) (actual time=0.7..3.271 rows=927 loops=2)

  • 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 hit=80 read=78
101. 10.674 10.674 ↑ 1.0 2,235 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_19 fjl_14 (cost=0..279.52 rows=2,235 width=30) (actual time=0.857..10.674 rows=2,235 loops=2)

  • 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 hit=247 read=245
102. 49.173 49.173 ↓ 1.0 42,188 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_20 fjl_15 (cost=0..2,243.82 rows=42,180 width=30) (actual time=0.602..49.173 rows=42,188 loops=2)

  • 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 hit=1612 read=1610
103. 57.598 57.598 ↓ 1.0 45,367 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_21 fjl_16 (cost=0..2,545.51 rows=45,359 width=30) (actual time=0.644..57.598 rows=45,367 loops=2)

  • 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 hit=1866 read=1864
104. 96.862 96.862 ↓ 1.0 43,206 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_22 fjl_17 (cost=0..2,629.09 rows=43,198 width=30) (actual time=0.717..96.862 rows=43,206 loops=2)

  • 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 hit=1982 read=1980
105. 120.468 120.468 ↓ 1.0 40,926 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_23 fjl_18 (cost=0..2,290.89 rows=40,919 width=30) (actual time=0.654..120.468 rows=40,926 loops=2)

  • 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 hit=1678 read=1676
106. 35.960 35.960 ↓ 1.0 33,995 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_24 fjl_19 (cost=0..1,693.92 rows=33,989 width=30) (actual time=0.66..35.96 rows=33,995 loops=2)

  • 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 hit=1185 read=1183
107. 3.950 3.950 ↑ 1.0 990 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_25 fjl_20 (cost=0..82.85 rows=990 width=30) (actual time=0.609..3.95 rows=990 loops=2)

  • 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 hit=69 read=67
108. 6.063 6.063 ↑ 1.0 1,504 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_26 fjl_21 (cost=0..193.56 rows=1,504 width=30) (actual time=0.576..6.063 rows=1,504 loops=2)

  • 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 hit=172 read=170
109. 784.128 784.128 ↓ 1.0 43,869 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_27 fjl_22 (cost=0..19,951.03 rows=43,861 width=30) (actual time=0.724..784.128 rows=43,869 loops=2)

  • 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 hit=19294 read=19292
110. 530.037 530.037 ↓ 1.0 3,460 2 / 2

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_28 fjl_23 (cost=0..15,692.56 rows=3,354 width=30) (actual time=0.694..530.037 rows=3,460 loops=2)

  • 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 hit=15033 read=15025
111. 240.583 2,179.747 ↑ 1.0 926,331 2 / 2

Hash (cost=71,518.32..71,518.32 rows=927,851 width=30) (actual time=2,179.747..2,179.747 rows=926,331 loops=2)

  • Buffers: shared hit=56681 read=56637, temp written=5642
112. 66.421 1,939.164 ↓ 1.0 928,277 2 / 2

Append (cost=0..71,518.32 rows=927,851 width=30) (actual time=0.652..1,939.164 rows=928,277 loops=2)

  • Buffers: shared hit=56681 read=56637
113. 4.352 4.352 ↑ 1.0 249 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_05 mjl (cost=0..137.56 rows=250 width=30) (actual time=0.651..4.352 rows=249 loops=2)

  • 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 hit=118 read=116
114. 149.225 149.225 ↓ 1.0 41,464 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_06 mjl_1 (cost=0..4,487.96 rows=41,457 width=30) (actual time=0.68..149.225 rows=41,464 loops=2)

  • 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 hit=3867 read=3865
115. 44.108 44.108 ↓ 1.0 55,477 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_07 mjl_2 (cost=0..2,202.15 rows=55,468 width=30) (actual time=0.604..44.108 rows=55,477 loops=2)

  • 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 hit=1371 read=1369
116. 47.044 47.044 ↓ 1.0 57,443 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_08 mjl_3 (cost=0..2,484.64 rows=57,433 width=30) (actual time=0.643..47.044 rows=57,443 loops=2)

  • 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 hit=1624 read=1622
117. 72.598 72.598 ↓ 1.0 61,474 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_09 mjl_4 (cost=0..2,952.11 rows=61,463 width=30) (actual time=0.683..72.598 rows=61,474 loops=2)

  • 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 hit=2031 read=2029
118. 47.694 47.694 ↓ 1.0 48,621 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_10 mjl_5 (cost=0..2,213.32 rows=48,613 width=30) (actual time=0.658..47.694 rows=48,621 loops=2)

  • 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 hit=1485 read=1483
119. 4.971 4.971 ↑ 1.0 913 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_11 mjl_6 (cost=0..140.69 rows=913 width=30) (actual time=0.688..4.971 rows=913 loops=2)

  • 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 hit=127 read=127
120. 4.078 4.078 ↑ 1.0 1,525 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_12 mjl_7 (cost=0..80.88 rows=1,525 width=30) (actual time=0.664..4.078 rows=1,525 loops=2)

  • 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 hit=58 read=58
121. 48.156 48.156 ↓ 1.0 59,500 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_13 mjl_8 (cost=0..2,614.5 rows=59,490 width=30) (actual time=0.702..48.156 rows=59,500 loops=2)

  • 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 hit=1723 read=1721
122. 50.668 50.668 ↓ 1.0 58,076 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_14 mjl_9 (cost=0..2,551.14 rows=58,066 width=30) (actual time=0.627..50.668 rows=58,076 loops=2)

  • 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 hit=1681 read=1679
123. 35.525 35.525 ↓ 1.0 57,207 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_15 mjl_10 (cost=0..1,853.11 rows=57,197 width=30) (actual time=1.53..35.525 rows=57,207 loops=2)

  • 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 hit=995 read=995
124. 49.518 49.518 ↓ 1.0 62,922 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_16 mjl_11 (cost=0..2,509.83 rows=62,911 width=30) (actual time=0.644..49.518 rows=62,922 loops=2)

  • 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 hit=1567 read=1565
125. 49.276 49.276 ↓ 1.0 52,282 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_17 mjl_12 (cost=0..2,391.23 rows=52,273 width=30) (actual time=0.583..49.276 rows=52,282 loops=2)

  • 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 hit=1608 read=1606
126. 3.933 3.933 ↑ 1.0 1,135 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_18 mjl_13 (cost=0..95.03 rows=1,135 width=30) (actual time=0.687..3.933 rows=1,135 loops=2)

  • 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 hit=79 read=77
127. 6.982 6.982 ↑ 1.0 2,888 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_19 mjl_14 (cost=0..249.32 rows=2,888 width=30) (actual time=0.62..6.982 rows=2,888 loops=2)

  • 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 hit=207 read=205
128. 45.113 45.113 ↓ 1.0 59,110 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_20 mjl_15 (cost=0..2,293.65 rows=59,100 width=30) (actual time=0.766..45.113 rows=59,110 loops=2)

  • 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 hit=1408 read=1406
129. 46.022 46.022 ↓ 1.0 65,166 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_21 mjl_16 (cost=0..2,645.49 rows=65,155 width=30) (actual time=0.664..46.022 rows=65,166 loops=2)

  • 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 hit=1669 read=1667
130. 55.276 55.276 ↓ 1.0 62,172 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_22 mjl_17 (cost=0..2,614.58 rows=62,162 width=30) (actual time=0.584..55.276 rows=62,172 loops=2)

  • 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 hit=1683 read=1681
131. 52.419 52.419 ↓ 1.0 59,482 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_23 mjl_18 (cost=0..2,585.23 rows=59,472 width=30) (actual time=0.605..52.419 rows=59,482 loops=2)

  • 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 hit=1694 read=1692
132. 39.671 39.671 ↓ 1.0 48,079 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_24 mjl_19 (cost=0..1,916.18 rows=48,071 width=30) (actual time=0.71..39.671 rows=48,079 loops=2)

  • 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 hit=1196 read=1194
133. 2.963 2.963 ↑ 1.0 1,112 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_25 mjl_20 (cost=0..59.68 rows=1,112 width=30) (actual time=0.636..2.963 rows=1,112 loops=2)

  • 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 hit=44 read=42
134. 4.350 4.350 ↑ 1.0 1,812 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_26 mjl_21 (cost=0..135.18 rows=1,812 width=30) (actual time=0.645..4.35 rows=1,812 loops=2)

  • 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 hit=109 read=107
135. 540.559 540.559 ↓ 1.0 65,853 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_27 mjl_22 (cost=0..17,539.79 rows=65,843 width=30) (actual time=0.585..540.559 rows=65,853 loops=2)

  • 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 hit=16553 read=16551
136. 468.242 468.242 ↓ 1.1 4,315 2 / 2

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_28 mjl_23 (cost=0..14,765.06 rows=4,042 width=30) (actual time=0.696..468.242 rows=4,315 loops=2)

  • 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 hit=13784 read=13780
137.          

CTE sessions_united

138. 531.529 62,129.715 ↓ 317.9 4,319,914 1

Append (cost=0..115,661.54 rows=13,590 width=4,931) (actual time=10,991.604..62,129.715 rows=4,319,914 loops=1)

  • Buffers: shared hit=13107265 read=426984, temp read=113458 written=199809
139. 21,066.190 21,066.190 ↓ 198.6 2,698,823 1

CTE Scan on session_details sd__22 (cost=0..61,152.59 rows=13,589 width=4,931) (actual time=10,991.603..21,066.19 rows=2,698,823 loops=1)

  • Filter: (rn = 1)
  • Buffers: shared hit=99569 read=152408, temp read=54684 written=102214
140. 2,445.045 40,531.996 ↓ 1,621,091.0 1,621,091 1

Nested Loop (cost=11,983.82..54,373.05 rows=1 width=5,398) (actual time=13,077.864..40,531.996 rows=1,621,091 loops=1)

  • Buffers: shared hit=13007696 read=274576, temp read=58774 written=97595
141. 1,006.940 28,360.405 ↓ 1,621,091.0 1,621,091 1

Nested Loop (cost=11,983.4..54,372.61 rows=1 width=3,277) (actual time=13,077.484..28,360.405 rows=1,621,091 loops=1)

  • Buffers: shared hit=6603967 read=274500, temp read=58774 written=97595
142. 2,278.854 20,869.101 ↓ 1,621,091.0 1,621,091 1

Hash Join (cost=11,982.97..54,371.31 rows=1 width=3,240) (actual time=13,077.444..20,869.101 rows=1,621,091 loops=1)

  • Buffers: shared hit=120194 read=271556, temp read=58774 written=97595
143. 18,251.221 18,251.221 ↓ 200.0 1,668,763 1

CTE Scan on conference_session_details csd__22 (cost=0..37,548.81 rows=8,344 width=3,206) (actual time=12,738.283..18,251.221 rows=1,668,763 loops=1)

  • Filter: (rn = 1)
  • Buffers: shared hit=120178 read=263296, temp read=58774 written=97595
144. 41.458 339.026 ↑ 1.0 103,179 1

Hash (cost=9,864.85..9,864.85 rows=105,906 width=75) (actual time=339.026..339.026 rows=103,179 loops=1)

  • Buffers: shared hit=16 read=8260
145. 7.383 297.568 ↑ 1.0 103,179 1

Append (cost=0..9,864.85 rows=105,906 width=75) (actual time=0.741..297.568 rows=103,179 loops=1)

  • Buffers: shared hit=16 read=8260
146. 27.371 27.371 ↓ 1.0 5,295 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_06 c (cost=0..908.42 rows=5,294 width=75) (actual time=0.74..27.371 rows=5,295 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=828
147. 8.652 8.652 ↓ 1.0 6,157 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_07 c_1 (cost=0..360.36 rows=6,156 width=75) (actual time=0.703..8.652 rows=6,157 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=267
148. 11.192 11.192 ↓ 1.0 6,439 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_08 c_2 (cost=0..365.58 rows=6,438 width=75) (actual time=0.775..11.192 rows=6,439 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=268
149. 13.188 13.188 ↓ 1.0 6,804 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_09 c_3 (cost=0..444.06 rows=6,803 width=75) (actual time=0.709..13.188 rows=6,804 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=342
150. 10.666 10.666 ↓ 1.0 5,620 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_10 c_4 (cost=0..404.3 rows=5,619 width=75) (actual time=0.634..10.666 rows=5,620 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=319
151. 1.724 1.724 ↑ 1.0 181 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_11 c_5 (cost=0..26.71 rows=181 width=75) (actual time=0.628..1.724 rows=181 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=23
152. 1.230 1.230 ↑ 1.0 265 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_12 c_6 (cost=0..13.97 rows=265 width=75) (actual time=0.631..1.23 rows=265 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=9
153. 7.295 7.295 ↓ 1.0 6,756 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_13 c_7 (cost=0..371.34 rows=6,755 width=75) (actual time=0.585..7.295 rows=6,756 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=270
154. 8.854 8.854 ↓ 1.0 6,385 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_14 c_8 (cost=0..402.77 rows=6,384 width=75) (actual time=0.582..8.854 rows=6,385 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=306
155. 9.395 9.395 ↓ 1.0 6,506 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_15 c_9 (cost=0..238.59 rows=6,505 width=75) (actual time=0.74..9.395 rows=6,506 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=140
156. 14.518 14.518 ↓ 1.0 6,817 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_16 c_10 (cost=0..334.25 rows=6,816 width=75) (actual time=0.652..14.518 rows=6,817 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=231
157. 9.222 9.222 ↓ 1.0 5,819 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_17 c_11 (cost=0..382.28 rows=5,818 width=75) (actual time=0.648..9.222 rows=5,819 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=294
158. 1.604 1.604 ↑ 1.0 180 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_18 c_12 (cost=0..18.7 rows=180 width=75) (actual time=0.608..1.604 rows=180 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=15
159. 2.465 2.465 ↑ 1.0 399 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_19 c_13 (cost=0..57.98 rows=399 width=75) (actual time=0.644..2.465 rows=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 read=52
160. 10.780 10.780 ↓ 1.0 6,716 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_20 c_14 (cost=0..384.74 rows=6,715 width=75) (actual time=0.66..10.78 rows=6,716 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=283
161. 7.974 7.974 ↓ 1.0 7,058 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_21 c_15 (cost=0..393.87 rows=7,057 width=75) (actual time=0.625..7.974 rows=7,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=287
162. 9.993 9.993 ↓ 1.0 6,745 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_22 c_16 (cost=0..461.18 rows=6,744 width=75) (actual time=0.568..9.993 rows=6,745 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=359
163. 7.655 7.655 ↓ 1.0 6,492 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_23 c_17 (cost=0..372.38 rows=6,491 width=75) (actual time=0.605..7.655 rows=6,492 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=274
164. 6.805 6.805 ↓ 1.0 5,493 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_24 c_18 (cost=0..308.39 rows=5,492 width=75) (actual time=0.626..6.805 rows=5,493 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=226
165. 1.450 1.450 ↑ 1.0 194 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_25 c_19 (cost=0..20.91 rows=194 width=75) (actual time=0.611..1.45 rows=194 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=18
166. 3.039 3.039 ↑ 1.0 318 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_26 c_20 (cost=0..50.77 rows=318 width=75) (actual time=0.017..3.039 rows=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=45
167. 115.113 115.113 ↑ 1.4 6,540 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_27 c_21 (cost=0..3,543.26 rows=9,282 width=75) (actual time=0.946..115.113 rows=6,540 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=3404
168. 6,484.364 6,484.364 ↑ 1.0 1 1,621,091

Index Scan using ms_users_sfb_cdr_pkey on ms_users_sfb_cdr u (cost=0.43..1.3 rows=1 width=45) (actual time=0.004..0.004 rows=1 loops=1,621,091)

  • Index Cond: ((ms_source_id = c.ms_source_id) AND (user_id = c.organizer_id))
  • Buffers: shared hit=6483773 read=2944
169. 9,726.546 9,726.546 ↑ 1.0 1 1,621,091

Index Scan using ad_users_pkey on ad_users uad (cost=0.42..0.44 rows=1 width=34) (actual time=0.006..0.006 rows=1 loops=1,621,091)

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

CTE session_details_with_media_line

171. 16,540.487 887,129.162 ↑ 34.2 4,668,435 1

WindowAgg (cost=1,098,989,587.19..1,206,438,894.93 rows=159,479,492 width=5,769) (actual time=869,292.028..887,129.162 rows=4,668,435 loops=1)

  • Buffers: shared hit=600796833 read=792743 written=448, temp read=850719 written=878898
172. 7,084.472 870,588.675 ↑ 34.2 4,668,435 1

Sort (cost=1,098,989,587.19..1,099,388,285.92 rows=159,479,492 width=5,154) (actual time=869,291.98..870,588.675 rows=4,668,435 loops=1)

  • Sort Key: sd.ms_source_id, sd.conf_session_id_time, sd.conf_session_id_seq
  • Sort Method: external merge Disk: 1587784kB
  • Buffers: shared hit=600796829 read=792743 written=448, temp read=662585 written=783104
173. 5,842.172 863,504.203 ↑ 34.2 4,668,435 1

WindowAgg (cost=659,898,648.47..663,486,937.04 rows=159,479,492 width=5,154) (actual time=855,779.691..863,504.203 rows=4,668,435 loops=1)

  • Buffers: shared hit=600796829 read=792743 written=448, temp read=464112 written=584582
174. 9,037.445 857,662.031 ↑ 34.2 4,668,435 1

Sort (cost=659,898,648.47..660,297,347.2 rows=159,479,492 width=5,122) (actual time=855,779.667..857,662.031 rows=4,668,435 loops=1)

  • Sort Key: sd.ms_source_id, sd.session_id_time, sd.session_id_seq
  • Sort Method: external merge Disk: 1460416kB
  • Buffers: shared hit=600796829 read=792743 written=448, temp read=464112 written=584582
175. 15,969.166 848,624.586 ↑ 34.2 4,668,435 1

Hash Join (cost=79,156,837.81..226,950,163.01 rows=159,479,492 width=5,122) (actual time=833,561.154..848,624.586 rows=4,668,435 loops=1)

  • Buffers: shared hit=600796829 read=792743 written=448, temp read=281560 written=401979
176. 271.724 3,030.400 ↓ 1.0 2,261,339 1

Append (cost=0..117,074.08 rows=2,260,893 width=80) (actual time=0.666..3,030.4 rows=2,261,339 loops=1)

  • Buffers: shared hit=24 read=83130 written=448
177. 145.924 145.924 ↓ 1.0 12,522 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_05 ml_in (cost=0..5,775.83 rows=12,520 width=80) (actual time=0.665..145.924 rows=12,522 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 hit=1 read=5587
178. 107.230 107.230 ↓ 1.0 107,867 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_06 ml_in_1 (cost=0..5,293.01 rows=107,846 width=80) (actual time=0.596..107.23 rows=107,867 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 hit=1 read=3674
179. 139.234 139.234 ↓ 1.0 133,082 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_07 ml_in_2 (cost=0..6,575.23 rows=133,056 width=80) (actual time=0.749..139.234 rows=133,082 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 hit=1 read=4578
180. 154.217 154.217 ↓ 1.0 139,574 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_08 ml_in_3 (cost=0..6,918.61 rows=139,546 width=80) (actual time=0.662..154.217 rows=139,574 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 hit=1 read=4824
181. 177.541 177.541 ↓ 1.0 147,412 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_09 ml_in_4 (cost=0..7,312.18 rows=147,383 width=80) (actual time=0.749..177.541 rows=147,412 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 hit=1 read=5100
182. 133.663 133.663 ↓ 1.0 117,108 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_10 ml_in_5 (cost=0..5,792.62 rows=117,085 width=80) (actual time=3.371..133.663 rows=117,108 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 hit=1 read=4035
183. 13.219 13.219 ↓ 1.0 14,005 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_11 ml_in_6 (cost=0..623.08 rows=14,002 width=80) (actual time=0.803..13.219 rows=14,005 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 hit=1 read=412
184. 13.990 13.990 ↓ 1.0 12,646 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_12 ml_in_7 (cost=0..576.69 rows=12,644 width=80) (actual time=0.994..13.99 rows=12,646 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 hit=1 read=386
185. 158.724 158.724 ↓ 1.0 140,377 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_13 ml_in_8 (cost=0..6,938.65 rows=140,349 width=80) (actual time=0.689..158.724 rows=140,377 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 hit=1 read=4832 written=429
186. 93.025 93.025 ↓ 1.0 90,670 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_14 ml_in_9 (cost=0..4,468.05 rows=90,652 width=80) (actual time=0.745..93.025 rows=90,670 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 hit=1 read=3107 written=19
187. 75.966 75.966 ↓ 1.0 66,580 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_15 ml_in_10 (cost=0..3,297.7 rows=66,567 width=80) (actual time=0.881..75.966 rows=66,580 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 hit=1 read=2298
188. 135.216 135.216 ↓ 1.0 118,108 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_16 ml_in_11 (cost=0..5,866.62 rows=118,085 width=80) (actual time=0.738..135.216 rows=118,108 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 hit=1 read=4094
189. 148.416 148.416 ↓ 1.0 125,313 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_17 ml_in_12 (cost=0..6,197.69 rows=125,288 width=80) (actual time=0.642..148.416 rows=125,313 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 hit=1 read=4317
190. 14.456 14.456 ↓ 1.0 14,116 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_18 ml_in_13 (cost=0..629.74 rows=14,113 width=80) (actual time=0.656..14.456 rows=14,116 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 hit=1 read=417
191. 15.661 15.661 ↓ 1.0 15,693 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_19 ml_in_14 (cost=0..727.39 rows=15,690 width=80) (actual time=0.734..15.661 rows=15,693 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 hit=1 read=491
192. 167.594 167.594 ↓ 1.0 136,901 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_20 ml_in_15 (cost=0..6,773.51 rows=136,874 width=80) (actual time=0.865..167.594 rows=136,901 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 hit=1 read=4719
193. 165.786 165.786 ↓ 1.0 149,613 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_21 ml_in_16 (cost=0..7,415.19 rows=149,583 width=80) (actual time=0.638..165.786 rows=149,613 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 hit=1 read=5170
194. 173.388 173.388 ↓ 1.0 147,429 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_22 ml_in_17 (cost=0..7,292.43 rows=147,400 width=80) (actual time=0.891..173.388 rows=147,429 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 hit=1 read=5080
195. 170.548 170.548 ↓ 1.0 136,234 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_23 ml_in_18 (cost=0..6,738.51 rows=136,207 width=80) (actual time=0.714..170.548 rows=136,234 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 hit=1 read=4694
196. 127.823 127.823 ↓ 1.0 114,380 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_24 ml_in_19 (cost=0..5,662.7 rows=114,357 width=80) (actual time=0.719..127.823 rows=114,380 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 hit=1 read=3946
197. 13.446 13.446 ↓ 1.0 13,253 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_25 ml_in_20 (cost=0..593.79 rows=13,250 width=80) (actual time=0.762..13.446 rows=13,253 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 hit=1 read=394
198. 12.991 12.991 ↓ 1.0 13,042 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_26 ml_in_21 (cost=0..596.63 rows=13,040 width=80) (actual time=0.725..12.991 rows=13,042 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 hit=1 read=400
199. 211.717 211.717 ↓ 1.0 148,547 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_27 ml_in_22 (cost=0..7,594.2 rows=148,518 width=80) (actual time=0.807..211.717 rows=148,547 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 hit=1 read=5365
200. 188.901 188.901 ↓ 1.0 146,867 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_28 ml_in_23 (cost=0..7,414.01 rows=146,838 width=80) (actual time=1.765..188.901 rows=146,867 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 hit=1 read=5210
201. 14,963.178 829,625.020 ↑ 28.5 4,319,914 1

Hash (cost=560,751.53..560,751.53 rows=123,076,816 width=5,058) (actual time=829,625.02..829,625.02 rows=4,319,914 loops=1)

  • Buffers: shared hit=600796805 read=709613, temp read=113458 written=334101
202. 6,408.675 814,661.842 ↑ 28.5 4,319,914 1

Nested Loop (cost=0.83..560,751.53 rows=123,076,816 width=5,058) (actual time=11,024.472..814,661.842 rows=4,319,914 loops=1)

  • Buffers: shared hit=600796805 read=709613, temp read=113458 written=299411
203. 5,909.877 242,344.433 ↓ 317.9 4,319,914 1

Nested Loop (cost=0.41..423,166.8 rows=13,590 width=5,046) (actual time=10,993.278..242,344.433 rows=4,319,914 loops=1)

  • Buffers: shared hit=328080437 read=657161, temp read=113458 written=299411
204. 67,957.910 67,957.910 ↓ 317.9 4,319,914 1

CTE Scan on sessions_united sd (cost=0..271.8 rows=13,590 width=4,919) (actual time=10,991.607..67,957.91 rows=4,319,914 loops=1)

  • Buffers: shared hit=13107265 read=426984, temp read=113458 written=299411
205. 34,559.312 168,476.646 ↑ 24.0 1 4,319,914

Append (cost=0.41..30.88 rows=24 width=139) (actual time=0.021..0.039 rows=1 loops=4,319,914)

  • Buffers: shared hit=314973172 read=230177
206. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_05_pkey on ms_dialogs_sfb_cdr_p2020_01_05 d1 (cost=0.41..1.81 rows=1 width=157) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12959742
207. 8,639.828 8,639.828 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_06_pkey on ms_dialogs_sfb_cdr_p2020_01_06 d1_1 (cost=0.42..1.88 rows=1 width=138) (actual time=0.001..0.002 rows=0 loops=4,319,914)

  • 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=13171743 read=16429
208. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_07_pkey on ms_dialogs_sfb_cdr_p2020_01_07 d1_2 (cost=0.42..1.46 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13213763 read=13755
209. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_08_pkey on ms_dialogs_sfb_cdr_p2020_01_08 d1_3 (cost=0.42..1.48 rows=1 width=136) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13220338 read=13943
210. 8,639.828 8,639.828 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_09_pkey on ms_dialogs_sfb_cdr_p2020_01_09 d1_4 (cost=0.42..1.49 rows=1 width=137) (actual time=0.001..0.002 rows=0 loops=4,319,914)

  • 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=13230289 read=14449
211. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_10_pkey on ms_dialogs_sfb_cdr_p2020_01_10 d1_5 (cost=0.42..1.42 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13184312 read=12657
212. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_11_pkey on ms_dialogs_sfb_cdr_p2020_01_11 d1_6 (cost=0.42..0.66 rows=1 width=157) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12974588 read=2576
213. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_12_pkey on ms_dialogs_sfb_cdr_p2020_01_12 d1_7 (cost=0.42..0.66 rows=1 width=158) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12975161 read=2551
214. 8,639.828 8,639.828 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_13_pkey on ms_dialogs_sfb_cdr_p2020_01_13 d1_8 (cost=0.42..1.49 rows=1 width=136) (actual time=0.001..0.002 rows=0 loops=4,319,914)

  • 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=13229100 read=14211
215. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_14_pkey on ms_dialogs_sfb_cdr_p2020_01_14 d1_9 (cost=0.42..1.28 rows=1 width=140) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13132249 read=10342
216. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_15_pkey on ms_dialogs_sfb_cdr_p2020_01_15 d1_10 (cost=0.42..1.06 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13107337 read=7222
217. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_16_pkey on ms_dialogs_sfb_cdr_p2020_01_16 d1_11 (cost=0.42..1.39 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13228455 read=13158
218. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_17_pkey on ms_dialogs_sfb_cdr_p2020_01_17 d1_12 (cost=0.42..1.43 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13190484 read=13015
219. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_18_pkey on ms_dialogs_sfb_cdr_p2020_01_18 d1_13 (cost=0.42..0.69 rows=1 width=158) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12975664 read=2850
220. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_19_pkey on ms_dialogs_sfb_cdr_p2020_01_19 d1_14 (cost=0.42..0.73 rows=1 width=155) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12984617 read=3306
221. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_20_pkey on ms_dialogs_sfb_cdr_p2020_01_20 d1_15 (cost=0.42..1.47 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13222468 read=13970
222. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_21_pkey on ms_dialogs_sfb_cdr_p2020_01_21 d1_16 (cost=0.42..1.51 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=13238719 read=14768
223. 8,639.828 8,639.828 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_22_pkey on ms_dialogs_sfb_cdr_p2020_01_22 d1_17 (cost=0.42..1.48 rows=1 width=138) (actual time=0.002..0.002 rows=0 loops=4,319,914)

  • 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=13227697 read=14408
224. 8,639.828 8,639.828 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_23_pkey on ms_dialogs_sfb_cdr_p2020_01_23 d1_18 (cost=0.42..1.46 rows=1 width=138) (actual time=0.002..0.002 rows=0 loops=4,319,914)

  • 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=13209671 read=13625
225. 8,639.828 8,639.828 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_24_pkey on ms_dialogs_sfb_cdr_p2020_01_24 d1_19 (cost=0.42..1.39 rows=1 width=138) (actual time=0.002..0.002 rows=0 loops=4,319,914)

  • 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=13169288 read=12050
226. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_25_pkey on ms_dialogs_sfb_cdr_p2020_01_25 d1_20 (cost=0.42..0.72 rows=1 width=159) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12974007 read=3093
227. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_26_pkey on ms_dialogs_sfb_cdr_p2020_01_26 d1_21 (cost=0.42..0.72 rows=1 width=160) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12976029 read=3142
228. 8,639.828 8,639.828 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_27_pkey on ms_dialogs_sfb_cdr_p2020_01_27 d1_22 (cost=0.42..1.54 rows=1 width=137) (actual time=0.001..0.002 rows=0 loops=4,319,914)

  • 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=13217711 read=14655
229. 4,319.914 4,319.914 ↓ 0.0 0 4,319,914

Index Scan using ms_dialogs_sfb_cdr_p2020_01_28_pkey on ms_dialogs_sfb_cdr_p2020_01_28 d1_23 (cost=0.42..1.65 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=4,319,914)

  • 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=12959740 read=2
230. 73,438.538 565,908.734 ↓ 0.0 0 4,319,914

Append (cost=0.41..9.88 rows=24 width=131) (actual time=0.111..0.131 rows=0 loops=4,319,914)

  • Buffers: shared hit=272716368 read=52452
231. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_05_md5_idx on ms_dialog_sfb_qoe_p2020_01_05 d (cost=0.41..0.44 rows=1 width=137) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12337263 read=715
232. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_06_md5_idx on ms_dialog_sfb_qoe_p2020_01_06 d_1 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12388420 read=2954
233. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_07_md5_idx on ms_dialog_sfb_qoe_p2020_01_07 d_2 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12417204 read=3231
234. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_08_md5_idx on ms_dialog_sfb_qoe_p2020_01_08 d_3 (cost=0.42..0.45 rows=1 width=130) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12418740 read=3337
235. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_09_md5_idx on ms_dialog_sfb_qoe_p2020_01_09 d_4 (cost=0.42..0.45 rows=1 width=130) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12426504 read=3504
236. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_10_md5_idx on ms_dialog_sfb_qoe_p2020_01_10 d_5 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12408068 read=3019
237. 17,279.656 17,279.656 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_11_md5_idx on ms_dialog_sfb_qoe_p2020_01_11 d_6 (cost=0.29..0.31 rows=1 width=139) (actual time=0.004..0.004 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=8246386 read=435
238. 17,279.656 17,279.656 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_12_md5_idx on ms_dialog_sfb_qoe_p2020_01_12 d_7 (cost=0.29..0.31 rows=1 width=137) (actual time=0.004..0.004 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=8247079 read=378
239. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_13_md5_idx on ms_dialog_sfb_qoe_p2020_01_13 d_8 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12420847 read=3446
240. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_14_md5_idx on ms_dialog_sfb_qoe_p2020_01_14 d_9 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12374063 read=2220
241. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_15_md5_idx on ms_dialog_sfb_qoe_p2020_01_15 d_10 (cost=0.42..0.44 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12358418 read=1549
242. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_16_md5_idx on ms_dialog_sfb_qoe_p2020_01_16 d_11 (cost=0.42..0.45 rows=1 width=130) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12405507 read=2666
243. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_17_md5_idx on ms_dialog_sfb_qoe_p2020_01_17 d_12 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12413995 read=3146
244. 17,279.656 17,279.656 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_18_md5_idx on ms_dialog_sfb_qoe_p2020_01_18 d_13 (cost=0.29..0.31 rows=1 width=138) (actual time=0.004..0.004 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=8247405 read=440
245. 17,279.656 17,279.656 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_19_md5_idx on ms_dialog_sfb_qoe_p2020_01_19 d_14 (cost=0.29..0.31 rows=1 width=136) (actual time=0.004..0.004 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=8250286 read=465
246. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_20_md5_idx on ms_dialog_sfb_qoe_p2020_01_20 d_15 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12419248 read=3322
247. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_21_md5_idx on ms_dialog_sfb_qoe_p2020_01_21 d_16 (cost=0.42..0.45 rows=1 width=130) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12428592 read=3594
248. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_22_md5_idx on ms_dialog_sfb_qoe_p2020_01_22 d_17 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12425756 read=3556
249. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_23_md5_idx on ms_dialog_sfb_qoe_p2020_01_23 d_18 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12416485 read=3292
250. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_24_md5_idx on ms_dialog_sfb_qoe_p2020_01_24 d_19 (cost=0.42..0.45 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12408951 read=2865
251. 17,279.656 17,279.656 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_25_md5_idx on ms_dialog_sfb_qoe_p2020_01_25 d_20 (cost=0.29..0.31 rows=1 width=139) (actual time=0.004..0.004 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=8251395 read=407
252. 17,279.656 17,279.656 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_26_md5_idx on ms_dialog_sfb_qoe_p2020_01_26 d_21 (cost=0.29..0.31 rows=1 width=138) (actual time=0.004..0.004 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=8245666 read=386
253. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_27_md5_idx on ms_dialog_sfb_qoe_p2020_01_27 d_22 (cost=0.42..0.45 rows=1 width=130) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12422532 read=3448
254. 21,599.570 21,599.570 ↓ 0.0 0 4,319,914

Index Scan using ms_dialog_sfb_qoe_p2020_01_28_md5_idx on ms_dialog_sfb_qoe_p2020_01_28 d_23 (cost=0.42..0.45 rows=1 width=130) (actual time=0.005..0.005 rows=0 loops=4,319,914)

  • Index Cond: (md5((dialog_id)::text) = md5((d1.external_id)::text))
  • 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) AND (ms_source_id = d1.ms_source_id))
  • Buffers: shared hit=12337558 read=77
255.          

CTE user_agent_def

256. 0.030 0.064 ↑ 1.0 42 1

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

  • Group Key: uad_1.ua_type, uad_1.ua_category, uad_1.ms_source_id
  • Buffers: shared hit=1
257. 0.034 0.034 ↑ 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.031..0.034 rows=44 loops=1)

  • Buffers: shared hit=1
258.          

CTE user_agent

259. 10.772 16.694 ↓ 1.0 16,778 1

HashAggregate (cost=804.35..971.88 rows=16,753 width=86) (actual time=12.286..16.694 rows=16,778 loops=1)

  • Group Key: ua.user_agent_key, ua.user_agent, ua.ua_type, uad_2.ua_category, ua.ms_source_id
  • Buffers: shared hit=258
260. 3.767 5.922 ↓ 1.0 16,806 1

Hash Join (cost=2.1..594.94 rows=16,753 width=86) (actual time=0.063..5.922 rows=16,806 loops=1)

  • Buffers: shared hit=258
261. 2.132 2.132 ↓ 1.0 16,778 1

Seq Scan on ms_user_agent_sfb_qoe ua (cost=0..424.53 rows=16,753 width=79) (actual time=0.033..2.132 rows=16,778 loops=1)

  • Buffers: shared hit=257
262. 0.008 0.023 ↑ 1.0 44 1

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

  • Buffers: shared hit=1
263. 0.015 0.015 ↑ 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.008..0.015 rows=44 loops=1)

  • Buffers: shared hit=1
264.          

CTE audio_stream

265. 9,042.728 21,351.547 ↓ 5.0 2,709,728 1

GroupAggregate (cost=507,670.01..610,619.16 rows=541,838 width=217) (actual time=11,808.158..21,351.547 rows=2,709,728 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=4758 read=108273, temp read=23097 written=23106
266. 2,744.350 12,308.819 ↓ 1.0 2,709,728 1

Sort (cost=507,670.01..514,442.98 rows=2,709,188 width=51) (actual time=11,807.971..12,308.819 rows=2,709,728 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: external merge Disk: 184776kB
  • Buffers: shared hit=4716 read=108273, temp read=23097 written=23106
267. 565.922 9,564.469 ↓ 1.0 2,709,728 1

Hash Join (cost=2..163,964.15 rows=2,709,188 width=51) (actual time=25.364..9,564.469 rows=2,709,728 loops=1)

  • Buffers: shared hit=132 read=108273
268. 189.903 8,998.508 ↓ 1.0 2,709,728 1

Append (cost=0..148,941.92 rows=2,709,188 width=42) (actual time=25.092..8,998.508 rows=2,709,728 loops=1)

  • Buffers: shared hit=23 read=108273
269. 429.660 429.660 ↓ 1.0 23,316 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_05 s (cost=0..11,483.74 rows=23,311 width=42) (actual time=25.091..429.66 rows=23,316 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=11133
270. 224.308 224.308 ↓ 1.0 143,947 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_06 s_1 (cost=0..8,249.2 rows=143,918 width=42) (actual time=0.614..224.308 rows=143,947 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=6089
271. 202.698 202.698 ↓ 1.0 169,216 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_07 s_2 (cost=0..8,657.24 rows=169,182 width=42) (actual time=0.981..202.698 rows=169,216 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=6118
272. 244.412 244.412 ↓ 1.0 174,146 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_08 s_3 (cost=0..8,928.19 rows=174,111 width=42) (actual time=0.707..244.412 rows=174,146 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=6315
273. 219.801 219.801 ↓ 1.0 180,998 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_09 s_4 (cost=0..9,268.97 rows=180,962 width=42) (actual time=0.816..219.801 rows=180,998 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=6553
274. 190.943 190.943 ↓ 1.0 158,401 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_10 s_5 (cost=0..8,086.01 rows=158,370 width=42) (actual time=0.7..190.943 rows=158,401 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=5709
275. 29.716 29.716 ↓ 1.0 26,888 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_11 s_6 (cost=0..1,213.32 rows=26,883 width=42) (actual time=0.695..29.716 rows=26,888 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=809
276. 25.161 25.161 ↓ 1.0 22,817 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_12 s_7 (cost=0..1,057.26 rows=22,812 width=42) (actual time=0.702..25.161 rows=22,817 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=714
277. 207.543 207.543 ↓ 1.0 179,192 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_13 s_8 (cost=0..9,141.88 rows=179,156 width=42) (actual time=0.694..207.543 rows=179,192 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=6453
278. 135.564 135.564 ↓ 1.0 115,292 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_14 s_9 (cost=0..5,859.38 rows=115,269 width=42) (actual time=0.661..135.564 rows=115,292 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=4129
279. 93.185 93.185 ↓ 1.0 80,486 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_15 s_10 (cost=0..4,106.29 rows=80,470 width=42) (actual time=0.704..93.185 rows=80,486 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=2898
280. 162.690 162.690 ↓ 1.0 143,508 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_16 s_11 (cost=0..7,345.62 rows=143,479 width=42) (actual time=0.733..162.69 rows=143,508 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=5192
281. 1,759.489 1,759.489 ↓ 1.0 164,813 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_17 s_12 (cost=0..8,417.19 rows=164,780 width=42) (actual time=1.295..1,759.489 rows=164,813 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=5944
282. 754.170 754.170 ↓ 1.0 26,901 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_18 s_13 (cost=0..1,216.51 rows=26,896 width=42) (actual time=32.534..754.17 rows=26,901 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=812
283. 860.733 860.733 ↓ 1.0 27,218 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_19 s_14 (cost=0..1,286.27 rows=27,213 width=42) (actual time=61.177..860.733 rows=27,218 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=877
284. 2,199.642 2,199.642 ↓ 1.0 169,887 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_20 s_15 (cost=0..8,656.31 rows=169,853 width=42) (actual time=51.534..2,199.642 rows=169,887 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=6107
285. 212.043 212.043 ↓ 1.0 183,787 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_21 s_16 (cost=0..9,387.81 rows=183,750 width=42) (actual time=0.668..212.043 rows=183,787 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=6630
286. 209.814 209.814 ↓ 1.0 182,992 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_22 s_17 (cost=0..9,301.88 rows=182,956 width=42) (actual time=0.725..209.814 rows=182,992 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=6556
287. 202.292 202.292 ↓ 1.0 167,581 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_23 s_18 (cost=0..8,534.72 rows=167,548 width=42) (actual time=0.923..202.292 rows=167,581 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=6020
288. 180.715 180.715 ↓ 1.0 148,134 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_24 s_19 (cost=0..7,551.01 rows=148,105 width=42) (actual time=0.923..180.715 rows=148,134 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=5328
289. 23.711 23.711 ↓ 1.0 25,166 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_25 s_20 (cost=0..1,144.49 rows=25,161 width=42) (actual time=0.396..23.711 rows=25,166 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=766
290. 26.124 26.124 ↓ 1.0 23,137 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_26 s_21 (cost=0..1,069.06 rows=23,132 width=42) (actual time=1.841..26.124 rows=23,137 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=721
291. 214.191 214.191 ↓ 1.0 171,905 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_27 s_22 (cost=0..8,979.58 rows=171,871 width=42) (actual time=0.783..214.191 rows=171,905 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=6400
292. 0.012 0.039 ↑ 1.0 40 1

Hash (cost=1.4..1.4 rows=40 width=13) (actual time=0.039..0.039 rows=40 loops=1)

  • Buffers: shared hit=1
293. 0.027 0.027 ↑ 1.0 40 1

Seq Scan on ms_payload_description_sfb_qoe pd (cost=0..1.4 rows=40 width=13) (actual time=0.023..0.027 rows=40 loops=1)

  • Buffers: shared hit=1
294.          

CTE video_stream

295. 342.720 601.004 ↓ 1.3 114,284 1

GroupAggregate (cost=15,241.97..21,224.55 rows=90,092 width=185) (actual time=250.699..601.004 rows=114,284 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=43 read=3211
296. 74.763 258.284 ↓ 1.0 114,801 1

Sort (cost=15,241.97..15,528.91 rows=114,778 width=44) (actual time=250.654..258.284 rows=114,801 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: 18449kB
  • Buffers: shared hit=43 read=3211
297. 26.449 183.521 ↓ 1.0 114,801 1

Hash Join (cost=2..5,595.74 rows=114,778 width=44) (actual time=0.468..183.521 rows=114,801 loops=1)

  • Buffers: shared hit=24 read=3211
298. 9.003 157.052 ↓ 1.0 114,801 1

Append (cost=0..4,956.02 rows=114,778 width=35) (actual time=0.441..157.052 rows=114,801 loops=1)

  • Buffers: shared hit=23 read=3211
299. 0.475 0.475 ↑ 1.0 56 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_05 s_23 (cost=0..2.84 rows=56 width=34) (actual time=0.44..0.475 rows=56 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
300. 5.635 5.635 ↓ 1.0 4,942 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_06 s_24 (cost=0..217.13 rows=4,941 width=34) (actual time=0.551..5.635 rows=4,942 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=142
301. 11.855 11.855 ↓ 1.0 7,433 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_07 s_25 (cost=0..319.5 rows=7,432 width=35) (actual time=0.637..11.855 rows=7,433 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=207
302. 7.834 7.834 ↓ 1.0 8,334 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_08 s_26 (cost=0..359.01 rows=8,332 width=34) (actual time=0.722..7.834 rows=8,334 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=233
303. 9.702 9.702 ↓ 1.0 9,179 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_09 s_27 (cost=0..392.69 rows=9,177 width=34) (actual time=0.656..9.702 rows=9,179 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=254
304. 4.997 4.997 ↓ 1.0 5,077 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_10 s_28 (cost=0..219.16 rows=5,076 width=35) (actual time=0.634..4.997 rows=5,077 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=142
305. 0.358 0.358 ↑ 1.0 44 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_11 s_29 (cost=0..2.66 rows=44 width=35) (actual time=0.332..0.358 rows=44 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
306. 1.056 1.056 ↑ 1.0 191 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_12 s_30 (cost=0..8.87 rows=191 width=35) (actual time=0.66..1.056 rows=191 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=5
307. 8.688 8.688 ↓ 1.0 7,671 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_13 s_31 (cost=0..329.06 rows=7,670 width=35) (actual time=0.584..8.688 rows=7,671 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=213
308. 5.968 5.968 ↓ 1.0 4,901 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_14 s_32 (cost=0..209.51 rows=4,900 width=35) (actual time=1.036..5.968 rows=4,901 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=135
309. 5.983 5.983 ↓ 1.0 4,113 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_15 s_33 (cost=0..176.69 rows=4,112 width=34) (actual time=0.314..5.983 rows=4,113 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=114
310. 11.924 11.924 ↓ 1.0 6,342 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_16 s_34 (cost=0..272.13 rows=6,341 width=35) (actual time=0.568..11.924 rows=6,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 hit=1 read=176
311. 6.751 6.751 ↓ 1.0 5,864 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_17 s_35 (cost=0..252.96 rows=5,863 width=35) (actual time=0.687..6.751 rows=5,864 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=164
312. 0.037 0.037 ↑ 1.0 32 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_18 s_36 (cost=0..1.48 rows=32 width=35) (actual time=0.024..0.037 rows=32 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
313. 1.382 1.382 ↑ 1.0 293 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_19 s_37 (cost=0..13.39 rows=293 width=34) (actual time=0.599..1.382 rows=293 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=8
314. 9.295 9.295 ↓ 1.0 8,298 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_20 s_38 (cost=0..356.47 rows=8,296 width=35) (actual time=0.636..9.295 rows=8,298 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=231
315. 10.261 10.261 ↓ 1.0 8,843 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_21 s_39 (cost=0..379.64 rows=8,841 width=35) (actual time=0.625..10.261 rows=8,843 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=246
316. 12.688 12.688 ↓ 1.0 8,235 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_22 s_40 (cost=0..355.52 rows=8,233 width=35) (actual time=0.609..12.688 rows=8,235 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=231
317. 10.900 10.900 ↓ 1.0 8,402 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_23 s_41 (cost=0..360.03 rows=8,400 width=34) (actual time=0.647..10.9 rows=8,402 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=233
318. 7.938 7.938 ↓ 1.0 5,751 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_24 s_42 (cost=0..248.26 rows=5,750 width=35) (actual time=0.97..7.938 rows=5,751 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=161
319. 0.466 0.466 ↑ 1.0 59 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_25 s_43 (cost=0..2.88 rows=59 width=34) (actual time=0.415..0.466 rows=59 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
320. 1.636 1.636 ↑ 1.0 274 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_26 s_44 (cost=0..12.11 rows=274 width=35) (actual time=0.684..1.636 rows=274 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=7
321. 12.220 12.220 ↓ 1.0 10,467 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_27 s_45 (cost=0..464 rows=10,465 width=35) (actual time=0.84..12.22 rows=10,467 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=306
322. 0.008 0.020 ↑ 1.0 40 1

Hash (cost=1.4..1.4 rows=40 width=13) (actual time=0.02..0.02 rows=40 loops=1)

  • Buffers: shared hit=1
323. 0.012 0.012 ↑ 1.0 40 1

Seq Scan on ms_payload_description_sfb_qoe pd_1 (cost=0..1.4 rows=40 width=13) (actual time=0.008..0.012 rows=40 loops=1)

  • Buffers: shared hit=1
324.          

CTE app_sharing_stream

325. 1,808.551 3,174.228 ↓ 1.5 677,296 1

GroupAggregate (cost=96,068.88..128,643 rows=445,790 width=162) (actual time=1,274.647..3,174.228 rows=677,296 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=24 read=16749, temp read=4737 written=4738
326. 611.133 1,365.677 ↓ 1.0 677,296 1

Sort (cost=96,068.88..97,761.79 rows=677,163 width=47) (actual time=1,274.601..1,365.677 rows=677,296 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: external merge Disk: 37896kB
  • Buffers: shared hit=24 read=16749, temp read=4737 written=4738
327. 98.523 754.544 ↓ 1.0 677,296 1

Hash Join (cost=2..30,488.55 rows=677,163 width=47) (actual time=1.533..754.544 rows=677,296 loops=1)

  • Buffers: shared hit=24 read=16749
328. 45.888 656.001 ↓ 1.0 677,296 1

Append (cost=0..26,931.44 rows=677,163 width=38) (actual time=1.504..656.001 rows=677,296 loops=1)

  • Buffers: shared hit=23 read=16749
329. 3.629 3.629 ↑ 1.0 974 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_05 s_46 (cost=0..75.61 rows=974 width=38) (actual time=1.503..3.629 rows=974 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=60
330. 28.952 28.952 ↓ 1.0 30,465 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_06 s_47 (cost=0..1,214.97 rows=30,459 width=38) (actual time=0.684..28.952 rows=30,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=757
331. 35.809 35.809 ↓ 1.0 43,879 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_07 s_48 (cost=0..1,746.18 rows=43,870 width=38) (actual time=0.666..35.809 rows=43,879 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=1087
332. 41.176 41.176 ↓ 1.0 45,319 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_08 s_49 (cost=0..1,802.78 rows=45,310 width=38) (actual time=0.689..41.176 rows=45,319 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=1122
333. 41.151 41.151 ↓ 1.0 48,797 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_09 s_50 (cost=0..1,937.95 rows=48,787 width=38) (actual time=0.767..41.151 rows=48,797 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=1205
334. 38.567 38.567 ↓ 1.0 38,846 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_10 s_51 (cost=0..1,545.69 rows=38,838 width=38) (actual time=0.804..38.567 rows=38,846 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=962
335. 1.431 1.431 ↑ 1.0 592 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_11 s_52 (cost=0..22.88 rows=592 width=38) (actual time=0.634..1.431 rows=592 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=13
336. 2.161 2.161 ↑ 1.0 1,258 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_12 s_53 (cost=0..49.87 rows=1,258 width=38) (actual time=0.596..2.161 rows=1,258 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=30
337. 39.398 39.398 ↓ 1.0 46,262 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_13 s_54 (cost=0..1,833.93 rows=46,253 width=38) (actual time=0.715..39.398 rows=46,262 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=1139
338. 30.142 30.142 ↓ 1.0 30,522 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_14 s_55 (cost=0..1,209.83 rows=30,516 width=38) (actual time=0.665..30.142 rows=30,522 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=751
339. 20.611 20.611 ↓ 1.0 22,935 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_15 s_56 (cost=0..909.02 rows=22,930 width=38) (actual time=0.788..20.611 rows=22,935 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=564
340. 30.803 30.803 ↓ 1.0 35,077 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_16 s_57 (cost=0..1,384.15 rows=35,070 width=38) (actual time=0.733..30.803 rows=35,077 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=857
341. 34.952 34.952 ↓ 1.0 41,762 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_17 s_58 (cost=0..1,658.43 rows=41,754 width=38) (actual time=1.021..34.952 rows=41,762 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=1031
342. 2.012 2.012 ↑ 1.0 994 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_18 s_59 (cost=0..39.91 rows=994 width=38) (actual time=0.735..2.012 rows=994 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=24
343. 2.828 2.828 ↑ 1.0 2,135 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_19 s_60 (cost=0..86.03 rows=2,135 width=38) (actual time=0.602..2.828 rows=2,135 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=53
344. 39.812 39.812 ↓ 1.0 45,974 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_20 s_61 (cost=0..1,822.61 rows=45,965 width=38) (actual time=0.811..39.812 rows=45,974 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=1132
345. 45.729 45.729 ↓ 1.0 52,551 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_21 s_62 (cost=0..2,081.26 rows=52,541 width=38) (actual time=0.753..45.729 rows=52,551 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=1292
346. 47.260 47.260 ↓ 1.0 49,794 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_22 s_63 (cost=0..1,967.91 rows=49,784 width=38) (actual time=0.731..47.26 rows=49,794 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=1220
347. 40.035 40.035 ↓ 1.0 47,241 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_23 s_64 (cost=0..1,867.62 rows=47,232 width=38) (actual time=0.676..40.035 rows=47,241 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=1158
348. 33.294 33.294 ↓ 1.0 38,430 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_24 s_65 (cost=0..1,518.45 rows=38,422 width=38) (actual time=0.846..33.294 rows=38,430 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=941
349. 1.840 1.840 ↑ 1.0 782 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_25 s_66 (cost=0..30.73 rows=782 width=38) (actual time=0.628..1.84 rows=782 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=18
350. 2.172 2.172 ↑ 1.0 1,471 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_26 s_67 (cost=0..59.06 rows=1,471 width=38) (actual time=0.65..2.172 rows=1,471 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=36
351. 46.349 46.349 ↓ 1.0 51,236 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_27 s_68 (cost=0..2,066.54 rows=51,226 width=38) (actual time=1.955..46.349 rows=51,236 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=1297
352. 0.007 0.020 ↑ 1.0 40 1

Hash (cost=1.4..1.4 rows=40 width=13) (actual time=0.02..0.02 rows=40 loops=1)

  • Buffers: shared hit=1
353. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on ms_payload_description_sfb_qoe pd_2 (cost=0..1.4 rows=40 width=13) (actual time=0.008..0.013 rows=40 loops=1)

  • Buffers: shared hit=1
354.          

CTE prepared_dataset

355. 27,640.927 1,340,251.164 ↑ 1,650.4 4,687,692 1

WindowAgg (cost=116,044,350,246.34..303,965,040,951.43 rows=7,736,545,521 width=9,487) (actual time=1,223,282.58..1,340,251.164 rows=4,687,692 loops=1)

  • Buffers: shared hit=679165322 read=1051183 dirtied=8 written=448, temp read=3808566 written=3129498
356. 76,797.870 1,270,421.009 ↑ 1,650.4 4,687,692 1

Sort (cost=116,044,350,246.34..116,063,691,610.15 rows=7,736,545,521 width=9,435) (actual time=1,223,282.277..1,270,421.009 rows=4,687,692 loops=1)

  • Sort Key: sd_ml.ms_source_id, sd_ml.dialog, sd_ml.media_line_label
  • Sort Method: external merge Disk: 5638688kB
  • Buffers: shared hit=679165270 read=1051183 dirtied=8 written=448, temp read=3076385 written=3107576
357. 9,870.179 1,193,623.139 ↑ 1,650.4 4,687,692 1

WindowAgg (cost=59,593,277,621.2..59,806,032,623.02 rows=7,736,545,521 width=9,435) (actual time=1,172,121.331..1,193,623.139 rows=4,687,692 loops=1)

  • Buffers: shared hit=679165270 read=1051183 dirtied=8 written=448, temp read=2283004 written=2313987
358. 23,080.534 1,183,752.960 ↑ 1,650.4 4,687,692 1

Sort (cost=59,593,277,621.2..59,612,618,985 rows=7,736,545,521 width=9,403) (actual time=1,172,113.988..1,183,752.96 rows=4,687,692 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: external merge Disk: 3058112kB
  • Buffers: shared hit=679160683 read=1051183 dirtied=8 written=448, temp read=1880324 written=2110816
359. 4,815.121 1,160,672.426 ↑ 1,650.4 4,687,692 1

Nested Loop (cost=246,135.56..3,540,818,416.02 rows=7,736,545,521 width=9,403) (actual time=902,342.942..1,160,672.426 rows=4,687,692 loops=1)

  • Buffers: shared hit=679160683 read=1051183 dirtied=8 written=448, temp read=1498060 written=1728424
360. 3,370.660 1,141,794.229 ↑ 237.0 4,687,692 1

Nested Loop (cost=246,135.41..3,157,551,646.87 rows=1,110,774,662 width=9,338) (actual time=902,342.914..1,141,794.229 rows=4,687,692 loops=1)

  • Buffers: shared hit=672186640 read=1051183 dirtied=8 written=448, temp read=1498060 written=1728424
361. 1,840.474 1,124,360.493 ↑ 34.0 4,687,692 1

Nested Loop (cost=246,135.26..3,102,524,113.63 rows=159,479,492 width=9,273) (actual time=902,342.859..1,124,360.493 rows=4,687,692 loops=1)

  • Buffers: shared hit=666695227 read=1051183 dirtied=8 written=448, temp read=1498060 written=1728424
362. 5,131.735 1,117,832.327 ↑ 34.0 4,687,692 1

Nested Loop (cost=246,134.83..3,031,139,141.78 rows=159,479,492 width=9,259) (actual time=902,342.851..1,117,832.327 rows=4,687,692 loops=1)

  • Buffers: shared hit=660183537 read=1050558 dirtied=8 written=448, temp read=1498060 written=1728424
363. 1,280.256 1,108,012.900 ↑ 34.0 4,687,692 1

Nested Loop (cost=246,134.4..2,959,754,169.93 rows=159,479,492 width=9,245) (actual time=902,342.478..1,108,012.9 rows=4,687,692 loops=1)

  • Buffers: shared hit=653802222 read=1045989 dirtied=8 written=448, temp read=1498060 written=1728424
364. 3,535.725 1,102,044.952 ↑ 34.0 4,687,692 1

Nested Loop (cost=246,133.98..2,888,369,198.08 rows=159,479,492 width=9,235) (actual time=902,342.472..1,102,044.952 rows=4,687,692 loops=1)

  • Buffers: shared hit=647856305 read=1045014 dirtied=8 written=448, temp read=1498060 written=1728424
365. 1,171.889 1,093,821.535 ↑ 34.0 4,687,692 1

Nested Loop (cost=246,133.55..2,816,984,226.23 rows=159,479,492 width=9,225) (actual time=902,342.459..1,093,821.535 rows=4,687,692 loops=1)

  • Buffers: shared hit=642021284 read=1040862 dirtied=8 written=448, temp read=1498060 written=1728424
366. 2,347.973 1,087,961.954 ↑ 34.0 4,687,692 1

Nested Loop (cost=246,133.12..2,745,599,254.38 rows=159,479,492 width=9,211) (actual time=902,342.446..1,087,961.954 rows=4,687,692 loops=1)

  • Buffers: shared hit=636125673 read=1040626 dirtied=8 written=448, temp read=1498060 written=1728424
367. 2,837.659 1,080,926.289 ↑ 34.0 4,687,692 1

Hash Join (cost=246,132.69..2,674,214,282.53 rows=159,479,492 width=9,197) (actual time=902,342.41..1,080,926.289 rows=4,687,692 loops=1)

  • Buffers: shared hit=630342031 read=1040205 dirtied=8 written=448, temp read=1498060 written=1728424
368. 2,778.159 1,078,083.169 ↑ 34.0 4,687,692 1

Hash Join (cost=245,546.34..2,004,962,807.49 rows=159,479,492 width=8,541) (actual time=902,336.903..1,078,083.169 rows=4,687,692 loops=1)

  • Buffers: shared hit=630342031 read=1040205 dirtied=8 written=448, temp read=1498060 written=1728424
369. 2,763.691 1,075,279.000 ↑ 34.0 4,687,692 1

Hash Join (cost=244,959.98..1,335,914,907.53 rows=159,479,492 width=7,883) (actual time=902,310.847..1,075,279 rows=4,687,692 loops=1)

  • Buffers: shared hit=630341773 read=1040205 dirtied=8 written=448, temp read=1498060 written=1728424
370. 3,031.364 1,072,383.194 ↑ 34.0 4,687,692 1

Hash Join (cost=229,597.61..1,335,062,277.79 rows=159,479,492 width=7,871) (actual time=902,178.286..1,072,383.194 rows=4,687,692 loops=1)

  • Buffers: shared hit=630334583 read=1040205 dirtied=8 written=448, temp read=1498060 written=1728424
371. 2,695.226 1,068,965.945 ↑ 34.0 4,687,692 1

Hash Join (cost=214,235.23..1,334,209,648.06 rows=159,479,492 width=7,859) (actual time=901,791.98..1,068,965.945 rows=4,687,692 loops=1)

  • Buffers: shared hit=630333220 read=1034378 written=448, temp read=1498060 written=1728424
372. 2,742.346 1,066,270.707 ↑ 34.0 4,687,692 1

Hash Join (cost=214,222.76..1,333,782,130.88 rows=159,479,492 width=7,741) (actual time=901,791.962..1,066,270.707 rows=4,687,692 loops=1)

  • Buffers: shared hit=630333219 read=1034378 written=448, temp read=1498060 written=1728424
373. 2,722.900 1,063,528.341 ↑ 34.0 4,687,692 1

Hash Join (cost=214,210.28..1,333,354,613.7 rows=159,479,492 width=7,623) (actual time=901,791.937..1,063,528.341 rows=4,687,692 loops=1)

  • Buffers: shared hit=630333218 read=1034378 written=448, temp read=1498060 written=1728424
374. 2,778.500 1,060,805.429 ↑ 34.0 4,687,692 1

Hash Join (cost=214,208.81..1,332,150,962.89 rows=159,479,492 width=7,479) (actual time=901,791.918..1,060,805.429 rows=4,687,692 loops=1)

  • Buffers: shared hit=630333218 read=1034378 written=448, temp read=1498060 written=1728424
375. 2,464.334 1,058,026.841 ↑ 34.0 4,687,692 1

Hash Join (cost=214,207.34..1,330,947,312.08 rows=159,479,492 width=7,335) (actual time=901,791.812..1,058,026.841 rows=4,687,692 loops=1)

  • Buffers: shared hit=630333217 read=1034378 written=448, temp read=1498060 written=1728424
376. 2,445.718 1,055,555.356 ↑ 34.0 4,687,692 1

Hash Join (cost=213,387.87..1,330,109,224.85 rows=159,479,492 width=7,297) (actual time=901,784.605..1,055,555.356 rows=4,687,692 loops=1)

  • Buffers: shared hit=630332991 read=1034378 written=448, temp read=1498060 written=1728424
377. 2,526.179 1,053,102.325 ↑ 34.0 4,687,692 1

Hash Join (cost=212,568.39..1,329,271,137.63 rows=159,479,492 width=7,259) (actual time=901,777.25..1,053,102.325 rows=4,687,692 loops=1)

  • Buffers: shared hit=630332765 read=1034378 written=448, temp read=1498060 written=1728424
378. 2,555.451 1,050,569.095 ↑ 34.0 4,687,692 1

Hash Join (cost=211,748.92..1,328,433,050.4 rows=159,479,492 width=7,221) (actual time=901,770.156..1,050,569.095 rows=4,687,692 loops=1)

  • Buffers: shared hit=630332539 read=1034378 written=448, temp read=1498060 written=1728424
379. 2,893.599 1,048,006.279 ↑ 34.0 4,687,692 1

Hash Join (cost=210,929.44..1,327,594,963.18 rows=159,479,492 width=7,183) (actual time=901,762.749..1,048,006.279 rows=4,687,692 loops=1)

  • Buffers: shared hit=630332313 read=1034378 written=448, temp read=1498060 written=1728424
380. 2,902.701 1,045,104.565 ↑ 34.0 4,687,692 1

Hash Join (cost=209,928.99..1,326,756,695.01 rows=159,479,492 width=7,109) (actual time=901,754.588..1,045,104.565 rows=4,687,692 loops=1)

  • Buffers: shared hit=630331957 read=1034378 written=448, temp read=1498060 written=1728424
381. 2,527.798 1,042,192.913 ↑ 34.0 4,687,692 1

Hash Join (cost=208,928.54..1,325,918,426.85 rows=159,479,492 width=7,035) (actual time=901,745.601..1,042,192.913 rows=4,687,692 loops=1)

  • Buffers: shared hit=630331601 read=1034378 written=448, temp read=1498060 written=1728424
382. 2,760.713 1,039,665.105 ↑ 34.0 4,687,692 1

Hash Join (cost=208,926.82..1,325,013,791.45 rows=159,479,492 width=7,021) (actual time=901,745.584..1,039,665.105 rows=4,687,692 loops=1)

  • Buffers: shared hit=630331600 read=1034378 written=448, temp read=1498060 written=1728424
383. 5,215.205 1,036,904.360 ↑ 34.0 4,687,692 1

Hash Join (cost=208,925.09..1,324,109,156.06 rows=159,479,492 width=7,007) (actual time=901,745.532..1,036,904.36 rows=4,687,692 loops=1)

  • Buffers: shared hit=630331599 read=1034378 written=448, temp read=1498060 written=1728424
384. 7,750.479 1,031,653.967 ↑ 34.0 4,687,692 1

Hash Join (cost=204,242.85..1,323,665,899.67 rows=159,479,492 width=6,995) (actual time=901,710.23..1,031,653.967 rows=4,687,692 loops=1)

  • Buffers: shared hit=630328772 read=1034378 written=448, temp read=1498060 written=1728424
385. 979.189 1,023,866.238 ↑ 34.0 4,687,692 1

Nested Loop (cost=199,560.62..1,323,222,643.28 rows=159,479,492 width=6,983) (actual time=901,672.714..1,023,866.238 rows=4,687,692 loops=1)

  • Buffers: shared hit=630325927 read=1034378 written=448, temp read=1498060 written=1728424
386. 3,787.909 1,004,136.281 ↑ 34.0 4,687,692 1

Nested Loop (cost=199,560.18..1,250,938,307.25 rows=159,479,492 width=6,928) (actual time=901,672.71..1,004,136.281 rows=4,687,692 loops=1)

  • Buffers: shared hit=619516011 read=1014281 written=448, temp read=1498060 written=1728424
387. 2,821.009 972,222.220 ↑ 34.0 4,687,692 1

Hash Join (cost=199,559.75..1,178,653,971.22 rows=159,479,492 width=6,873) (actual time=901,672.673..972,222.22 rows=4,687,692 loops=1)

  • Buffers: shared hit=600814147 read=984293 written=448, temp read=1498060 written=1728424
388. 2,801.020 969,188.234 ↑ 34.1 4,675,960 1

Hash Join (cost=189,484.9..999,229,465.64 rows=159,479,492 width=6,733) (actual time=901,459.667..969,188.234 rows=4,675,960 loops=1)

  • Buffers: shared hit=600814147 read=984293 written=448, temp read=1488295 written=1728423
389. 2,647.734 962,716.139 ↑ 34.1 4,670,081 1

Hash Join (cost=179,410.04..819,804,960.07 rows=159,479,492 width=6,593) (actual time=897,788.566..962,716.139 rows=4,670,081 loops=1)

  • Buffers: shared hit=600814123 read=967544 written=448, temp read=1483558 written=1713922
390. 2,384.983 960,023.527 ↑ 34.1 4,670,081 1

Hash Join (cost=177,373.97..782,325,242.93 rows=159,479,492 width=6,429) (actual time=897,743.668..960,023.527 rows=4,670,081 loops=1)

  • Buffers: shared hit=600814123 read=967544 written=448, temp read=1483558 written=1713922
391. 9,602.193 956,984.402 ↑ 34.1 4,670,080 1

Hash Join (cost=175,337.9..744,845,525.79 rows=159,479,492 width=6,265) (actual time=897,089.501..956,984.402 rows=4,670,080 loops=1)

  • Buffers: shared hit=600814080 read=964333 written=448, temp read=1483558 written=1713922
392. 13,121.252 946,393.111 ↑ 34.2 4,668,862 1

Hash Join (cost=163,092.37..527,143,770.97 rows=159,479,492 width=6,069) (actual time=896,100.304..946,393.111 rows=4,668,862 loops=1)

  • Buffers: shared hit=600814053 read=964333 written=448, temp read=1246015 written=1515441
393. 9,166.309 909,612.579 ↑ 34.2 4,668,435 1

Hash Join (cost=150,846.83..309,442,016.16 rows=159,479,492 width=5,873) (actual time=872,441.005..909,612.579 rows=4,668,435 loops=1)

  • Buffers: shared hit=600809295 read=856060 written=448, temp read=1031119 written=1261487
394. 897,298.461 897,298.461 ↑ 34.2 4,668,435 1

CTE Scan on session_details_with_media_line sd_ml (cost=0..3,189,589.84 rows=159,479,492 width=5,855) (actual time=869,292.037..897,298.461 rows=4,668,435 loops=1)

  • Buffers: shared hit=600796833 read=792743 written=448, temp read=850719 written=1081093
395. 439.227 3,147.809 ↓ 1.0 1,908,600 1

Hash (cost=104,408..104,408 rows=1,908,219 width=30) (actual time=3,147.809..3,147.809 rows=1,908,600 loops=1)

  • Buffers: shared hit=12462 read=63317, temp written=9086
396. 130.599 2,708.582 ↓ 1.0 1,908,600 1

Append (cost=0..104,408 rows=1,908,219 width=30) (actual time=0.652..2,708.582 rows=1,908,600 loops=1)

  • Buffers: shared hit=12462 read=63317
397. 112.581 112.581 ↓ 1.0 12,206 1

Seq Scan on ms_session_sfb_qoe_p2020_01_05 session_qoe (cost=0..3,831.09 rows=12,204 width=30) (actual time=0.651..112.581 rows=12,206 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=3647
398. 131.169 131.169 ↓ 1.0 89,490 1

Seq Scan on ms_session_sfb_qoe_p2020_01_06 session_qoe_1 (cost=0..5,011.35 rows=89,472 width=30) (actual time=0.667..131.169 rows=89,490 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=3668
399. 84.965 84.965 ↓ 1.0 106,702 1

Seq Scan on ms_session_sfb_qoe_p2020_01_07 session_qoe_2 (cost=0..3,817.53 rows=106,681 width=30) (actual time=0.63..84.965 rows=106,702 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=2216
400. 83.747 83.747 ↓ 1.0 109,989 1

Seq Scan on ms_session_sfb_qoe_p2020_01_08 session_qoe_3 (cost=0..3,988.84 rows=109,967 width=30) (actual time=0.629..83.747 rows=109,989 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=2338
401. 79.009 79.009 ↓ 1.0 115,105 1

Seq Scan on ms_session_sfb_qoe_p2020_01_09 session_qoe_4 (cost=0..4,150.57 rows=115,082 width=30) (actual time=0.622..79.009 rows=115,105 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=2423
402. 63.642 63.642 ↓ 1.0 98,747 1

Seq Scan on ms_session_sfb_qoe_p2020_01_10 session_qoe_5 (cost=0..3,587.2 rows=98,727 width=30) (actual time=0.607..63.642 rows=98,747 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=2105
403. 18.905 18.905 ↓ 1.0 13,823 1

Seq Scan on ms_session_sfb_qoe_p2020_01_11 session_qoe_6 (cost=0..741.35 rows=13,820 width=30) (actual time=0.839..18.905 rows=13,823 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=533
404. 12.879 12.879 ↓ 1.0 12,098 1

Seq Scan on ms_session_sfb_qoe_p2020_01_12 session_qoe_7 (cost=0..586.47 rows=12,096 width=30) (actual time=0.578..12.879 rows=12,098 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=404
405. 70.738 70.738 ↓ 1.0 112,903 1

Seq Scan on ms_session_sfb_qoe_p2020_01_13 session_qoe_8 (cost=0..4,041.55 rows=112,880 width=30) (actual time=0.653..70.738 rows=112,903 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=2347
406. 64.301 64.301 ↓ 1.0 112,027 1

Seq Scan on ms_session_sfb_qoe_p2020_01_14 session_qoe_9 (cost=0..3,904.4 rows=112,005 width=30) (actual time=0.762..64.301 rows=112,027 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=2223
407. 61.036 61.036 ↓ 1.0 102,347 1

Seq Scan on ms_session_sfb_qoe_p2020_01_15 session_qoe_10 (cost=0..3,552.2 rows=102,327 width=30) (actual time=0.629..61.036 rows=102,347 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=2016
408. 60.319 60.319 ↓ 1.0 89,548 1

Seq Scan on ms_session_sfb_qoe_p2020_01_16 session_qoe_11 (cost=0..3,291.22 rows=89,530 width=30) (actual time=0.803..60.319 rows=89,548 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=1947
409. 68.513 68.513 ↓ 1.0 103,413 1

Seq Scan on ms_session_sfb_qoe_p2020_01_17 session_qoe_12 (cost=0..3,679.19 rows=103,392 width=30) (actual time=0.802..68.513 rows=103,413 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=2127
410. 24.807 24.807 ↓ 1.0 14,000 1

Seq Scan on ms_session_sfb_qoe_p2020_01_18 session_qoe_13 (cost=0..850 rows=13,997 width=30) (actual time=0.816..24.807 rows=14,000 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=639
411. 17.795 17.795 ↓ 1.0 14,765 1

Seq Scan on ms_session_sfb_qoe_p2020_01_19 session_qoe_14 (cost=0..746.48 rows=14,762 width=30) (actual time=0.787..17.795 rows=14,765 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
412. 140.205 140.205 ↓ 1.0 108,487 1

Seq Scan on ms_session_sfb_qoe_p2020_01_20 session_qoe_15 (cost=0..4,074.3 rows=108,465 width=30) (actual time=0.639..140.205 rows=108,487 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=2446
413. 170.723 170.723 ↓ 1.0 118,261 1

Seq Scan on ms_session_sfb_qoe_p2020_01_21 session_qoe_16 (cost=0..4,357.91 rows=118,237 width=30) (actual time=11.071..170.723 rows=118,261 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=2583
414. 407.096 407.096 ↓ 1.0 116,727 1

Seq Scan on ms_session_sfb_qoe_p2020_01_22 session_qoe_17 (cost=0..4,164.9 rows=116,704 width=30) (actual time=15.545..407.096 rows=116,727 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=2413
415. 72.001 72.001 ↓ 1.0 111,300 1

Seq Scan on ms_session_sfb_qoe_p2020_01_23 session_qoe_18 (cost=0..4,058.5 rows=111,278 width=30) (actual time=0.643..72.001 rows=111,300 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=2388
416. 71.480 71.480 ↓ 1.0 93,457 1

Seq Scan on ms_session_sfb_qoe_p2020_01_24 session_qoe_19 (cost=0..3,440.86 rows=93,438 width=30) (actual time=0.777..71.48 rows=93,457 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=2038
417. 18.137 18.137 ↓ 1.0 13,022 1

Seq Scan on ms_session_sfb_qoe_p2020_01_25 session_qoe_20 (cost=0..751.33 rows=13,019 width=30) (actual time=0.725..18.137 rows=13,022 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=555
418. 13.360 13.360 ↓ 1.0 12,340 1

Seq Scan on ms_session_sfb_qoe_p2020_01_26 session_qoe_21 (cost=0..600.1 rows=12,338 width=30) (actual time=0.716..13.36 rows=12,340 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=414
419. 678.630 678.630 ↓ 1.0 112,282 1

Seq Scan on ms_session_sfb_qoe_p2020_01_27 session_qoe_22 (cost=0..23,008.23 rows=112,260 width=30) (actual time=0.808..678.63 rows=112,282 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=21323
420. 51.945 51.945 ↓ 1.0 115,561 1

Seq Scan on ms_session_sfb_qoe_p2020_01_28 session_qoe_23 (cost=0..14,172.42 rows=115,538 width=30) (actual time=0.017..51.945 rows=115,561 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=12439
421. 600.199 23,659.280 ↓ 500.3 1,355,273 1

Hash (cost=12,191.35..12,191.35 rows=2,709 width=212) (actual time=23,659.28..23,659.28 rows=1,355,273 loops=1)

  • Buffers: shared hit=4758 read=108273, temp read=23097 written=77153
422. 23,059.081 23,059.081 ↓ 500.3 1,355,273 1

CTE Scan on audio_stream caller_astr (cost=0..12,191.35 rows=2,709 width=212) (actual time=11,808.162..23,059.081 rows=1,355,273 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=4758 read=108273, temp read=23097 written=62161
423. 481.322 989.098 ↓ 500.0 1,354,455 1

Hash (cost=12,191.35..12,191.35 rows=2,709 width=212) (actual time=989.098..989.098 rows=1,354,455 loops=1)

  • Buffers: temp read=39057 written=14912
424. 507.776 507.776 ↓ 500.0 1,354,455 1

CTE Scan on audio_stream callee_astr (cost=0..12,191.35 rows=2,709 width=212) (actual time=0.013..507.776 rows=1,354,455 loops=1)

  • Filter: (sender_is_caller_pai = 0)
  • Buffers: temp read=39057 written=1
425. 5.827 654.142 ↓ 42.4 19,077 1

Hash (cost=2,027.07..2,027.07 rows=450 width=180) (actual time=654.142..654.142 rows=19,077 loops=1)

  • Buffers: shared hit=43 read=3211
426. 648.315 648.315 ↓ 42.4 19,077 1

CTE Scan on video_stream caller_vstr (cost=0..2,027.07 rows=450 width=180) (actual time=250.71..648.315 rows=19,077 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=43 read=3211
427. 24.269 44.878 ↓ 211.6 95,207 1

Hash (cost=2,027.07..2,027.07 rows=450 width=180) (actual time=44.878..44.878 rows=95,207 loops=1)

428. 20.609 20.609 ↓ 211.6 95,207 1

CTE Scan on video_stream callee_vstr (cost=0..2,027.07 rows=450 width=180) (actual time=0.002..20.609 rows=95,207 loops=1)

  • Filter: (sender_is_caller_pai = 0)
429. 102.639 3,671.075 ↓ 152.3 339,551 1

Hash (cost=10,030.27..10,030.27 rows=2,229 width=156) (actual time=3,671.075..3,671.075 rows=339,551 loops=1)

  • Buffers: shared hit=24 read=16749, temp read=4737 written=14501
430. 3,568.436 3,568.436 ↓ 152.3 339,551 1

CTE Scan on app_sharing_stream caller_appshstr (cost=0..10,030.27 rows=2,229 width=156) (actual time=1,274.652..3,568.436 rows=339,551 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=24 read=16749, temp read=4737 written=14501
431. 87.826 212.977 ↓ 151.5 337,745 1

Hash (cost=10,030.27..10,030.27 rows=2,229 width=156) (actual time=212.977..212.977 rows=337,745 loops=1)

  • Buffers: temp read=9765 written=1
432. 125.151 125.151 ↓ 151.5 337,745 1

CTE Scan on app_sharing_stream callee_appshstr (cost=0..10,030.27 rows=2,229 width=156) (actual time=0.025..125.151 rows=337,745 loops=1)

  • Filter: (sender_is_caller_pai = 0)
  • Buffers: temp read=9765 written=1
433. 28,126.152 28,126.152 ↑ 1.0 1 4,687,692

Index Scan using ms_users_sfb_cdr_pkey on ms_users_sfb_cdr u1 (cost=0.43..0.45 rows=1 width=59) (actual time=0.006..0.006 rows=1 loops=4,687,692)

  • Index Cond: ((sd_ml.ms_source_id = ms_source_id) AND (sd_ml.user_1_id = user_id))
  • Buffers: shared hit=18701864 read=29988
434. 18,750.768 18,750.768 ↑ 1.0 1 4,687,692

Index Scan using ms_users_sfb_cdr_pkey on ms_users_sfb_cdr u2 (cost=0.43..0.45 rows=1 width=59) (actual time=0.004..0.004 rows=1 loops=4,687,692)

  • Index Cond: ((sd_ml.ms_source_id = ms_source_id) AND (sd_ml.user_2_id = user_id))
  • Buffers: shared hit=10809916 read=20097
435. 17.508 37.250 ↑ 1.0 82,455 1

Hash (cost=3,651.55..3,651.55 rows=82,455 width=34) (actual time=37.25..37.25 rows=82,455 loops=1)

  • Buffers: shared hit=2827
436. 19.742 19.742 ↑ 1.0 82,455 1

Seq Scan on ad_users uad1 (cost=0..3,651.55 rows=82,455 width=34) (actual time=0.028..19.742 rows=82,455 loops=1)

  • Buffers: shared hit=2827
437. 16.911 35.188 ↑ 1.0 82,455 1

Hash (cost=3,651.55..3,651.55 rows=82,455 width=34) (actual time=35.188..35.188 rows=82,455 loops=1)

  • Buffers: shared hit=2827
438. 18.277 18.277 ↑ 1.0 82,455 1

Seq Scan on ad_users uad2 (cost=0..3,651.55 rows=82,455 width=34) (actual time=0.009..18.277 rows=82,455 loops=1)

  • Buffers: shared hit=2827
439. 0.006 0.032 ↑ 1.0 29 1

Hash (cost=1.29..1.29 rows=29 width=20) (actual time=0.032..0.032 rows=29 loops=1)

  • Buffers: shared hit=1
440. 0.026 0.026 ↑ 1.0 29 1

Seq Scan on ms_uri_types_sfb_cdr ut1 (cost=0..1.29 rows=29 width=20) (actual time=0.022..0.026 rows=29 loops=1)

  • Buffers: shared hit=1
441. 0.006 0.010 ↑ 1.0 29 1

Hash (cost=1.29..1.29 rows=29 width=20) (actual time=0.01..0.01 rows=29 loops=1)

  • Buffers: shared hit=1
442. 0.004 0.004 ↑ 1.0 29 1

Seq Scan on ms_uri_types_sfb_cdr ut2 (cost=0..1.29 rows=29 width=20) (actual time=0.001..0.004 rows=29 loops=1)

  • Buffers: shared hit=1
443. 4.289 8.951 ↓ 1.0 25,839 1

Hash (cost=613.78..613.78 rows=25,778 width=78) (actual time=8.951..8.951 rows=25,839 loops=1)

  • Buffers: shared hit=356
444. 4.662 4.662 ↓ 1.0 25,839 1

Seq Scan on ms_client_versions_sfb_cdr caller_clv (cost=0..613.78 rows=25,778 width=78) (actual time=0.023..4.662 rows=25,839 loops=1)

  • Buffers: shared hit=356
445. 4.230 8.115 ↓ 1.0 25,839 1

Hash (cost=613.78..613.78 rows=25,778 width=78) (actual time=8.115..8.115 rows=25,839 loops=1)

  • Buffers: shared hit=356
446. 3.885 3.885 ↓ 1.0 25,839 1

Seq Scan on ms_client_versions_sfb_cdr callee_clv (cost=0..613.78 rows=25,778 width=78) (actual time=0.008..3.885 rows=25,839 loops=1)

  • Buffers: shared hit=356
447. 3.672 7.365 ↓ 1.0 23,853 1

Hash (cost=463.39..463.39 rows=23,739 width=44) (actual time=7.364..7.365 rows=23,853 loops=1)

  • Buffers: shared hit=226
448. 3.693 3.693 ↓ 1.0 23,853 1

Seq Scan on ms_device_sfb_qoe dev_caller_cap (cost=0..463.39 rows=23,739 width=44) (actual time=0.027..3.693 rows=23,853 loops=1)

  • Buffers: shared hit=226
449. 3.676 7.051 ↓ 1.0 23,853 1

Hash (cost=463.39..463.39 rows=23,739 width=44) (actual time=7.051..7.051 rows=23,853 loops=1)

  • Buffers: shared hit=226
450. 3.375 3.375 ↓ 1.0 23,853 1

Seq Scan on ms_device_sfb_qoe dev_caller_ren (cost=0..463.39 rows=23,739 width=44) (actual time=0.007..3.375 rows=23,853 loops=1)

  • Buffers: shared hit=226
451. 3.794 7.313 ↓ 1.0 23,853 1

Hash (cost=463.39..463.39 rows=23,739 width=44) (actual time=7.313..7.313 rows=23,853 loops=1)

  • Buffers: shared hit=226
452. 3.519 3.519 ↓ 1.0 23,853 1

Seq Scan on ms_device_sfb_qoe dev_callee_cap (cost=0..463.39 rows=23,739 width=44) (actual time=0.007..3.519 rows=23,853 loops=1)

  • Buffers: shared hit=226
453. 3.752 7.151 ↓ 1.0 23,853 1

Hash (cost=463.39..463.39 rows=23,739 width=44) (actual time=7.151..7.151 rows=23,853 loops=1)

  • Buffers: shared hit=226
454. 3.399 3.399 ↓ 1.0 23,853 1

Seq Scan on ms_device_sfb_qoe dev_callee_ren (cost=0..463.39 rows=23,739 width=44) (actual time=0.009..3.399 rows=23,853 loops=1)

  • Buffers: shared hit=226
455. 0.008 0.088 ↑ 1.0 42 1

Hash (cost=0.84..0.84 rows=42 width=152) (actual time=0.088..0.088 rows=42 loops=1)

  • Buffers: shared hit=1
456. 0.080 0.080 ↑ 1.0 42 1

CTE Scan on user_agent_def caller_uad (cost=0..0.84 rows=42 width=152) (actual time=0.062..0.08 rows=42 loops=1)

  • Buffers: shared hit=1
457. 0.006 0.012 ↑ 1.0 42 1

Hash (cost=0.84..0.84 rows=42 width=152) (actual time=0.012..0.012 rows=42 loops=1)

458. 0.006 0.006 ↑ 1.0 42 1

CTE Scan on user_agent_def callee_uad (cost=0..0.84 rows=42 width=152) (actual time=0..0.006 rows=42 loops=1)

459. 0.006 0.020 ↑ 2.6 43 1

Hash (cost=11.1..11.1 rows=110 width=122) (actual time=0.02..0.02 rows=43 loops=1)

  • Buffers: shared hit=1
460. 0.014 0.014 ↑ 2.6 43 1

Seq Scan on internal_client_type_mapping caller_ctm (cost=0..11.1 rows=110 width=122) (actual time=0.009..0.014 rows=43 loops=1)

  • Buffers: shared hit=1
461. 0.006 0.012 ↑ 2.6 43 1

Hash (cost=11.1..11.1 rows=110 width=122) (actual time=0.012..0.012 rows=43 loops=1)

  • Buffers: shared hit=1
462. 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
463. 74.271 385.885 ↓ 1.0 329,897 1

Hash (cost=10,458.35..10,458.35 rows=326,935 width=18) (actual time=385.885..385.885 rows=329,897 loops=1)

  • Buffers: shared hit=1363 read=5827 dirtied=8
464. 311.614 311.614 ↓ 1.0 329,897 1

Seq Scan on ms_endpoint_sfb_qoe caller_endpoint (cost=0..10,458.35 rows=326,935 width=18) (actual time=1.26..311.614 rows=329,897 loops=1)

  • Buffers: shared hit=1363 read=5827 dirtied=8
465. 70.346 132.115 ↓ 1.0 329,897 1

Hash (cost=10,458.35..10,458.35 rows=326,935 width=18) (actual time=132.115..132.115 rows=329,897 loops=1)

  • Buffers: shared hit=7190
466. 61.769 61.769 ↓ 1.0 329,897 1

Seq Scan on ms_endpoint_sfb_qoe callee_endpoint (cost=0..10,458.35 rows=326,935 width=18) (actual time=0.009..61.769 rows=329,897 loops=1)

  • Buffers: shared hit=7190
467. 3.462 26.010 ↓ 1.0 16,778 1

Hash (cost=335.06..335.06 rows=16,753 width=668) (actual time=26.01..26.01 rows=16,778 loops=1)

  • Buffers: shared hit=258
468. 22.548 22.548 ↓ 1.0 16,778 1

CTE Scan on user_agent caller_ua (cost=0..335.06 rows=16,753 width=668) (actual time=12.29..22.548 rows=16,778 loops=1)

  • Buffers: shared hit=258
469. 2.914 5.461 ↓ 1.0 16,778 1

Hash (cost=335.06..335.06 rows=16,753 width=668) (actual time=5.461..5.461 rows=16,778 loops=1)

470. 2.547 2.547 ↓ 1.0 16,778 1

CTE Scan on user_agent callee_ua (cost=0..335.06 rows=16,753 width=668) (actual time=0.001..2.547 rows=16,778 loops=1)

471. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe caller_subn (cost=0.43..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4,687,692)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.caller_subnet_key))
  • Buffers: shared hit=5783642 read=421
472. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe callee_subn (cost=0.43..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4,687,692)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.callee_subnet_key))
  • Buffers: shared hit=5895611 read=236
473. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe caller_refl_ip (cost=0.43..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4,687,692)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.caller_reflexive_local_ip_addr))
  • Buffers: shared hit=5835021 read=4152
474. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe callee_refl_ip (cost=0.43..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4,687,692)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.callee_reflexive_local_ip_addr))
  • Buffers: shared hit=5945917 read=975
475. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe caller_ip (cost=0.43..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4,687,692)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.caller_ip_addr_key))
  • Buffers: shared hit=6381315 read=4569
476. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe callee_ip (cost=0.43..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4,687,692)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.callee_ip_addr_key))
  • Buffers: shared hit=6511690 read=625
477. 14,063.076 14,063.076 ↓ 0.0 0 4,687,692

Index Scan using idx_internal_network_region_mapping_network_network_ip on internal_network_region_mapping caller_locations (cost=0.15..0.28 rows=7 width=72) (actual time=0.003..0.003 rows=0 loops=4,687,692)

  • Index Cond: ((NULLIF((caller_ip.ip_address)::text, ''::text))::inet << ip)
  • Buffers: shared hit=5491413
478. 14,063.076 14,063.076 ↓ 0.0 0 4,687,692

Index Scan using idx_internal_network_region_mapping_network_network_ip on internal_network_region_mapping callee_locations (cost=0.15..0.28 rows=7 width=72) (actual time=0.003..0.003 rows=0 loops=4,687,692)

  • Index Cond: ((NULLIF((callee_ip.ip_address)::text, ''::text))::inet << ip)
  • Buffers: shared hit=6974043
479.          

SubPlan (for WindowAgg)

480. 9,375.384 23,438.460 ↑ 1.0 1 4,687,692

Aggregate (cost=12.05..12.06 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=4,687,692)

  • Buffers: shared hit=48
481. 9,375.384 14,063.076 ↓ 0.0 0 4,687,692

HashAggregate (cost=5.3..8.3 rows=300 width=32) (actual time=0.002..0.003 rows=0 loops=4,687,692)

  • Group Key: (unnest(caller_astr.codecs))
482. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Append (cost=0..4.55 rows=300 width=32) (actual time=0.001..0.001 rows=0 loops=4,687,692)

483. 0.000 0.000 ↓ 0.0 0 4,687,692

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=4,687,692)

484. 0.000 0.000 ↑ 1.0 1 4,687,692

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=4,687,692)

485. 0.000 0.000 ↓ 0.0 0 4,687,692

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=4,687,692)

486. 0.000 0.000 ↑ 1.0 1 4,687,692

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=4,687,692)

487. 0.000 0.000 ↓ 0.0 0 4,687,692

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=4,687,692)

488. 0.000 0.000 ↑ 1.0 1 4,687,692

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=4,687,692)

489. 9,375.384 18,750.768 ↑ 1.0 1 4,687,692

Aggregate (cost=12.05..12.06 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=4,687,692)

490. 4,687.692 9,375.384 ↓ 0.0 0 4,687,692

HashAggregate (cost=5.3..8.3 rows=300 width=32) (actual time=0.002..0.002 rows=0 loops=4,687,692)

  • Group Key: (unnest(callee_astr.codecs))
491. 4,687.692 4,687.692 ↓ 0.0 0 4,687,692

Append (cost=0..4.55 rows=300 width=32) (actual time=0.001..0.001 rows=0 loops=4,687,692)

492. 0.000 0.000 ↓ 0.0 0 4,687,692

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=4,687,692)

493. 0.000 0.000 ↑ 1.0 1 4,687,692

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=4,687,692)

494. 0.000 0.000 ↓ 0.0 0 4,687,692

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=4,687,692)

495. 0.000 0.000 ↑ 1.0 1 4,687,692

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=4,687,692)

496. 0.000 0.000 ↓ 0.0 0 4,687,692

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=4,687,692)

497. 0.000 0.000 ↑ 1.0 1 4,687,692

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=4,687,692)

498.          

CTE stitched_data_phase1

499. 18,419.144 3,253,397.756 ↑ 317,612,942.1 4,687,692 1

WindowAgg (cost=7.36462374901388e+16..7.63299286354566e+16 rows=1,488,871,647,887,816 width=15,553) (actual time=3,139,606.407..3,253,397.756 rows=4,687,692 loops=1)

  • Buffers: shared hit=679165379 read=1051183 dirtied=8 written=448, temp read=9696169 written=6962147
500. 70,535.597 3,178,726.308 ↑ 317,612,942.1 4,687,692 1

Sort (cost=7.36462374901388e+16..7.36499596692585e+16 rows=1,488,871,647,887,816 width=26,721) (actual time=3,139,606.307..3,178,726.308 rows=4,687,692 loops=1)

  • Sort Key: d1_24.dialog, (COALESCE(d1_24.media_line_label, d2.media_line_label)), d1_24.ms_source_id
  • Sort Method: external merge Disk: 5852624kB
  • Buffers: shared hit=679165379 read=1051183 dirtied=8 written=448, temp read=9696169 written=6962147
501. 1,536,857.360 3,108,190.711 ↑ 317,612,942.1 4,687,692 1

Hash Join (cost=12,271,793,124.43..1.34672318094031e+16 rows=1,488,871,647,887,816 width=26,721) (actual time=1,557,909.991..3,108,190.711 rows=4,687,692 loops=1)

  • Buffers: shared hit=679165379 read=1051183 dirtied=8 written=448, temp read=8964591 written=6230400
502. 1,304,412.149 1,304,412.149 ↑ 1,650.4 4,687,692 1

CTE Scan on prepared_dataset d1_24 (cost=0..154,730,910.42 rows=7,736,545,521 width=14,059) (actual time=1,223,282.593..1,304,412.149 rows=4,687,692 loops=1)

  • Buffers: shared hit=679165322 read=1051183 dirtied=8 written=448, temp read=3133589 written=3107577
503. 118,655.269 266,921.202 ↑ 1,731.9 4,467,208 1

Hash (cost=154,730,910.42..154,730,910.42 rows=7,736,545,521 width=12,700) (actual time=266,921.202..266,921.202 rows=4,467,208 loops=1)

  • Buffers: temp read=1431516 written=784365
504. 148,265.933 148,265.933 ↑ 1,650.4 4,687,692 1

CTE Scan on prepared_dataset d2 (cost=0..154,730,910.42 rows=7,736,545,521 width=12,700) (actual time=0.005..148,265.933 rows=4,687,692 loops=1)

  • Buffers: temp read=1431516 written=778459
505.          

SubPlan (for WindowAgg)

506. 46,876.920 56,252.304 ↑ 1.0 1 4,687,692

Aggregate (cost=1.77..1.78 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=4,687,692)

507. 9,375.384 9,375.384 ↑ 3.2 31 4,687,692

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0.002 rows=31 loops=4,687,692)

508. 0.000 0.000 ↑ 1.0 1 4,687,692

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=4,687,692)

Planning time : 103.439 ms
Execution time : 3,278,607.84 ms