explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xdlh : TOY

Settings
# exclusive inclusive rows x rows loops node
1. 1,414,217.396 1,414,217.396 ↑ 2,429.7 3,855,364 1

CTE Scan on stitched_data_phase1 ph1 (cost=75,901,374,504,888.7..75,943,902,209,581.5 rows=9,367,335,835 width=11,479) (actual time=1,263,191.802..1,414,217.396 rows=3,855,364 loops=1)

  • Filter: (rank = 1)
  • Buffers: shared hit=331770901 read=3304865 dirtied=36 written=8001, temp read=6859306 written=7269392
2.          

CTE session_details

3. 2,263.138 57,347.240 ↓ 1.0 1,637,637 1

WindowAgg (cost=1,688,096.29..1,826,609.4 rows=1,629,566 width=4,280) (actual time=54,525.889..57,347.24 rows=1,637,637 loops=1)

  • Buffers: shared hit=41 read=818731 written=825, temp read=32652 written=32657
4. 4,035.305 55,084.102 ↓ 1.0 1,637,637 1

Sort (cost=1,688,096.29..1,692,170.21 rows=1,629,566 width=122) (actual time=54,525.862..55,084.102 rows=1,637,637 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: 173240kB
  • Buffers: shared hit=41 read=818731 written=825, temp read=32652 written=32657
5. 2,248.311 51,048.797 ↓ 1.0 1,637,637 1

Hash Join (cost=190,776.3..1,457,971.36 rows=1,629,566 width=122) (actual time=5,967.189..51,048.797 rows=1,637,637 loops=1)

  • Buffers: shared hit=41 read=818731 written=825, temp read=10997 written=10995
6. 185.733 42,836.190 ↓ 1.0 1,637,637 1

Append (cost=0..1,058,126.35 rows=1,629,566 width=82) (actual time=0.373..42,836.19 rows=1,637,637 loops=1)

  • Buffers: shared hit=22 read=663492 written=825
7. 1,335.362 1,335.362 ↑ 1.0 122,633 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_06 sd_ (cost=0..42,086.47 rows=123,673 width=82) (actual time=0.373..1,335.362 rows=122,633 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=40231
8. 2,758.989 2,758.989 ↑ 1.0 104,300 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_07 sd__1 (cost=0..81,948.15 rows=108,255 width=82) (actual time=1.671..2,758.989 rows=104,300 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=80324
9. 367.891 1,533.783 ↓ 1.0 107,746 1

Bitmap Heap Scan on ms_session_details_sfb_cdr_p2020_01_08 sd__2 (cost=16,262.7..83,663.41 rows=106,963 width=82) (actual time=1,167.747..1,533.783 rows=107,746 loops=1)

  • Heap Blocks: exact=9677
  • Buffers: shared hit=2 read=23377
10. 1,165.892 1,165.892 ↓ 1.0 107,746 1

Bitmap Index Scan on ms_session_details_sfb_cdr_p2020_01_08_pkey (cost=0..16,235.96 rows=106,963 width=0) (actual time=1,165.892..1,165.892 rows=107,746 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=13700
11. 981.072 1,794.064 ↓ 1.0 104,773 1

Bitmap Heap Scan on ms_session_details_sfb_cdr_p2020_01_09 sd__3 (cost=8,723.52..75,003.77 rows=102,049 width=82) (actual time=814.967..1,794.064 rows=104,773 loops=1)

  • Heap Blocks: exact=10088
  • Buffers: shared hit=2 read=17022
12. 812.992 812.992 ↓ 1.0 104,773 1

Bitmap Index Scan on ms_session_details_sfb_cdr_p2020_01_09_pkey (cost=0..8,698.01 rows=102,049 width=0) (actual time=812.992..812.992 rows=104,773 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=6934
13. 1,314.859 1,650.628 ↓ 1.0 89,041 1

Bitmap Heap Scan on ms_session_details_sfb_cdr_p2020_01_10 sd__4 (cost=7,050.21..59,940.8 rows=88,723 width=82) (actual time=337.634..1,650.628 rows=89,041 loops=1)

  • Heap Blocks: exact=9064
  • Buffers: shared hit=2 read=14609
14. 335.769 335.769 ↓ 1.0 89,041 1

Bitmap Index Scan on ms_session_details_sfb_cdr_p2020_01_10_pkey (cost=0..7,028.03 rows=88,723 width=0) (actual time=335.769..335.769 rows=89,041 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=5545
15. 118.226 118.226 ↓ 1.0 11,418 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_11 sd__5 (cost=0..3,871.27 rows=11,416 width=82) (actual time=0.591..118.226 rows=11,418 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=3699
16. 25.355 25.355 ↓ 1.0 7,481 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_12 sd__6 (cost=0..919.22 rows=7,480 width=82) (actual time=0.687..25.355 rows=7,481 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=806
17. 3,334.772 3,334.772 ↓ 1.0 102,372 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_13 sd__7 (cost=0..61,605.42 rows=101,941 width=82) (actual time=0.641..3,334.772 rows=102,372 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=60076 written=646
18. 4,885.262 4,885.262 ↑ 1.0 106,431 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_14 sd__8 (cost=0..74,482.28 rows=107,531 width=82) (actual time=1.424..4,885.262 rows=106,431 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=72869 written=179
19. 335.018 1,164.350 ↓ 1.0 101,503 1

Bitmap Heap Scan on ms_session_details_sfb_cdr_p2020_01_15 sd__9 (cost=13,540.95..81,675.33 rows=99,525 width=82) (actual time=831.134..1,164.35 rows=101,503 loops=1)

  • Heap Blocks: exact=9417
  • Buffers: shared hit=2 read=20723
20. 829.332 829.332 ↓ 1.0 101,507 1

Bitmap Index Scan on ms_session_details_sfb_cdr_p2020_01_15_pkey (cost=0..13,516.07 rows=99,525 width=0) (actual time=829.332..829.332 rows=101,507 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=11306
21. 1,375.885 1,375.885 ↓ 1.0 102,843 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_16 sd__10 (cost=0..43,673.5 rows=101,080 width=82) (actual time=0.687..1,375.885 rows=102,843 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=42157
22. 471.911 830.819 ↓ 1.0 88,013 1

Bitmap Heap Scan on ms_session_details_sfb_cdr_p2020_01_17 sd__11 (cost=7,281.89..62,555.96 rows=87,073 width=82) (actual time=360.882..830.819 rows=88,013 loops=1)

  • Heap Blocks: exact=9722
  • Buffers: shared hit=2 read=15491
23. 358.908 358.908 ↓ 1.0 88,018 1

Bitmap Index Scan on ms_session_details_sfb_cdr_p2020_01_17_pkey (cost=0..7,260.12 rows=87,073 width=0) (actual time=358.908..358.908 rows=88,018 loops=1)

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

Seq Scan on ms_session_details_sfb_cdr_p2020_01_18 sd__12 (cost=0..5,773.39 rows=14,756 width=82) (actual time=0.334..173.982 rows=14,759 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=5551
25. 28.480 28.480 ↓ 1.0 7,863 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_19 sd__13 (cost=0..1,110.94 rows=7,861 width=82) (actual time=0.634..28.48 rows=7,863 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=992
26. 627.186 627.186 ↓ 1.0 32,347 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_20 sd__14 (cost=0..20,035.21 rows=32,341 width=82) (actual time=0.656..627.186 rows=32,347 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=19549
27. 3,320.198 3,320.198 ↑ 1.0 108,480 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_21 sd__15 (cost=0..63,919.63 rows=108,620 width=82) (actual time=0.667..3,320.198 rows=108,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 read=62290
28. 3,591.964 3,591.964 ↑ 1.0 107,367 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_22 sd__16 (cost=0..71,021.34 rows=108,135 width=82) (actual time=9.075..3,591.964 rows=107,367 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=69399
29. 388.004 1,014.620 ↓ 1.0 106,630 1

Bitmap Heap Scan on ms_session_details_sfb_cdr_p2020_01_23 sd__17 (cost=10,378.29..74,742.37 rows=103,372 width=82) (actual time=628.62..1,014.62 rows=106,630 loops=1)

  • Heap Blocks: exact=9868
  • Buffers: shared hit=2 read=18283
30. 626.616 626.616 ↓ 1.0 106,634 1

Bitmap Index Scan on ms_session_details_sfb_cdr_p2020_01_23_pkey (cost=0..10,352.45 rows=103,372 width=0) (actual time=626.616..626.616 rows=106,634 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=8415
31. 1,252.180 1,623.216 ↓ 1.0 92,340 1

Bitmap Heap Scan on ms_session_details_sfb_cdr_p2020_01_24 sd__18 (cost=8,648.26..68,942.54 rows=91,704 width=82) (actual time=372.986..1,623.216 rows=92,340 loops=1)

  • Heap Blocks: exact=9684
  • Buffers: shared hit=3 read=16647
32. 371.036 371.036 ↓ 1.0 92,542 1

Bitmap Index Scan on ms_session_details_sfb_cdr_p2020_01_24_pkey (cost=0..8,625.34 rows=91,704 width=0) (actual time=371.036..371.036 rows=92,542 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=6964
33. 861.004 861.004 ↓ 1.0 11,297 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_25 sd__19 (cost=0..7,797.45 rows=11,295 width=82) (actual time=7.335..861.004 rows=11,297 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=7627
34. 67.044 67.044 ↓ 1.0 8,840 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_26 sd__20 (cost=0..1,154.6 rows=8,838 width=82) (actual time=0.68..67.044 rows=8,840 loops=1)

  • Filter: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=1021
35. 10,535.268 10,535.268 ↓ 1.0 99,160 1

Seq Scan on ms_session_details_sfb_cdr_p2020_01_27 sd__21 (cost=0..72,203.31 rows=96,935 width=82) (actual time=1.404..10,535.268 rows=99,160 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=70749
36. 123.904 5,964.296 ↓ 1.0 346,693 1

Hash (cost=182,002.4..182,002.4 rows=346,623 width=38) (actual time=5,964.295..5,964.296 rows=346,693 loops=1)

  • Buffers: shared hit=19 read=155239, temp written=1285
37. 37.329 5,840.392 ↓ 1.0 346,693 1

Append (cost=0..182,002.4 rows=346,623 width=38) (actual time=0.352..5,840.392 rows=346,693 loops=1)

  • Buffers: shared hit=19 read=155239
38. 622.810 622.810 ↓ 1.0 43,564 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_06 voip (cost=0..17,349.46 rows=43,555 width=38) (actual time=0.351..622.81 rows=43,564 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=16696
39. 379.610 379.610 ↓ 1.0 19,271 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_07 voip_1 (cost=0..11,657.07 rows=19,267 width=38) (actual time=0.397..379.61 rows=19,271 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=11368
40. 417.119 417.119 ↓ 1.0 22,048 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_08 voip_2 (cost=0..13,091.72 rows=22,044 width=38) (actual time=0.539..417.119 rows=22,048 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=12761
41. 360.217 360.217 ↓ 1.0 18,474 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_09 voip_3 (cost=0..11,058.11 rows=18,470 width=38) (actual time=0.42..360.217 rows=18,474 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=10780
42. 323.849 323.849 ↓ 1.0 16,720 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_10 voip_4 (cost=0..9,428.8 rows=16,717 width=38) (actual time=0.427..323.849 rows=16,720 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=9177
43. 19.043 19.043 ↓ 1.0 4,341 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_11 voip_5 (cost=0..597.12 rows=4,340 width=38) (actual time=1.303..19.043 rows=4,341 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=531
44. 13.155 13.155 ↓ 1.0 5,222 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_12 voip_6 (cost=0..397.33 rows=5,221 width=38) (actual time=0.527..13.155 rows=5,222 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=318
45. 347.302 347.302 ↓ 1.0 18,985 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_13 voip_7 (cost=0..9,725.77 rows=18,981 width=38) (actual time=0.429..347.302 rows=18,985 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=9441
46. 449.379 449.379 ↓ 1.0 20,550 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_14 voip_8 (cost=0..10,538.25 rows=20,546 width=38) (actual time=0.412..449.379 rows=20,550 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=10230
47. 41.544 379.825 ↓ 1.0 19,051 1

Bitmap Heap Scan on ms_voip_details_sfb_cdr_p2020_01_15 voip_9 (cost=3,617.78..16,146.25 rows=19,047 width=38) (actual time=339.518..379.825 rows=19,051 loops=1)

  • Heap Blocks: exact=1854
  • Buffers: shared hit=2 read=4944
48. 338.281 338.281 ↓ 1.0 19,051 1

Bitmap Index Scan on ms_voip_details_sfb_cdr_p2020_01_15_pkey (cost=0..3,613.02 rows=19,047 width=0) (actual time=338.28..338.281 rows=19,051 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=3090
49. 481.188 481.188 ↓ 1.0 18,775 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_16 voip_10 (cost=0..13,118.62 rows=18,771 width=38) (actual time=0.619..481.188 rows=18,775 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=12836
50. 241.505 241.505 ↓ 1.0 17,834 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_17 voip_11 (cost=0..7,514.51 rows=17,830 width=38) (actual time=0.698..241.505 rows=17,834 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=7247
51. 22.366 22.366 ↓ 1.0 7,324 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_18 voip_12 (cost=0..617.86 rows=7,323 width=38) (actual time=1.652..22.366 rows=7,324 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=507
52. 16.375 16.375 ↓ 1.0 5,047 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_19 voip_13 (cost=0..388.7 rows=5,046 width=38) (actual time=0.61..16.375 rows=5,047 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=312
53. 55.449 55.449 ↓ 1.0 8,648 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_20 voip_14 (cost=0..1,529.72 rows=8,646 width=38) (actual time=0.658..55.449 rows=8,648 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=1399
54. 456.648 456.648 ↓ 1.0 20,007 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_21 voip_15 (cost=0..12,777.1 rows=20,003 width=38) (actual time=0.822..456.648 rows=20,007 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=12476
55. 401.288 401.288 ↓ 1.0 19,293 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_22 voip_16 (cost=0..12,554.4 rows=19,289 width=38) (actual time=0.657..401.288 rows=19,293 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=12264
56. 32.946 166.696 ↓ 1.0 19,544 1

Bitmap Heap Scan on ms_voip_details_sfb_cdr_p2020_01_23 voip_17 (cost=2,179.64..14,405.68 rows=19,540 width=38) (actual time=134.695..166.696 rows=19,544 loops=1)

  • Heap Blocks: exact=1695
  • Buffers: shared hit=3 read=3480
57. 133.750 133.750 ↓ 1.0 19,548 1

Bitmap Index Scan on ms_voip_details_sfb_cdr_p2020_01_23_pkey (cost=0..2,174.75 rows=19,540 width=0) (actual time=133.75..133.75 rows=19,548 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=1786
58. 317.769 317.769 ↓ 1.0 16,377 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_24 voip_18 (cost=0..9,443.66 rows=16,374 width=38) (actual time=0.722..317.769 rows=16,377 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=9197
59. 29.100 29.100 ↓ 1.0 3,857 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_25 voip_19 (cost=0..871.86 rows=3,856 width=38) (actual time=0.573..29.1 rows=3,857 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=813
60. 10.183 10.183 ↓ 1.0 5,307 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_26 voip_20 (cost=0..359.61 rows=5,306 width=38) (actual time=0.97..10.183 rows=5,307 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=279
61. 292.187 292.187 ↓ 1.0 16,454 1

Seq Scan on ms_voip_details_sfb_cdr_p2020_01_27 voip_21 (cost=0..8,430.81 rows=16,451 width=38) (actual time=0.96..292.187 rows=16,454 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=8183
62.          

CTE conference_session_details

63. 2,094.546 150,947.101 ↑ 1.1 1,594,569 1

WindowAgg (cost=3,042,521.55..3,121,527.78 rows=1,755,694 width=2,747) (actual time=148,102.18..150,947.101 rows=1,594,569 loops=1)

  • Buffers: shared hit=3809239 read=1328641 dirtied=23 written=6827, temp read=106012 written=106055
64. 2,942.339 148,852.555 ↑ 1.1 1,594,569 1

Sort (cost=3,042,521.55..3,046,910.79 rows=1,755,694 width=193) (actual time=148,102.155..148,852.555 rows=1,594,569 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: 278776kB
  • Buffers: shared hit=3809239 read=1328641 dirtied=23 written=6827, temp read=106012 written=106055
65. 753.127 145,910.216 ↑ 1.1 1,594,569 1

Gather (cost=2,556,257.8..2,762,007.99 rows=1,755,694 width=193) (actual time=144,406.501..145,910.216 rows=1,594,569 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=3809239 read=1328641 dirtied=23 written=6827, temp read=71165 written=71195
66. 211.898 145,157.089 ↑ 1.3 265,762 6 / 6

Merge Join (cost=2,555,257.8..2,585,438.59 rows=351,139 width=193) (actual time=144,332.433..145,157.089 rows=265,762 loops=6)

  • Buffers: shared hit=3809239 read=1328641 dirtied=23 written=6827, temp read=71165 written=71195
67. 200.987 112,881.357 ↑ 1.2 265,750 6 / 6

Merge Join (cost=1,910,002.09..1,923,642.43 rows=319,252 width=165) (actual time=112,480.753..112,881.357 rows=265,750 loops=6)

  • Buffers: shared hit=1426613 read=852930 dirtied=3, temp read=46169 written=46181
68. 1,467.832 78,046.663 ↑ 1.2 265,750 6 / 6

Sort (cost=1,254,716.02..1,255,514.15 rows=319,252 width=141) (actual time=78,000.341..78,046.663 rows=265,750 loops=6)

  • Sort Key: csd_.session_id_time, csd_.session_id_seq, csd_.ms_source_id
  • Sort Method: external sort Disk: 41800kB
  • Buffers: shared hit=129 read=568462 dirtied=1, temp read=27599 written=27599
69. 92.950 76,578.831 ↑ 1.2 265,750 6 / 6

Hash Join (cost=20,167.26..1,212,106.06 rows=319,252 width=141) (actual time=801.169..76,578.831 rows=265,750 loops=6)

  • Buffers: shared hit=54 read=568462 dirtied=1
70. 31.261 76,484.453 ↑ 1.5 265,750 6 / 6

Append (cost=20,165.86..1,209,763.41 rows=410,620 width=125) (actual time=799.714..76,484.453 rows=265,750 loops=6)

  • Buffers: shared hit=49 read=568461
71. 2,035.811 2,173.997 ↑ 1.5 14,380 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_06 csd_ (cost=20,165.86..83,037.17 rows=22,082 width=125) (actual time=799.712..2,173.997 rows=14,380 loops=6)

  • Heap Blocks: exact=2651
  • Buffers: shared hit=2 read=32313
72. 138.186 138.186 ↑ 1.0 86,280 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_06_pkey (cost=0..20,143.78 rows=88,328 width=0) (actual time=829.114..829.114 rows=86,280 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=17382
73. 4,722.859 4,890.530 ↑ 1.5 17,108 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_07 csd__1 (cost=24,120.97..104,522.98 rows=25,799 width=125) (actual time=1,090.428..4,890.53 rows=17,108 loops=6)

  • Heap Blocks: exact=5257
  • Buffers: shared hit=3 read=44399
74. 167.671 167.671 ↑ 1.0 102,647 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_07_pkey (cost=0..24,095.17 rows=103,195 width=0) (actual time=1,006.028..1,006.028 rows=102,647 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=20587
75. 4,659.395 4,740.852 ↑ 1.5 17,356 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_08 csd__2 (cost=9,978.5..82,027.67 rows=25,965 width=125) (actual time=493.852..4,740.852 rows=17,356 loops=6)

  • Heap Blocks: exact=4228
  • Buffers: shared hit=3 read=32792
76. 81.457 81.457 ↓ 1.0 104,147 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_08_pkey (cost=0..9,952.54 rows=103,861 width=0) (actual time=488.743..488.743 rows=104,147 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=8050
77. 7,547.148 8,049.812 ↑ 1.5 18,135 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_09 csd__3 (cost=8,214.06..77,742.35 rows=26,957 width=125) (actual time=3,085.211..8,049.812 rows=18,135 loops=6)

  • Heap Blocks: exact=3739
  • Buffers: shared hit=3 read=33136
78. 502.664 502.664 ↓ 1.0 108,830 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_09_pkey (cost=0..8,187.11 rows=107,828 width=0) (actual time=3,015.983..3,015.983 rows=108,830 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=6420
79. 5,524.561 6,050.130 ↑ 1.5 13,373 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_10 csd__4 (cost=6,347.41..61,583.11 rows=19,876 width=125) (actual time=3,216.93..6,050.13 rows=13,373 loops=6)

  • Heap Blocks: exact=2707
  • Buffers: shared hit=3 read=27551
80. 525.569 525.569 ↓ 1.0 80,441 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_10_pkey (cost=0..6,327.54 rows=79,506 width=0) (actual time=3,153.414..3,153.414 rows=80,441 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=4997
81. 631.599 631.599 ↑ 2.5 1,551 6 / 6

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_11 csd__5 (cost=0..3,846.18 rows=3,878 width=125) (actual time=3.059..631.599 rows=1,551 loops=6)

  • 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=3788
82. 82.681 82.681 ↑ 3.5 1,345 6 / 6

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_12 csd__6 (cost=0..755.21 rows=4,746 width=125) (actual time=0.504..82.681 rows=1,345 loops=6)

  • 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=683
83. 4,410.802 4,564.624 ↑ 1.5 16,378 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_13 csd__7 (cost=7,142.11..66,362.41 rows=24,663 width=125) (actual time=947.889..4,564.624 rows=16,378 loops=6)

  • Heap Blocks: exact=3425
  • Buffers: shared hit=3 read=29322
84. 153.822 153.822 ↑ 1.0 98,328 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_13_pkey (cost=0..7,117.45 rows=98,653 width=0) (actual time=922.933..922.933 rows=98,328 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=5537
85. 4,546.231 4,546.231 ↑ 1.2 17,625 6 / 6

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_14 csd__8 (cost=0..84,071.27 rows=20,947 width=125) (actual time=21.686..4,546.231 rows=17,625 loops=6)

  • 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=83757
86. 3,631.797 3,761.856 ↑ 1.5 17,489 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_15 csd__9 (cost=12,842.94..89,842.77 rows=26,368 width=125) (actual time=791.44..3,761.856 rows=17,489 loops=6)

  • Heap Blocks: exact=7161
  • Buffers: shared hit=2 read=36251
87. 130.059 130.059 ↓ 1.0 105,604 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_15_pkey (cost=0..12,816.57 rows=105,474 width=0) (actual time=780.355..780.355 rows=105,604 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=10624
88. 5,034.095 5,134.829 ↑ 1.5 17,822 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_16 csd__10 (cost=9,174.17..79,534.65 rows=26,308 width=125) (actual time=618.501..5,134.829 rows=17,822 loops=6)

  • Heap Blocks: exact=6795
  • Buffers: shared hit=4 read=33826
89. 100.733 100.733 ↓ 1.0 107,835 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_16_pkey (cost=0..9,147.86 rows=105,233 width=0) (actual time=604.401..604.401 rows=107,835 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=7312
90. 3,983.411 4,053.685 ↑ 1.5 14,156 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_17 csd__11 (cost=6,976.15..57,155.7 rows=21,394 width=125) (actual time=472.576..4,053.685 rows=14,156 loops=6)

  • Heap Blocks: exact=3811
  • Buffers: shared hit=3 read=27350
91. 70.274 70.274 ↑ 1.0 85,377 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_17_pkey (cost=0..6,954.76 rows=85,577 width=0) (actual time=421.646..421.646 rows=85,377 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=5509
92. 83.547 83.547 ↑ 3.5 1,544 6 / 6

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_18 csd__12 (cost=0..2,787.75 rows=5,449 width=125) (actual time=0.78..83.547 rows=1,544 loops=6)

  • 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=2705
93. 49.635 49.635 ↑ 3.5 1,371 6 / 6

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_19 csd__13 (cost=0..1,440.58 rows=4,838 width=125) (actual time=0.609..49.635 rows=1,371 loops=6)

  • 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=1368
94. 721.311 740.761 ↑ 1.9 3,636 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_20 csd__14 (cost=1,843.25..14,762.12 rows=7,037 width=125) (actual time=118.795..740.761 rows=3,636 loops=6)

  • Heap Blocks: exact=1267
  • Buffers: shared hit=3 read=5583
95. 19.450 19.450 ↓ 1.0 21,818 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_20_pkey (cost=0..1,837.79 rows=21,814 width=0) (actual time=116.699..116.699 rows=21,818 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=1460
96. 5,054.945 5,150.882 ↑ 1.5 19,050 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_21 csd__15 (cost=10,279.39..86,042.98 rows=28,608 width=125) (actual time=588.292..5,150.882 rows=19,050 loops=6)

  • Heap Blocks: exact=8629
  • Buffers: shared hit=2 read=35661
97. 95.937 95.937 ↓ 1.0 116,353 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_21_pkey (cost=0..10,250.78 rows=114,433 width=0) (actual time=575.62..575.62 rows=116,353 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=2 read=8227
98. 5,365.889 5,449.668 ↑ 1.5 20,016 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_22 csd__16 (cost=8,470.06..85,742.08 rows=30,329 width=125) (actual time=510.545..5,449.668 rows=20,016 loops=6)

  • Heap Blocks: exact=3493
  • Buffers: shared hit=3 read=38804
99. 83.778 83.778 ↑ 1.0 120,125 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_22_pkey (cost=0..8,439.73 rows=121,317 width=0) (actual time=502.671..502.671 rows=120,125 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=6526
100. 4,864.813 4,957.492 ↑ 1.5 18,273 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_23 csd__17 (cost=9,616.75..77,843.85 rows=27,578 width=125) (actual time=580.212..4,957.492 rows=18,273 loops=6)

  • Heap Blocks: exact=3322
  • Buffers: shared hit=3 read=32767
101. 92.679 92.679 ↑ 1.0 109,917 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_23_pkey (cost=0..9,589.17 rows=110,313 width=0) (actual time=556.075..556.075 rows=109,917 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=7663
102. 4,115.171 4,190.030 ↑ 1.5 14,990 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_24 csd__18 (cost=8,058.09..65,857.6 rows=22,590 width=125) (actual time=496.442..4,190.03 rows=14,990 loops=6)

  • Heap Blocks: exact=3053
  • Buffers: shared hit=3 read=30127
103. 74.859 74.859 ↑ 1.0 90,308 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_24_pkey (cost=0..8,035.5 rows=90,360 width=0) (actual time=449.156..449.156 rows=90,308 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=6443
104. 611.895 674.380 ↑ 2.5 1,732 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_25 csd__19 (cost=974.86..7,516.56 rows=4,330 width=125) (actual time=517.026..674.38 rows=1,732 loops=6)

  • Heap Blocks: exact=275
  • Buffers: shared hit=3 read=2391
105. 62.485 62.485 ↓ 1.0 10,395 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_25_pkey (cost=0..972.26 rows=10,393 width=0) (actual time=374.908..374.908 rows=10,395 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=782
106. 80.310 80.310 ↑ 3.5 1,619 6 / 6

Seq Scan on ms_conference_session_details_sfb_cdr_p2020_01_26 csd__20 (cost=0..1,639.7 rows=5,712 width=125) (actual time=15.997..80.31 rows=1,619 loops=6)

  • 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=1553
107. 6,076.347 6,395.661 ↑ 1.5 16,799 6 / 6

Bitmap Heap Scan on ms_conference_session_details_sfb_cdr_p2020_01_27 csd__21 (cost=11,447.24..75,648.71 rows=25,166 width=125) (actual time=1,922.375..6,395.661 rows=16,799 loops=6)

  • Heap Blocks: exact=3698
  • Buffers: shared hit=3 read=32334
108. 319.314 319.314 ↓ 1.0 100,846 1 / 6

Bitmap Index Scan on ms_conference_session_details_sfb_cdr_p2020_01_27_pkey (cost=0..11,422.08 rows=100,666 width=0) (actual time=1,915.886..1,915.886 rows=100,846 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3 read=9407
109. 0.011 1.428 ↑ 1.0 16 6 / 6

Hash (cost=1.16..1.16 rows=16 width=20) (actual time=1.428..1.428 rows=16 loops=6)

  • Buffers: shared hit=5 read=1 dirtied=1
110. 1.417 1.417 ↑ 1.0 16 6 / 6

Seq Scan on ms_uri_types_sfb_cdr ut (cost=0..1.16 rows=16 width=20) (actual time=1.415..1.417 rows=16 loops=6)

  • Buffers: shared hit=5 read=1 dirtied=1
111. 80.819 34,633.707 ↑ 1.0 630,608 6 / 6

Materialize (cost=655,284.15..658,456.63 rows=634,496 width=30) (actual time=34,479.896..34,633.707 rows=630,608 loops=6)

  • Buffers: shared hit=1426484 read=284468 dirtied=2, temp read=18570 written=18582
112. 389.382 34,552.888 ↑ 1.0 630,608 6 / 6

Sort (cost=655,284.15..656,870.39 rows=634,496 width=30) (actual time=34,479.889..34,552.888 rows=630,608 loops=6)

  • Sort Key: fjl.dialog_session_id_time, fjl.dialog_session_id_seq, fjl.ms_source_id
  • Sort Method: external merge Disk: 24760kB
  • Buffers: shared hit=1426484 read=284468 dirtied=2, temp read=18570 written=18582
113. 68.931 34,163.506 ↑ 1.0 634,036 6 / 6

Append (cost=0..585,240.9 rows=634,496 width=30) (actual time=8.521..34,163.506 rows=634,036 loops=6)

  • Buffers: shared hit=1426484 read=284468 dirtied=2
114. 60.483 60.483 ↓ 1.0 1,342 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_05 fjl (cost=0..655.22 rows=1,319 width=30) (actual time=8.521..60.483 rows=1,342 loops=6)

  • 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=2995 read=599
115. 5,761.835 5,761.835 ↑ 1.0 35,098 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_06 fjl_1 (cost=0..38,139.77 rows=35,312 width=30) (actual time=0.721..5,761.835 rows=35,098 loops=6)

  • 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=188050 read=37610
116. 357.363 1,501.361 ↑ 1.0 39,927 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_07 fjl_2 (cost=21,284.88..54,193.4 rows=41,139 width=30) (actual time=1,145.929..1,501.361 rows=39,927 loops=6)

  • Heap Blocks: exact=8152
  • Buffers: shared hit=117832 read=23563
117. 1,143.998 1,143.998 ↑ 1.0 39,927 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_07_pkey (cost=0..21,274.6 rows=41,139 width=0) (actual time=1,143.998..1,143.998 rows=39,927 loops=6)

  • Index Cond: ((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=77072 read=15411
118. 1,095.338 1,762.655 ↓ 1.0 40,513 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_08 fjl_3 (cost=11,312.09..43,051.1 rows=40,488 width=30) (actual time=669.291..1,762.655 rows=40,513 loops=6)

  • Heap Blocks: exact=8063
  • Buffers: shared hit=89376 read=17873
119. 667.317 667.317 ↓ 1.0 40,624 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_08_pkey (cost=0..11,301.97 rows=40,488 width=0) (actual time=667.317..667.317 rows=40,624 loops=6)

  • Index Cond: ((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=49061 read=9810
120. 1,241.299 1,622.343 ↓ 1.0 41,905 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_09 fjl_4 (cost=6,164.8..33,113.4 rows=41,738 width=30) (actual time=382.63..1,622.343 rows=41,905 loops=6)

  • Heap Blocks: exact=8364
  • Buffers: shared hit=67657 read=13528
121. 381.044 381.044 ↓ 1.0 41,905 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_09_pkey (cost=0..6,154.37 rows=41,738 width=0) (actual time=381.044..381.044 rows=41,905 loops=6)

  • Index Cond: ((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=25837 read=5164
122. 1,171.580 1,460.726 ↓ 1.0 31,793 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_10 fjl_5 (cost=4,114.82..26,608.61 rows=31,692 width=30) (actual time=290.202..1,460.726 rows=31,793 loops=6)

  • Heap Blocks: exact=6944
  • Buffers: shared hit=51796 read=10357
123. 289.146 289.146 ↓ 1.0 31,829 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_10_pkey (cost=0..4,106.89 rows=31,692 width=0) (actual time=289.146..289.146 rows=31,829 loops=6)

  • Index Cond: ((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=17076 read=3413
124. 183.850 183.850 ↓ 1.0 4,567 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_11 fjl_6 (cost=0..821.5 rows=4,566 width=30) (actual time=9.529..183.85 rows=4,567 loops=6)

  • 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=3766 read=752
125. 10.113 10.113 ↓ 1.0 4,078 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_12 fjl_7 (cost=0..272.17 rows=4,077 width=30) (actual time=0.548..10.113 rows=4,078 loops=6)

  • 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=1056 read=210
126. 1,212.670 1,588.947 ↓ 1.0 38,861 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_13 fjl_8 (cost=5,587.61..33,462.92 rows=38,656 width=30) (actual time=378.164..1,588.947 rows=38,861 loops=6)

  • Heap Blocks: exact=7650
  • Buffers: shared hit=61636 read=12325
127. 376.277 376.277 ↓ 1.0 39,001 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_13_pkey (cost=0..5,577.95 rows=38,656 width=0) (actual time=376.277..376.277 rows=39,001 loops=6)

  • Index Cond: ((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=23386 read=4675
128. 1,678.208 1,678.208 ↑ 1.0 41,270 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_14 fjl_9 (cost=0..40,720.13 rows=41,335 width=30) (actual time=9.961..1,678.208 rows=41,270 loops=6)

  • 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=200500 read=40100
129. 649.401 1,257.261 ↑ 1.0 41,016 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_15 fjl_10 (cost=8,231.05..39,070.2 rows=41,031 width=30) (actual time=609.352..1,257.261 rows=41,016 loops=6)

  • Heap Blocks: exact=8640
  • Buffers: shared hit=78348 read=15665
130. 607.860 607.860 ↓ 1.0 41,223 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_15_pkey (cost=0..8,220.8 rows=41,031 width=0) (actual time=607.86..607.86 rows=41,223 loops=6)

  • Index Cond: ((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=35147 read=7026
131. 1,186.042 1,613.472 ↓ 1.0 42,115 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_16 fjl_11 (cost=7,129.56..37,835.69 rows=42,066 width=30) (actual time=428.911..1,613.472 rows=42,115 loops=6)

  • Heap Blocks: exact=8715
  • Buffers: shared hit=73741 read=14746
132. 427.430 427.430 ↓ 1.0 42,257 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_16_pkey (cost=0..7,119.05 rows=42,066 width=0) (actual time=427.43..427.43 rows=42,257 loops=6)

  • Index Cond: ((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=30166 read=6031
133. 932.343 1,199.367 ↓ 1.0 33,314 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_17 fjl_12 (cost=4,674.67..30,375.56 rows=33,190 width=30) (actual time=268.582..1,199.367 rows=33,314 loops=6)

  • Heap Blocks: exact=6728
  • Buffers: shared hit=53176 read=10633
134. 267.024 267.024 ↓ 1.0 33,316 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_17_pkey (cost=0..4,666.38 rows=33,190 width=0) (actual time=267.024..267.024 rows=33,316 loops=6)

  • Index Cond: ((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=19536 read=3905
135. 30.911 30.911 ↓ 1.0 4,476 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_18 fjl_13 (cost=0..951.14 rows=4,475 width=30) (actual time=0.422..30.911 rows=4,476 loops=6)

  • 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=4421 read=883
136. 17.391 17.391 ↓ 1.0 4,157 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_19 fjl_14 (cost=0..541.36 rows=4,156 width=30) (actual time=0.347..17.391 rows=4,157 loops=6)

  • 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=2396 read=478
137. 132.660 132.660 ↓ 1.0 9,523 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_20 fjl_15 (cost=0..3,732.84 rows=9,522 width=30) (actual time=0.469..132.66 rows=9,523 loops=6)

  • 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=17951 read=3589
138. 1,133.603 1,692.082 ↑ 1.0 45,364 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_21 fjl_16 (cost=8,066.07..39,135.72 rows=45,754 width=30) (actual time=560.381..1,692.082 rows=45,364 loops=6)

  • Heap Blocks: exact=9106
  • Buffers: shared hit=79762 read=15949
139. 558.479 558.479 ↓ 1.0 45,879 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_21_pkey (cost=0..8,054.64 rows=45,754 width=0) (actual time=558.479..558.479 rows=45,879 loops=6)

  • Index Cond: ((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=34232 read=6843
140. 1,569.010 2,680.389 ↓ 1.0 45,727 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_22 fjl_17 (cost=5,933.69..36,155.5 rows=45,697 width=30) (actual time=1,114.841..2,680.389 rows=45,727 loops=6)

  • Heap Blocks: exact=9539
  • Buffers: shared hit=72311 read=14460
141. 1,111.379 1,111.379 ↓ 1.0 45,838 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_22_pkey (cost=0..5,922.27 rows=45,697 width=0) (actual time=1,111.378..1,111.379 rows=45,838 loops=6)

  • Index Cond: ((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=24616 read=4921
142. 1,436.111 2,469.989 ↓ 1.0 42,162 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_23 fjl_18 (cost=6,826.35..39,275.71 rows=40,816 width=30) (actual time=1,039.184..2,469.989 rows=42,162 loops=6)

  • Heap Blocks: exact=8487
  • Buffers: shared hit=71300 read=14259
143. 1,033.878 1,033.878 ↓ 1.0 42,464 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_23_pkey (cost=0..6,816.15 rows=40,816 width=0) (actual time=1,033.878..1,033.878 rows=42,464 loops=6)

  • Index Cond: ((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=28865 read=5772
144. 1,279.719 2,076.293 ↑ 1.0 34,277 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_24 fjl_19 (cost=5,587.68..35,341.86 rows=35,122 width=30) (actual time=799.34..2,076.293 rows=34,277 loops=6)

  • Heap Blocks: exact=7497
  • Buffers: shared hit=61020 read=12203
145. 796.574 796.574 ↑ 1.0 34,324 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_24_pkey (cost=0..5,578.9 rows=35,122 width=0) (actual time=796.574..796.574 rows=34,324 loops=6)

  • Index Cond: ((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=23535 read=4706
146. 80.257 80.257 ↓ 1.0 4,936 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_25 fjl_20 (cost=0..1,210.04 rows=4,935 width=30) (actual time=1.463..80.257 rows=4,936 loops=6)

  • 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=5680 read=1136
147. 23.254 23.254 ↓ 1.0 4,360 6 / 6

Seq Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_26 fjl_21 (cost=0..489.4 rows=4,359 width=30) (actual time=1.032..23.254 rows=4,360 loops=6)

  • 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=2120 read=424
148. 1,409.516 2,391.951 ↓ 1.0 39,978 6 / 6

Bitmap Heap Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_27 fjl_22 (cost=9,960.47..40,446.91 rows=39,764 width=30) (actual time=984.869..2,391.951 rows=39,978 loops=6)

  • Heap Blocks: exact=8018
  • Buffers: shared hit=83115 read=16622
149. 982.435 982.435 ↓ 1.0 40,138 6 / 6

Bitmap Index Scan on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_27_pkey (cost=0..9,950.53 rows=39,764 width=0) (actual time=982.435..982.435 rows=40,138 loops=6)

  • Index Cond: ((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=43025 read=8604
150. 2,798.777 2,798.777 ↑ 1.0 3,277 6 / 6

Index Scan using ms_focus_joins_and_leaves_sfb_cdr_p2020_01_28_pkey on ms_focus_joins_and_leaves_sfb_cdr_p2020_01_28 fjl_23 (cost=0.41..9,640.74 rows=3,287 width=30) (actual time=264.18..2,798.777 rows=3,277 loops=6)

  • Index Cond: ((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=36479 read=6504 dirtied=2
151. 108.979 32,063.834 ↑ 1.0 855,892 6 / 6

Materialize (cost=645,253.12..649,576.69 rows=864,714 width=30) (actual time=31,851.261..32,063.834 rows=855,892 loops=6)

  • Buffers: shared hit=2382626 read=475711 dirtied=20 written=6827, temp read=24996 written=25014
152. 535.904 31,954.855 ↑ 1.0 855,892 6 / 6

Sort (cost=645,253.12..647,414.9 rows=864,714 width=30) (actual time=31,851.256..31,954.855 rows=855,892 loops=6)

  • Sort Key: mjl.dialog_session_id_time, mjl.dialog_session_id_seq, mjl.ms_source_id
  • Sort Method: external merge Disk: 33328kB
  • Buffers: shared hit=2382626 read=475711 dirtied=20 written=6827, temp read=24996 written=25014
153. 94.822 31,418.951 ↓ 1.0 864,786 6 / 6

Append (cost=0..547,864.66 rows=864,714 width=30) (actual time=0.123..31,418.951 rows=864,786 loops=6)

  • Buffers: shared hit=2382626 read=475711 dirtied=20 written=6827
154. 7.540 7.540 ↓ 1.0 1,181 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_05 mjl (cost=0..355.18 rows=1,175 width=30) (actual time=0.123..7.54 rows=1,181 loops=6)

  • 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=1535 read=307
155. 1,142.280 1,142.280 ↑ 1.0 46,751 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_06 mjl_1 (cost=0..30,771.47 rows=46,757 width=30) (actual time=0.522..1,142.28 rows=46,751 loops=6)

  • 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=150350 read=30070
156. 1,825.080 1,825.080 ↑ 1.0 55,936 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_07 mjl_2 (cost=0..51,439.21 rows=57,072 width=30) (actual time=0.742..1,825.08 rows=55,936 loops=6)

  • 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=252915 read=50583
157. 2,241.196 2,241.196 ↓ 1.0 56,307 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_08 mjl_3 (cost=0..48,229.72 rows=56,306 width=30) (actual time=0.812..2,241.196 rows=56,307 loops=6)

  • 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=236925 read=47385 written=450
158. 1,175.698 1,175.698 ↓ 1.0 59,542 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_09 mjl_4 (cost=0..26,577.13 rows=59,533 width=30) (actual time=0.391..1,175.698 rows=59,542 loops=6)

  • 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=128420 read=25684
159. 1,076.466 1,076.466 ↓ 1.0 42,110 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_10 mjl_5 (cost=0..24,252.65 rows=42,103 width=30) (actual time=0.478..1,076.466 rows=42,110 loops=6)

  • 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=118105 read=23621
160. 17.817 17.817 ↓ 1.0 4,024 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_11 mjl_6 (cost=0..441.36 rows=4,023 width=30) (actual time=0.461..17.817 rows=4,024 loops=6)

  • 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=1905 read=381
161. 5.184 5.184 ↑ 1.0 3,683 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_12 mjl_7 (cost=0..175.25 rows=3,683 width=30) (actual time=0.452..5.184 rows=3,683 loops=6)

  • 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=600 read=120
162. 1,522.551 1,522.551 ↓ 1.0 54,096 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_13 mjl_8 (cost=0..32,389.74 rows=53,974 width=30) (actual time=0.408..1,522.551 rows=54,096 loops=6)

  • 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=157900 read=31580 written=57
163. 2,650.552 2,650.552 ↑ 1.0 57,830 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_14 mjl_9 (cost=0..34,904.57 rows=58,095 width=30) (actual time=0.462..2,650.552 rows=57,830 loops=6)

  • 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=170165 read=34033 written=886
164. 1,719.812 1,719.812 ↓ 1.0 57,038 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_15 mjl_10 (cost=0..39,212.39 rows=56,217 width=30) (actual time=0.485..1,719.812 rows=57,038 loops=6)

  • 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=191845 read=38369
165. 1,336.260 1,336.260 ↓ 1.0 57,739 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_16 mjl_11 (cost=0..22,728.08 rows=57,729 width=30) (actual time=1.119..1,336.26 rows=57,739 loops=6)

  • 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=109310 read=21862 written=2747
166. 147.844 782.831 ↑ 1.0 44,913 6 / 6

Bitmap Heap Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_17 mjl_12 (cost=5,253.25..35,039.81 rows=45,314 width=30) (actual time=636.392..782.831 rows=44,913 loops=6)

  • Heap Blocks: exact=5938
  • Buffers: shared hit=51305 read=10260
167. 634.987 634.987 ↑ 1.0 45,035 6 / 6

Bitmap Index Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_17_pkey (cost=0..5,241.93 rows=45,314 width=0) (actual time=634.987..634.987 rows=45,035 loops=6)

  • Index Cond: ((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=21615 read=4322
168. 14.050 14.050 ↓ 1.0 3,886 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_18 mjl_13 (cost=0..435.29 rows=3,885 width=30) (actual time=0.404..14.05 rows=3,886 loops=6)

  • 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=1885 read=377
169. 12.537 12.537 ↑ 1.0 3,557 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_19 mjl_14 (cost=0..321.36 rows=3,557 width=30) (actual time=0.746..12.537 rows=3,557 loops=6)

  • 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=1340 read=268
170. 125.058 125.058 ↓ 1.0 10,784 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_20 mjl_15 (cost=0..3,251.76 rows=10,783 width=30) (actual time=0.664..125.058 rows=10,784 loops=6)

  • 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=15450 read=3090
171. 1,537.690 1,537.690 ↑ 1.0 63,209 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_21 mjl_16 (cost=0..31,785.69 rows=63,368 width=30) (actual time=1.086..1,537.69 rows=63,209 loops=6)

  • 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=154175 read=30835 written=1080
172. 2,009.528 2,009.528 ↓ 1.0 65,174 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_22 mjl_17 (cost=0..30,704.61 rows=65,164 width=30) (actual time=0.727..2,009.528 rows=65,174 loops=6)

  • 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=148635 read=29727 written=1607
173. 473.415 1,808.289 ↑ 1.0 59,504 6 / 6

Bitmap Heap Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_23 mjl_18 (cost=7,926.06..46,592.88 rows=59,566 width=30) (actual time=1,337.928..1,808.289 rows=59,504 loops=6)

  • Heap Blocks: exact=7316
  • Buffers: shared hit=69570 read=13913
174. 1,334.874 1,334.874 ↓ 1.0 59,994 6 / 6

Bitmap Index Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_23_pkey (cost=0..7,911.17 rows=59,566 width=0) (actual time=1,334.873..1,334.874 rows=59,994 loops=6)

  • Index Cond: ((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=32990 read=6597
175. 6,418.350 6,418.350 ↓ 1.0 48,925 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_24 mjl_19 (cost=0..37,464.82 rows=48,513 width=30) (actual time=0.941..6,418.35 rows=48,925 loops=6)

  • 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=183685 read=36737
176. 63.144 63.144 ↓ 1.0 4,665 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_25 mjl_20 (cost=0..1,337.97 rows=4,664 width=30) (actual time=1.01..63.144 rows=4,665 loops=6)

  • 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=6340 read=1268
177. 76.023 76.023 ↑ 1.0 4,375 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_26 mjl_21 (cost=0..386.62 rows=4,375 width=30) (actual time=0.645..76.023 rows=4,375 loops=6)

  • 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=1605 read=321
178. 2,986.214 2,986.214 ↓ 1.0 55,871 6 / 6

Seq Scan on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_27 mjl_22 (cost=0..38,690.83 rows=55,113 width=30) (actual time=0.868..2,986.214 rows=55,871 loops=6)

  • 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=189320 read=37864
179. 769.979 769.979 ↑ 1.0 3,686 6 / 6

Index Scan using ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_28_pkey on ms_mcu_joins_and_leaves_sfb_cdr_p2020_01_28 mjl_23 (cost=0.41..10,376.26 rows=3,745 width=30) (actual time=0.793..769.979 rows=3,686 loops=6)

  • Index Cond: ((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=39341 read=7056 dirtied=20
180.          

CTE sessions_united

181. 380.842 244,391.877 ↓ 389.0 3,169,612 1

Append (cost=0..170,476.02 rows=8,149 width=4,931) (actual time=54,525.896..244,391.877 rows=3,169,612 loops=1)

  • Buffers: shared hit=15937763 read=2210956 dirtied=23 written=7669, temp read=138664 written=204203
182. 59,649.830 59,649.830 ↓ 200.6 1,634,330 1

CTE Scan on session_details sd__22 (cost=0..36,665.24 rows=8,148 width=4,931) (actual time=54,525.895..59,649.83 rows=1,634,330 loops=1)

  • Filter: (rn = 1)
  • Buffers: shared hit=41 read=818731 written=825, temp read=32652 written=61143
183. 2,054.981 184,361.205 ↓ 1,535,282.0 1,535,282 1

Nested Loop (cost=89,858.24..133,729.29 rows=1 width=5,426) (actual time=154,697.508..184,361.205 rows=1,535,282 loops=1)

  • Buffers: shared hit=15937722 read=1392225 dirtied=23 written=6844, temp read=106012 written=143060
184. 901.677 170,023.968 ↓ 1,535,282.0 1,535,282 1

Nested Loop (cost=89,857.81..133,728.85 rows=1 width=3,289) (actual time=154,696.445..170,023.968 rows=1,535,282 loops=1)

  • Buffers: shared hit=9945546 read=1385356 dirtied=23 written=6836, temp read=106012 written=143060
185. 1,860.243 161,445.881 ↓ 1,535,282.0 1,535,282 1

Hash Join (cost=89,857.38..133,727.56 rows=1 width=3,240) (actual time=154,695.188..161,445.881 rows=1,535,282 loops=1)

  • Buffers: shared hit=3809246 read=1379009 dirtied=23 written=6827, temp read=106012 written=143060
186. 152,992.784 152,992.784 ↓ 181.6 1,594,460 1

CTE Scan on conference_session_details csd__22 (cost=0..39,503.11 rows=8,778 width=3,206) (actual time=148,102.184..152,992.784 rows=1,594,460 loops=1)

  • Filter: (rn = 1)
  • Buffers: shared hit=3809239 read=1328641 dirtied=23 written=6827, temp read=106012 written=143060
187. 53.409 6,592.854 ↓ 1.0 97,258 1

Hash (cost=87,912.52..87,912.52 rows=97,243 width=75) (actual time=6,592.854..6,592.854 rows=97,258 loops=1)

  • Buffers: shared hit=7 read=50368
188. 10.844 6,539.445 ↓ 1.0 97,258 1

Append (cost=2,234.1..87,912.52 rows=97,243 width=75) (actual time=202.421..6,539.445 rows=97,258 loops=1)

  • Buffers: shared hit=7 read=50368
189. 33.868 235.612 ↓ 1.0 5,326 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_06 c (cost=2,234.1..6,410.15 rows=5,325 width=75) (actual time=202.419..235.612 rows=5,326 loops=1)

  • Heap Blocks: exact=2052
  • Buffers: shared read=4022
190. 201.744 201.744 ↓ 1.0 5,326 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_06_pkey (cost=0..2,232.77 rows=5,325 width=0) (actual time=201.744..201.744 rows=5,326 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1970
191. 38.861 339.136 ↓ 1.0 5,923 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_07 c_1 (cost=3,039.92..8,231.98 rows=5,922 width=75) (actual time=300.963..339.136 rows=5,923 loops=1)

  • Heap Blocks: exact=2760
  • Buffers: shared hit=1 read=5052
192. 300.275 300.275 ↓ 1.0 5,923 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_07_pkey (cost=0..3,038.44 rows=5,922 width=0) (actual time=300.275..300.275 rows=5,923 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2292
193. 37.063 186.221 ↓ 1.0 6,062 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_08 c_2 (cost=1,383.64..6,183.14 rows=6,061 width=75) (actual time=149.85..186.221 rows=6,062 loops=1)

  • Heap Blocks: exact=2445
  • Buffers: shared read=3639
194. 149.158 149.158 ↓ 1.0 6,062 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_08_pkey (cost=0..1,382.13 rows=6,061 width=0) (actual time=149.158..149.158 rows=6,062 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=1194
195. 148.627 201.517 ↓ 1.0 6,174 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_09 c_3 (cost=633.49..5,498.51 rows=6,173 width=75) (actual time=53.569..201.517 rows=6,174 loops=1)

  • Heap Blocks: exact=2412
  • Buffers: shared hit=1 read=2926
196. 52.890 52.890 ↓ 1.0 6,176 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_09_pkey (cost=0..631.95 rows=6,173 width=0) (actual time=52.89..52.89 rows=6,176 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=514
197. 339.175 362.029 ↓ 1.0 5,096 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_10 c_4 (cost=444.24..4,372.05 rows=5,095 width=75) (actual time=23.445..362.029 rows=5,096 loops=1)

  • Heap Blocks: exact=2043
  • Buffers: shared read=2397
198. 22.854 22.854 ↓ 1.0 5,097 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_10_pkey (cost=0..442.97 rows=5,095 width=0) (actual time=22.854..22.854 rows=5,097 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=354
199. 21.694 21.694 ↑ 1.0 1,147 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_11 c_5 (cost=0..212.2 rows=1,147 width=75) (actual time=4.41..21.694 rows=1,147 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=195
200. 3.715 3.715 ↑ 1.0 927 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_12 c_6 (cost=0..55.91 rows=927 width=75) (actual time=1.215..3.715 rows=927 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=42
201. 385.837 420.391 ↓ 1.0 5,864 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_13 c_7 (cost=607.21..4,803.91 rows=5,863 width=75) (actual time=35.223..420.391 rows=5,864 loops=1)

  • Heap Blocks: exact=1906
  • Buffers: shared read=2400
202. 34.554 34.554 ↓ 1.0 5,870 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_13_pkey (cost=0..605.75 rows=5,863 width=0) (actual time=34.554..34.554 rows=5,870 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=494
203. 269.034 624.693 ↓ 1.0 6,256 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_14 c_8 (cost=3,093.93..7,833.19 rows=6,255 width=75) (actual time=356.423..624.693 rows=6,256 loops=1)

  • Heap Blocks: exact=2510
  • Buffers: shared hit=1 read=4865
204. 355.659 355.659 ↓ 1.0 6,256 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_14_pkey (cost=0..3,092.37 rows=6,255 width=0) (actual time=355.659..355.659 rows=6,256 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=2355
205. 471.987 543.765 ↓ 1.0 6,077 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_15 c_9 (cost=953.7..6,076.25 rows=6,076 width=75) (actual time=72.564..543.765 rows=6,077 loops=1)

  • Heap Blocks: exact=2618
  • Buffers: shared hit=1 read=3422
206. 71.778 71.778 ↓ 1.0 6,077 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_15_pkey (cost=0..952.18 rows=6,076 width=0) (actual time=71.778..71.778 rows=6,077 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=804
207. 579.814 637.712 ↓ 1.0 6,405 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_16 c_10 (cost=706.26..5,760.73 rows=6,404 width=75) (actual time=58.606..637.712 rows=6,405 loops=1)

  • Heap Blocks: exact=2553
  • Buffers: shared hit=1 read=3130
208. 57.898 57.898 ↓ 1.0 6,407 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_16_pkey (cost=0..704.66 rows=6,404 width=0) (actual time=57.898..57.898 rows=6,407 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=577
209. 397.693 586.454 ↓ 1.0 5,202 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_17 c_11 (cost=492.63..4,112.14 rows=5,201 width=75) (actual time=189.237..586.454 rows=5,202 loops=1)

  • Heap Blocks: exact=1831
  • Buffers: shared read=2227
210. 188.761 188.761 ↓ 1.0 5,205 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_17_pkey (cost=0..491.33 rows=5,201 width=0) (actual time=188.761..188.761 rows=5,205 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=396
211. 4.061 4.061 ↑ 1.0 1,121 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_18 c_12 (cost=0..128.81 rows=1,121 width=75) (actual time=0.41..4.061 rows=1,121 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=112
212. 2.578 2.578 ↑ 1.0 917 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_19 c_13 (cost=0..68.75 rows=917 width=75) (actual time=0.662..2.578 rows=917 loops=1)

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

Seq Scan on ms_conferences_sfb_cdr_p2020_01_20 c_14 (cost=0..673.53 rows=1,902 width=75) (actual time=0.641..20.094 rows=1,902 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=645
214. 341.456 397.108 ↓ 1.0 6,586 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_21 c_15 (cost=800.51..5,416.08 rows=6,585 width=75) (actual time=57.018..397.108 rows=6,586 loops=1)

  • Heap Blocks: exact=2501
  • Buffers: shared read=3163
215. 55.652 55.652 ↓ 1.0 6,586 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_21_pkey (cost=0..798.87 rows=6,585 width=0) (actual time=55.652..55.652 rows=6,586 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=662
216. 358.144 388.862 ↓ 1.0 6,510 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_22 c_16 (cost=547.83..5,328.53 rows=6,509 width=75) (actual time=31.654..388.862 rows=6,510 loops=1)

  • Heap Blocks: exact=2512
  • Buffers: shared hit=1 read=2945
217. 30.718 30.718 ↓ 1.0 6,510 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_22_pkey (cost=0..546.21 rows=6,509 width=0) (actual time=30.718..30.718 rows=6,510 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=433
218. 338.365 771.361 ↓ 1.0 6,282 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_23 c_17 (cost=679.7..5,222.14 rows=6,281 width=75) (actual time=434.005..771.361 rows=6,282 loops=1)

  • Heap Blocks: exact=2198
  • Buffers: shared read=2754
219. 432.996 432.996 ↓ 1.0 6,282 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_23_pkey (cost=0..678.13 rows=6,281 width=0) (actual time=432.996..432.996 rows=6,282 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=556
220. 351.259 387.494 ↓ 1.0 5,412 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_24 c_18 (cost=566.28..5,079.87 rows=5,411 width=75) (actual time=37.197..387.494 rows=5,412 loops=1)

  • Heap Blocks: exact=2220
  • Buffers: shared hit=1 read=2680
221. 36.235 36.235 ↓ 1.0 5,417 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_24_pkey (cost=0..564.93 rows=5,411 width=0) (actual time=36.235..36.235 rows=5,417 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=460
222. 13.660 13.660 ↑ 1.0 1,123 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_25 c_19 (cost=0..409.85 rows=1,123 width=75) (actual time=0.656..13.66 rows=1,123 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=393
223. 3.052 3.052 ↑ 1.0 942 1

Seq Scan on ms_conferences_sfb_cdr_p2020_01_26 c_20 (cost=0..99.13 rows=942 width=75) (actual time=0.671..3.052 rows=942 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=85
224. 291.000 377.392 ↓ 1.0 6,004 1

Bitmap Heap Scan on ms_conferences_sfb_cdr_p2020_01_27 c_21 (cost=1,048.65..5,935.68 rows=6,003 width=75) (actual time=87.264..377.392 rows=6,004 loops=1)

  • Heap Blocks: exact=2327
  • Buffers: shared read=3219
225. 86.392 86.392 ↓ 1.0 6,004 1

Bitmap Index Scan on ms_conferences_sfb_cdr_p2020_01_27_pkey (cost=0..1,047.15 rows=6,003 width=0) (actual time=86.392..86.392 rows=6,004 loops=1)

  • Index Cond: ((session_id_time >= '2020-01-06 00:00:01'::timestamp without time zone) AND (session_id_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared read=892
226. 7,676.410 7,676.410 ↑ 1.0 1 1,535,282

Index Scan using ms_users_sfb_cdr_pkey on ms_users_sfb_cdr u (cost=0.43..1.29 rows=1 width=57) (actual time=0.005..0.005 rows=1 loops=1,535,282)

  • Index Cond: ((ms_source_id = c.ms_source_id) AND (user_id = c.organizer_id))
  • Buffers: shared hit=6136300 read=6347 written=9
227. 12,282.256 12,282.256 ↑ 1.0 1 1,535,282

Index Scan using ad_users_pkey on ad_users uad (cost=0.42..0.45 rows=1 width=57) (actual time=0.008..0.008 rows=1 loops=1,535,282)

  • Index Cond: (lower((u.email)::text) = (email_new)::text)
  • Buffers: shared hit=5992176 read=6869 written=8
228.          

CTE session_details_with_media_line

229. 12,402.456 512,079.647 ↑ 20.2 3,839,647 1

WindowAgg (cost=686,655,931.06..738,970,732.06 rows=77,647,200 width=5,769) (actual time=498,508.578..512,079.647 rows=3,839,647 loops=1)

  • Buffers: shared hit=246997636 read=2660066 dirtied=23 written=8001, temp read=910257 written=931049
230. 6,517.474 499,677.191 ↑ 20.2 3,839,647 1

Sort (cost=686,655,931.06..686,850,049.06 rows=77,647,200 width=5,153) (actual time=498,508.531..499,677.191 rows=3,839,647 loops=1)

  • Sort Key: sd.ms_source_id, sd.conf_session_id_time, sd.conf_session_id_seq
  • Sort Method: external merge Disk: 1411584kB
  • Buffers: shared hit=246997636 read=2660066 dirtied=23 written=8001, temp read=793226 written=871698
231. 4,977.678 493,159.717 ↑ 20.2 3,839,647 1

WindowAgg (cost=372,545,904.49..374,292,966.49 rows=77,647,200 width=5,153) (actual time=485,975.027..493,159.717 rows=3,839,647 loops=1)

  • Buffers: shared hit=246997636 read=2660066 dirtied=23 written=8001, temp read=616778 written=695166
232. 8,854.154 488,182.039 ↑ 20.2 3,839,647 1

Sort (cost=372,545,904.49..372,740,022.49 rows=77,647,200 width=5,121) (actual time=485,975.002..488,182.039 rows=3,839,647 loops=1)

  • Sort Key: sd.ms_source_id, sd.session_id_time, sd.session_id_seq
  • Sort Method: external merge Disk: 1304648kB
  • Buffers: shared hit=246997636 read=2660066 dirtied=23 written=8001, temp read=616778 written=695166
233. 9,404.539 479,327.885 ↑ 20.2 3,839,647 1

Hash Join (cost=31,578,526.63..62,048,290.27 rows=77,647,200 width=5,121) (actual time=468,009.816..479,327.885 rows=3,839,647 loops=1)

  • Buffers: shared hit=246997636 read=2660066 dirtied=23 written=8001, temp read=453697 written=532009
234. 276.398 6,044.734 ↓ 1.0 1,917,020 1

Append (cost=0..95,310.3 rows=1,916,644 width=80) (actual time=0.802..6,044.734 rows=1,917,020 loops=1)

  • Buffers: shared read=66555
235. 64.652 64.652 ↓ 1.0 5,990 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_05 ml_in (cost=0..277.85 rows=5,989 width=79) (actual time=0.801..64.652 rows=5,990 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=188
236. 1,266.729 1,266.729 ↓ 1.0 98,209 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_06 ml_in_1 (cost=0..4,878.14 rows=98,190 width=80) (actual time=0.419..1,266.729 rows=98,209 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=3405
237. 1,132.686 1,132.686 ↓ 1.0 115,303 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_07 ml_in_2 (cost=0..5,863.55 rows=115,280 width=80) (actual time=0.376..1,132.686 rows=115,303 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4134
238. 651.483 651.483 ↓ 1.0 116,462 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_08 ml_in_3 (cost=0..5,959.93 rows=116,439 width=80) (actual time=0.312..651.483 rows=116,462 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4213
239. 515.330 515.330 ↓ 1.0 127,178 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_09 ml_in_4 (cost=0..6,322.67 rows=127,153 width=80) (actual time=0.826..515.33 rows=127,178 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4415
240. 351.594 351.594 ↓ 1.0 87,671 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_10 ml_in_5 (cost=0..4,330.07 rows=87,654 width=80) (actual time=0.577..351.594 rows=87,671 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=3015
241. 24.567 24.567 ↓ 1.0 7,108 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_11 ml_in_6 (cost=0..328.62 rows=7,107 width=80) (actual time=5.324..24.567 rows=7,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 read=222
242. 8.261 8.261 ↓ 1.0 6,495 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_12 ml_in_7 (cost=0..301.43 rows=6,494 width=80) (actual time=0.439..8.261 rows=6,495 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=204
243. 247.785 247.785 ↓ 1.0 112,118 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_13 ml_in_8 (cost=0..5,583.77 rows=112,096 width=80) (actual time=0.472..247.785 rows=112,118 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=3902
244. 147.337 147.337 ↓ 1.0 121,058 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_14 ml_in_9 (cost=0..6,001.87 rows=121,034 width=80) (actual time=0.436..147.337 rows=121,058 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4186
245. 146.533 146.533 ↓ 1.0 118,942 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_15 ml_in_10 (cost=0..5,928.13 rows=118,919 width=80) (actual time=0.638..146.533 rows=118,942 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4144
246. 144.564 144.564 ↓ 1.0 120,754 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_16 ml_in_11 (cost=0..6,011.31 rows=120,730 width=80) (actual time=0.472..144.564 rows=120,754 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4200
247. 112.829 112.829 ↓ 1.0 93,274 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_17 ml_in_12 (cost=0..4,617.11 rows=93,256 width=80) (actual time=0.459..112.829 rows=93,274 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=3218
248. 8.921 8.921 ↓ 1.0 6,993 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_18 ml_in_13 (cost=0..326.89 rows=6,992 width=80) (actual time=0.437..8.921 rows=6,993 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=222
249. 7.125 7.125 ↓ 1.0 6,051 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_19 ml_in_14 (cost=0..280.76 rows=6,050 width=80) (actual time=0.881..7.125 rows=6,051 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=190
250. 21.558 21.558 ↓ 1.0 19,222 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_20 ml_in_15 (cost=0..922.33 rows=19,218 width=80) (actual time=0.46..21.558 rows=19,222 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=634
251. 153.659 153.659 ↓ 1.0 127,688 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_21 ml_in_16 (cost=0..6,349.32 rows=127,663 width=80) (actual time=0.732..153.659 rows=127,688 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4434
252. 169.257 169.257 ↓ 1.0 136,598 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_22 ml_in_17 (cost=0..6,786.97 rows=136,571 width=80) (actual time=1.153..169.257 rows=136,598 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4738
253. 152.523 152.523 ↓ 1.0 126,749 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_23 ml_in_18 (cost=0..6,315.23 rows=126,724 width=80) (actual time=0.696..152.523 rows=126,749 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4414
254. 123.861 123.861 ↓ 1.0 101,209 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_24 ml_in_19 (cost=0..4,999.14 rows=101,189 width=80) (actual time=0.916..123.861 rows=101,209 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=3481
255. 10.433 10.433 ↓ 1.0 7,852 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_25 ml_in_20 (cost=0..368.78 rows=7,850 width=80) (actual time=0.791..10.433 rows=7,852 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=251
256. 9.152 9.152 ↓ 1.0 7,879 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_26 ml_in_21 (cost=0..369.19 rows=7,877 width=80) (actual time=0.99..9.152 rows=7,879 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=251
257. 139.954 139.954 ↓ 1.0 114,310 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_27 ml_in_22 (cost=0..5,681.65 rows=114,288 width=80) (actual time=0.985..139.954 rows=114,310 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=3967
258. 157.543 157.543 ↓ 1.0 131,907 1

Seq Scan on ms_media_line_sfb_qoe_p2020_01_28 ml_in_23 (cost=0..6,505.6 rows=131,881 width=80) (actual time=0.922..157.543 rows=131,907 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=4527
259. 4,366.820 463,878.612 ↑ 14.8 3,169,612 1

Hash (cost=1,558,733.32..1,558,733.32 rows=47,009,218 width=5,057) (actual time=463,878.612..463,878.612 rows=3,169,612 loops=1)

  • Buffers: shared hit=246997636 read=2593511 dirtied=23 written=8001, temp read=295622 written=464886
260. 3,240.134 459,511.792 ↑ 14.8 3,169,612 1

Merge Join (cost=498,039.7..1,558,733.32 rows=47,009,218 width=5,057) (actual time=443,868.779..459,511.792 rows=3,169,612 loops=1)

  • Buffers: shared hit=246997636 read=2593511 dirtied=23 written=8001, temp read=295622 written=439468
261. 25,034.664 442,531.482 ↓ 389.0 3,169,612 1

Sort (cost=293,369.74..293,390.11 rows=8,149 width=5,045) (actual time=432,044.055..442,531.482 rows=3,169,612 loops=1)

  • Sort Key: (md5((d1.external_id)::text)), d1.ms_source_id
  • Sort Method: external merge Disk: 1048816kB
  • Buffers: shared hit=246997636 read=2568517 dirtied=23 written=8001, temp read=269766 written=413599
262. 6,716.425 417,496.818 ↓ 389.0 3,169,612 1

Nested Loop (cost=0.41..282,496.06 rows=8,149 width=5,045) (actual time=54,527.25..417,496.818 rows=3,169,612 loops=1)

  • Buffers: shared hit=246997636 read=2568517 dirtied=23 written=8001, temp read=138664 written=282427
263. 249,130.181 249,130.181 ↓ 389.0 3,169,612 1

CTE Scan on sessions_united sd (cost=0..162.98 rows=8,149 width=4,919) (actual time=54,525.899..249,130.181 rows=3,169,612 loops=1)

  • Buffers: shared hit=15937763 read=2210956 dirtied=23 written=7669, temp read=138664 written=282427
264. 15,848.060 161,650.212 ↑ 24.0 1 3,169,612

Append (cost=0.41..34.41 rows=24 width=138) (actual time=0.031..0.051 rows=1 loops=3,169,612)

  • Buffers: shared hit=231059873 read=357561 written=332
265. 3,169.612 3,169.612 ↓ 0.0 0 3,169,612

Index Scan using ms_dialogs_sfb_cdr_p2020_01_05_pkey on ms_dialogs_sfb_cdr_p2020_01_05 d1 (cost=0.41..0.72 rows=1 width=151) (actual time=0.001..0.001 rows=0 loops=3,169,612)

  • 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=9508833 read=3
266. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.77 rows=1 width=141) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9698041 read=20012
267. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.79 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9693124 read=20889
268. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.7 rows=1 width=138) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9698121 read=20029
269. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.74 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9699208 read=20476
270. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.59 rows=1 width=139) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9658581 read=17800
271. 3,169.612 3,169.612 ↓ 0.0 0 3,169,612

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.89 rows=1 width=151) (actual time=0.001..0.001 rows=0 loops=3,169,612)

  • 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=9524812 read=4766
272. 3,169.612 3,169.612 ↓ 0.0 0 3,169,612

Index Scan using ms_dialogs_sfb_cdr_p2020_01_12_pkey on ms_dialogs_sfb_cdr_p2020_01_12 d1_7 (cost=0.41..0.75 rows=1 width=149) (actual time=0.001..0.001 rows=0 loops=3,169,612)

  • 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=9520686 read=3726
273. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.65 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9688547 read=20143
274. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.78 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9696867 read=22941
275. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.78 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9691336 read=21754
276. 12,678.448 12,678.448 ↓ 0.0 0 3,169,612

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.71 rows=1 width=137) (actual time=0.004..0.004 rows=0 loops=3,169,612)

  • 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=9694306 read=22047
277. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.6 rows=1 width=138) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9659785 read=19872 written=332
278. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.82 rows=1 width=148) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9527771 read=4919
279. 3,169.612 3,169.612 ↓ 0.0 0 3,169,612

Index Scan using ms_dialogs_sfb_cdr_p2020_01_19_pkey on ms_dialogs_sfb_cdr_p2020_01_19 d1_14 (cost=0.41..0.73 rows=1 width=147) (actual time=0.001..0.001 rows=0 loops=3,169,612)

  • 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=9521175 read=3696
280. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.2 rows=1 width=143) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9553915 read=9331
281. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.74 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9707242 read=23967
282. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.75 rows=1 width=136) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9707591 read=24530
283. 12,678.448 12,678.448 ↓ 0.0 0 3,169,612

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.77 rows=1 width=136) (actual time=0.004..0.004 rows=0 loops=3,169,612)

  • 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=9698386 read=24055
284. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.68 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9668101 read=21129
285. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

Index Scan using ms_dialogs_sfb_cdr_p2020_01_25_pkey on ms_dialogs_sfb_cdr_p2020_01_25 d1_20 (cost=0.42..1.02 rows=1 width=146) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9525050 read=5178
286. 3,169.612 3,169.612 ↓ 0.0 0 3,169,612

Index Scan using ms_dialogs_sfb_cdr_p2020_01_26_pkey on ms_dialogs_sfb_cdr_p2020_01_26 d1_21 (cost=0.41..0.75 rows=1 width=146) (actual time=0.001..0.001 rows=0 loops=3,169,612)

  • 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=9522977 read=4194
287. 6,339.224 6,339.224 ↓ 0.0 0 3,169,612

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.69 rows=1 width=137) (actual time=0.002..0.002 rows=0 loops=3,169,612)

  • 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=9686585 read=22101
288. 3,169.612 3,169.612 ↓ 0.0 0 3,169,612

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.79 rows=1 width=137) (actual time=0.001..0.001 rows=0 loops=3,169,612)

  • 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=9508833 read=3
289. 167.045 13,740.176 ↓ 1.0 1,153,971 1

Materialize (cost=204,669.96..210,438.67 rows=1,153,742 width=135) (actual time=11,824.699..13,740.176 rows=1,153,971 loops=1)

  • Buffers: shared read=24994, temp read=25856 written=25869
290. 6,499.176 13,573.131 ↓ 1.0 1,153,971 1

Sort (cost=204,669.96..207,554.31 rows=1,153,742 width=135) (actual time=11,824.695..13,573.131 rows=1,153,971 loops=1)

  • Sort Key: (md5((d.dialog_id)::text)), d.ms_source_id
  • Sort Method: external merge Disk: 206848kB
  • Buffers: shared read=24994, temp read=25856 written=25869
291. 647.033 7,073.955 ↓ 1.0 1,153,971 1

Result (cost=0..42,303.57 rows=1,153,742 width=135) (actual time=81.227..7,073.955 rows=1,153,971 loops=1)

  • Buffers: shared read=24994
292. 118.767 6,426.922 ↓ 1.0 1,153,971 1

Append (cost=0..42,303.57 rows=1,153,742 width=135) (actual time=81.22..6,426.922 rows=1,153,971 loops=1)

  • Buffers: shared read=24994
293. 409.600 409.600 ↓ 1.0 5,582 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_05 d (cost=0..207.73 rows=5,581 width=140) (actual time=81.219..409.6 rows=5,582 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=124
294. 953.608 953.608 ↓ 1.0 59,329 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_06 d_1 (cost=0..2,173.93 rows=59,317 width=136) (actual time=37.415..953.608 rows=59,329 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1284
295. 1,144.197 1,144.197 ↓ 1.0 69,472 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_07 d_2 (cost=0..2,595.08 rows=69,458 width=135) (actual time=24.803..1,144.197 rows=69,472 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1553
296. 1,000.630 1,000.630 ↓ 1.0 69,811 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_08 d_3 (cost=0..2,611.16 rows=69,797 width=135) (actual time=46.837..1,000.63 rows=69,811 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1564
297. 1,765.047 1,765.047 ↓ 1.0 73,665 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_09 d_4 (cost=0..2,688.97 rows=73,650 width=135) (actual time=32.73..1,765.047 rows=73,665 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1584
298. 600.378 600.378 ↓ 1.0 55,759 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_10 d_5 (cost=0..2,043.38 rows=55,748 width=136) (actual time=61.472..600.378 rows=55,759 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1207
299. 5.683 5.683 ↓ 1.0 6,274 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_11 d_6 (cost=0..233.11 rows=6,273 width=139) (actual time=1.806..5.683 rows=6,274 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=139
300. 3.618 3.618 ↓ 1.0 5,887 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_12 d_7 (cost=0..218.31 rows=5,886 width=138) (actual time=0.669..3.618 rows=5,887 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=130
301. 53.731 53.731 ↓ 1.0 65,363 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_13 d_8 (cost=0..2,388.44 rows=65,350 width=135) (actual time=1.109..53.731 rows=65,363 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1408
302. 32.802 32.802 ↓ 1.0 71,491 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_14 d_9 (cost=0..2,611.36 rows=71,477 width=135) (actual time=0.367..32.802 rows=71,491 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1539
303. 70.091 70.091 ↓ 1.0 69,308 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_15 d_10 (cost=0..2,529.62 rows=69,294 width=135) (actual time=0.451..70.091 rows=69,308 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1490
304. 32.874 32.874 ↓ 1.0 70,372 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_16 d_11 (cost=0..2,569.58 rows=70,358 width=135) (actual time=0.592..32.874 rows=70,372 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1514
305. 21.336 21.336 ↓ 1.0 57,799 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_17 d_12 (cost=0..2,113.99 rows=57,787 width=135) (actual time=0.427..21.336 rows=57,799 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1247
306. 3.496 3.496 ↓ 1.0 6,212 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_18 d_13 (cost=0..230.18 rows=6,211 width=139) (actual time=0.413..3.496 rows=6,212 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=137
307. 2.922 2.922 ↓ 1.0 5,644 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_19 d_14 (cost=0..209.66 rows=5,643 width=139) (actual time=0.66..2.922 rows=5,644 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=125
308. 9.036 9.036 ↓ 1.0 15,000 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_20 d_15 (cost=0..555 rows=14,997 width=139) (actual time=0.839..9.036 rows=15,000 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=330
309. 36.916 36.916 ↓ 1.0 74,351 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_21 d_16 (cost=0..2,713.26 rows=74,336 width=134) (actual time=0.993..36.916 rows=74,351 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1598
310. 34.601 34.601 ↓ 1.0 79,286 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_22 d_17 (cost=0..2,893.29 rows=79,270 width=134) (actual time=0.757..34.601 rows=79,286 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1704
311. 28.213 28.213 ↓ 1.0 73,834 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_23 d_18 (cost=0..2,693.51 rows=73,819 width=134) (actual time=0.643..28.213 rows=73,834 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1586
312. 26.507 26.507 ↓ 1.0 62,377 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_24 d_19 (cost=0..2,279.65 rows=62,365 width=135) (actual time=0.714..26.507 rows=62,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 read=1344
313. 3.584 3.584 ↓ 1.0 6,973 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_25 d_20 (cost=0..257.6 rows=6,972 width=138) (actual time=0.742..3.584 rows=6,973 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=153
314. 4.028 4.028 ↓ 1.0 6,913 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_26 d_21 (cost=0..254.69 rows=6,912 width=137) (actual time=0.78..4.028 rows=6,913 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=151
315. 32.816 32.816 ↓ 1.0 66,509 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_27 d_22 (cost=0..2,427.64 rows=66,496 width=134) (actual time=0.871..32.816 rows=66,509 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:00'::timestamp without time zone) AND (conference_date_time < '2020-01-29 00:00:00'::timestamp without time zone))
  • Buffers: shared read=1430
316. 32.441 32.441 ↓ 1.0 76,760 1

Seq Scan on ms_dialog_sfb_qoe_p2020_01_28 d_23 (cost=0..2,804.4 rows=76,745 width=135) (actual time=1.072..32.441 rows=76,760 loops=1)

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

CTE user_agent_def

318. 0.027 1.614 ↑ 2.0 42 1

HashAggregate (cost=3.54..4.38 rows=84 width=13) (actual time=1.608..1.614 rows=42 loops=1)

  • Group Key: uad_1.ua_type, uad_1.ua_category, uad_1.ms_source_id
  • Buffers: shared read=2 dirtied=2
319. 1.587 1.587 ↑ 2.0 44 1

Seq Scan on ms_user_agent_def_sfb_cdr uad_1 (cost=0..2.88 rows=88 width=13) (actual time=1.584..1.587 rows=44 loops=1)

  • Buffers: shared read=2 dirtied=2
320.          

CTE user_agent

321. 12.515 22.433 ↑ 1.0 11,457 1

HashAggregate (cost=631.17..749.42 rows=11,825 width=86) (actual time=17.584..22.433 rows=11,457 loops=1)

  • Group Key: ua.user_agent_key, ua.user_agent, ua.ua_type, uad_2.ua_category, ua.ms_source_id
  • Buffers: shared read=185 dirtied=2
322. 5.084 9.918 ↑ 1.0 11,490 1

Hash Join (cost=4.2..483.35 rows=11,825 width=86) (actual time=1.046..9.918 rows=11,490 loops=1)

  • Buffers: shared read=185 dirtied=2
323. 4.372 4.372 ↑ 1.0 11,457 1

Seq Scan on ms_user_agent_sfb_qoe ua (cost=0..301.25 rows=11,825 width=79) (actual time=0.563..4.372 rows=11,457 loops=1)

  • Buffers: shared read=183
324. 0.017 0.462 ↑ 2.0 44 1

Hash (cost=2.88..2.88 rows=88 width=13) (actual time=0.462..0.462 rows=44 loops=1)

  • Buffers: shared read=2 dirtied=2
325. 0.445 0.445 ↑ 2.0 44 1

Seq Scan on ms_user_agent_def_sfb_qoe uad_2 (cost=0..2.88 rows=88 width=13) (actual time=0.436..0.445 rows=44 loops=1)

  • Buffers: shared read=2 dirtied=2
326.          

CTE audio_stream

327. 5,435.504 9,516.352 ↓ 3.9 1,570,150 1

GroupAggregate (cost=276,975.76..338,938.71 rows=397,936 width=217) (actual time=3,743.762..9,516.352 rows=1,570,150 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=5773 read=54678 dirtied=1, temp read=12910 written=12920
328. 1,610.290 4,080.848 ↓ 1.0 1,570,150 1

Sort (cost=276,975.76..280,900.36 rows=1,569,837 width=48) (actual time=3,743.588..4,080.848 rows=1,570,150 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: 103280kB
  • Buffers: shared hit=5730 read=54678 dirtied=1, temp read=12910 written=12920
329. 370.119 2,470.558 ↓ 1.0 1,570,150 1

Hash Join (cost=1.68..87,136.5 rows=1,569,837 width=48) (actual time=1.042..2,470.558 rows=1,570,150 loops=1)

  • Buffers: shared hit=137 read=54673 dirtied=1
330. 149.920 2,100.005 ↓ 1.0 1,570,150 1

Append (cost=0..78,247.25 rows=1,569,837 width=42) (actual time=0.442..2,100.005 rows=1,570,150 loops=1)

  • Buffers: shared hit=23 read=54672
331. 10.371 10.371 ↓ 1.0 9,239 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_05 s (cost=0..380.59 rows=9,237 width=43) (actual time=0.441..10.371 rows=9,239 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=241
332. 115.551 115.551 ↓ 1.0 89,659 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_06 s_1 (cost=0..4,494.89 rows=89,641 width=42) (actual time=0.421..115.551 rows=89,659 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=3149
333. 123.708 123.708 ↓ 1.0 99,922 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_07 s_2 (cost=0..5,153.83 rows=99,902 width=42) (actual time=0.589..123.708 rows=99,922 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=3654
334. 132.899 132.899 ↓ 1.0 102,067 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_08 s_3 (cost=0..5,259.01 rows=102,047 width=42) (actual time=0.409..132.899 rows=102,067 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=3727
335. 119.173 119.173 ↓ 1.0 105,468 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_09 s_4 (cost=0..5,296.02 rows=105,447 width=42) (actual time=0.964..119.173 rows=105,468 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=3713
336. 96.229 96.229 ↓ 1.0 82,912 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_10 s_5 (cost=0..4,127.68 rows=82,896 width=42) (actual time=1.28..96.229 rows=82,912 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=2883
337. 13.963 13.963 ↓ 1.0 10,567 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_11 s_6 (cost=0..443.5 rows=10,565 width=42) (actual time=0.574..13.963 rows=10,567 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=284
338. 9.137 9.137 ↓ 1.0 9,655 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_12 s_7 (cost=0..400.82 rows=9,653 width=42) (actual time=0.391..9.137 rows=9,655 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=255
339. 122.529 122.529 ↓ 1.0 94,619 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_13 s_8 (cost=0..4,747.28 rows=94,600 width=42) (actual time=0.586..122.529 rows=94,619 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=3327
340. 123.376 123.376 ↓ 1.0 103,324 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_14 s_9 (cost=0..5,158.86 rows=103,303 width=42) (actual time=0.477..123.376 rows=103,324 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=3608
341. 120.959 120.959 ↓ 1.0 100,326 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_15 s_10 (cost=0..5,019.89 rows=100,306 width=42) (actual time=0.776..120.959 rows=100,326 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=3514
342. 127.734 127.734 ↓ 1.0 102,176 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_16 s_11 (cost=0..5,116.64 rows=102,156 width=42) (actual time=0.581..127.734 rows=102,176 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=3583
343. 112.015 112.015 ↓ 1.0 85,339 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_17 s_12 (cost=0..4,262.09 rows=85,322 width=42) (actual time=0.45..112.015 rows=85,339 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=2981
344. 10.038 10.038 ↓ 1.0 10,155 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_18 s_13 (cost=0..426.32 rows=10,153 width=42) (actual time=0.583..10.038 rows=10,155 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=273
345. 8.782 8.782 ↓ 1.0 9,384 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_19 s_14 (cost=0..387.76 rows=9,382 width=42) (actual time=0.789..8.782 rows=9,384 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
346. 26.239 26.239 ↓ 1.0 23,496 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_20 s_15 (cost=0..1,073.44 rows=23,491 width=42) (actual time=0.962..26.239 rows=23,496 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=720
347. 156.281 156.281 ↓ 1.0 107,299 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_21 s_16 (cost=0..5,371.48 rows=107,278 width=42) (actual time=0.816..156.281 rows=107,299 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=3761
348. 145.867 145.867 ↓ 1.0 113,426 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_22 s_17 (cost=0..5,678.39 rows=113,403 width=42) (actual time=0.363..145.867 rows=113,426 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=3976
349. 129.389 129.389 ↓ 1.0 105,148 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_23 s_18 (cost=0..5,279.22 rows=105,127 width=42) (actual time=0.383..129.389 rows=105,148 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=3701
350. 111.396 111.396 ↓ 1.0 89,018 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_24 s_19 (cost=0..4,459.27 rows=89,000 width=42) (actual time=0.411..111.396 rows=89,018 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=3123
351. 10.989 10.989 ↓ 1.0 11,226 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_25 s_20 (cost=0..482.39 rows=11,224 width=42) (actual time=0.503..10.989 rows=11,226 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=313
352. 9.803 9.803 ↓ 1.0 10,383 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_26 s_21 (cost=0..438.75 rows=10,381 width=42) (actual time=0.64..9.803 rows=10,383 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=282
353. 113.657 113.657 ↓ 1.0 95,342 1

Seq Scan on ms_audio_stream_sfb_qoe_p2020_01_27 s_22 (cost=0..4,789.13 rows=95,323 width=42) (actual time=1.008..113.657 rows=95,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=3358
354. 0.010 0.434 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=10) (actual time=0.434..0.434 rows=27 loops=1)

  • Buffers: shared read=1 dirtied=1
355. 0.424 0.424 ↑ 1.0 27 1

Seq Scan on ms_payload_description_sfb_qoe pd (cost=0..1.27 rows=27 width=10) (actual time=0.421..0.424 rows=27 loops=1)

  • Buffers: shared read=1 dirtied=1
356.          

CTE video_stream

357. 949.684 2,536.460 ↑ 1.0 302,280 1

GroupAggregate (cost=42,832.77..60,241.47 rows=302,760 width=185) (actual time=1,536.166..2,536.46 rows=302,280 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=27 read=8976, temp read=2293 written=2295
358. 242.618 1,586.776 ↓ 1.0 302,817 1

Sort (cost=42,832.77..43,589.67 rows=302,760 width=40) (actual time=1,536.129..1,586.776 rows=302,817 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: external merge Disk: 18344kB
  • Buffers: shared hit=27 read=8976, temp read=2293 written=2295
359. 71.412 1,344.158 ↓ 1.0 302,817 1

Hash Join (cost=1.68..15,269.78 rows=302,760 width=40) (actual time=47.232..1,344.158 rows=302,817 loops=1)

  • Buffers: shared hit=24 read=8976
360. 29.642 1,272.722 ↓ 1.0 302,817 1

Append (cost=0..13,541.26 rows=302,760 width=34) (actual time=47.19..1,272.722 rows=302,817 loops=1)

  • Buffers: shared hit=23 read=8976
361. 52.328 52.328 ↑ 1.0 410 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_05 s_23 (cost=0..20.15 rows=410 width=35) (actual time=47.189..52.328 rows=410 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
362. 106.336 106.336 ↓ 1.0 16,311 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_06 s_24 (cost=0..727.66 rows=16,308 width=34) (actual time=0.89..106.336 rows=16,311 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=482
363. 57.821 57.821 ↓ 1.0 19,132 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_07 s_25 (cost=0..874.98 rows=19,128 width=34) (actual time=0.345..57.821 rows=19,132 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=587
364. 45.298 45.298 ↓ 1.0 19,504 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_08 s_26 (cost=0..891.56 rows=19,500 width=34) (actual time=1.182..45.298 rows=19,504 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=598
365. 284.391 284.391 ↓ 1.0 21,757 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_09 s_27 (cost=0..969.36 rows=21,753 width=34) (actual time=0.532..284.391 rows=21,757 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=642
366. 122.801 122.801 ↓ 1.0 14,626 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_10 s_28 (cost=0..655.39 rows=14,623 width=34) (actual time=1.069..122.801 rows=14,626 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=435
367. 1.818 1.818 ↑ 1.0 434 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_11 s_29 (cost=0..20.51 rows=434 width=34) (actual time=0.822..1.818 rows=434 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
368. 1.227 1.227 ↑ 1.0 471 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_12 s_30 (cost=0..22.06 rows=471 width=34) (actual time=0.415..1.227 rows=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=14
369. 170.172 170.172 ↓ 1.0 19,720 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_13 s_31 (cost=0..877.8 rows=19,716 width=34) (actual time=0.332..170.172 rows=19,720 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=581
370. 82.966 82.966 ↓ 1.0 21,451 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_14 s_32 (cost=0..952.76 rows=21,447 width=34) (actual time=0.406..82.966 rows=21,451 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=630
371. 36.549 36.549 ↓ 1.0 20,444 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_15 s_33 (cost=0..908.66 rows=20,440 width=34) (actual time=0.502..36.549 rows=20,444 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=601
372. 39.062 39.062 ↓ 1.0 21,447 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_16 s_34 (cost=0..953.7 rows=21,443 width=34) (actual time=0.424..39.062 rows=21,447 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=631
373. 48.519 48.519 ↓ 1.0 16,251 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_17 s_35 (cost=0..723.76 rows=16,248 width=34) (actual time=2.537..48.519 rows=16,251 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=479
374. 1.457 1.457 ↑ 1.0 501 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_18 s_36 (cost=0..23.52 rows=501 width=34) (actual time=0.482..1.457 rows=501 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=15
375. 1.494 1.494 ↑ 1.0 408 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_19 s_37 (cost=0..20.12 rows=408 width=34) (actual time=0.387..1.494 rows=408 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
376. 4.311 4.311 ↑ 1.0 2,471 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_20 s_38 (cost=0..114.06 rows=2,471 width=34) (actual time=0.349..4.311 rows=2,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=76
377. 26.441 26.441 ↓ 1.0 22,788 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_21 s_39 (cost=0..1,011.82 rows=22,784 width=34) (actual time=0.386..26.441 rows=22,788 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=669
378. 27.000 27.000 ↓ 1.0 23,249 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_22 s_40 (cost=0..1,031.74 rows=23,244 width=34) (actual time=0.412..27 rows=23,249 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=682
379. 24.641 24.641 ↓ 1.0 22,698 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_23 s_41 (cost=0..1,012.47 rows=22,694 width=34) (actual time=0.968..24.641 rows=22,698 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=671
380. 20.380 20.380 ↓ 1.0 17,277 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_24 s_42 (cost=0..770.15 rows=17,274 width=34) (actual time=0.571..20.38 rows=17,277 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=510
381. 2.099 2.099 ↑ 1.0 737 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_25 s_43 (cost=0..35.05 rows=737 width=34) (actual time=0.625..2.099 rows=737 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=23
382. 3.163 3.163 ↑ 1.0 900 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_26 s_44 (cost=0..42.5 rows=900 width=34) (actual time=1.195..3.163 rows=900 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=28
383. 82.806 82.806 ↓ 1.0 19,830 1

Seq Scan on ms_video_stream_sfb_qoe_p2020_01_27 s_45 (cost=0..881.45 rows=19,826 width=34) (actual time=9.636..82.806 rows=19,830 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=583
384. 0.009 0.024 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=10) (actual time=0.024..0.024 rows=27 loops=1)

  • Buffers: shared hit=1
385. 0.015 0.015 ↑ 1.0 27 1

Seq Scan on ms_payload_description_sfb_qoe pd_1 (cost=0..1.27 rows=27 width=10) (actual time=0.011..0.015 rows=27 loops=1)

  • Buffers: shared hit=1
386.          

CTE app_sharing_stream

387. 1,496.028 2,620.552 ↓ 1.1 546,193 1

GroupAggregate (cost=84,608.26..114,736.34 rows=499,835 width=162) (actual time=1,023.284..2,620.552 rows=546,193 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=11645, temp read=3824 written=3826
388. 498.089 1,124.524 ↓ 1.0 546,193 1

Sort (cost=84,608.26..85,973.48 rows=546,087 width=44) (actual time=1,023.244..1,124.524 rows=546,193 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: 30592kB
  • Buffers: shared hit=24 read=11645, temp read=3824 written=3826
389. 96.182 626.435 ↓ 1.0 546,193 1

Hash Join (cost=1.68..22,729.53 rows=546,087 width=44) (actual time=0.575..626.435 rows=546,193 loops=1)

  • Buffers: shared hit=24 read=11645
390. 52.764 530.235 ↓ 1.0 546,193 1

Append (cost=0..19,860.9 rows=546,087 width=38) (actual time=0.544..530.235 rows=546,193 loops=1)

  • Buffers: shared hit=23 read=11645
391. 1.845 1.845 ↑ 1.0 1,334 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_05 s_46 (cost=0..45.01 rows=1,334 width=38) (actual time=0.544..1.845 rows=1,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=24
392. 21.918 21.918 ↓ 1.0 27,349 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_06 s_47 (cost=0..1,001.23 rows=27,344 width=38) (actual time=0.566..21.918 rows=27,349 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=590
393. 28.960 28.960 ↓ 1.0 35,746 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_07 s_48 (cost=0..1,310.19 rows=35,739 width=38) (actual time=0.534..28.96 rows=35,746 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=773
394. 31.572 31.572 ↓ 1.0 35,738 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_08 s_49 (cost=0..1,338.07 rows=35,731 width=38) (actual time=0.39..31.572 rows=35,738 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=801
395. 30.684 30.684 ↓ 1.0 39,066 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_09 s_50 (cost=0..1,422.99 rows=39,058 width=38) (actual time=0.492..30.684 rows=39,066 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=836
396. 19.854 19.854 ↓ 1.0 26,758 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_10 s_51 (cost=0..967.37 rows=26,753 width=38) (actual time=0.462..19.854 rows=26,758 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=565
397. 1.824 1.824 ↑ 1.0 1,365 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_11 s_52 (cost=0..46.47 rows=1,365 width=38) (actual time=0.52..1.824 rows=1,365 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=25
398. 2.132 2.132 ↑ 1.0 1,515 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_12 s_53 (cost=0..50.72 rows=1,515 width=38) (actual time=0.418..2.132 rows=1,515 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=27
399. 25.641 25.641 ↓ 1.0 33,982 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_13 s_54 (cost=0..1,233.73 rows=33,975 width=38) (actual time=0.471..25.641 rows=33,982 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=723
400. 30.569 30.569 ↓ 1.0 37,494 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_14 s_55 (cost=0..1,362.41 rows=37,487 width=38) (actual time=0.478..30.569 rows=37,494 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=799
401. 29.622 29.622 ↓ 1.0 36,542 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_15 s_56 (cost=0..1,337.13 rows=36,535 width=38) (actual time=0.56..29.622 rows=36,542 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=788
402. 60.888 60.888 ↓ 1.0 36,606 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_16 s_57 (cost=0..1,333.09 rows=36,599 width=38) (actual time=0.569..60.888 rows=36,606 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=783
403. 23.153 23.153 ↓ 1.0 28,804 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_17 s_58 (cost=0..1,043.06 rows=28,798 width=38) (actual time=0.36..23.153 rows=28,804 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=610
404. 3.086 3.086 ↑ 1.0 1,692 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_18 s_59 (cost=0..60.38 rows=1,692 width=38) (actual time=0.746..3.086 rows=1,692 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=34
405. 2.077 2.077 ↑ 1.0 1,310 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_19 s_60 (cost=0..44.65 rows=1,310 width=38) (actual time=0.754..2.077 rows=1,310 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
406. 4.786 4.786 ↓ 1.0 5,794 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_20 s_61 (cost=0..209.91 rows=5,793 width=38) (actual time=0.687..4.786 rows=5,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=122
407. 32.817 32.817 ↓ 1.0 38,913 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_21 s_62 (cost=0..1,418.69 rows=38,905 width=38) (actual time=0.746..32.817 rows=38,913 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=834
408. 33.412 33.412 ↓ 1.0 42,534 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_22 s_63 (cost=0..1,544.01 rows=42,526 width=38) (actual time=0.78..33.412 rows=42,534 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=905
409. 31.250 31.250 ↓ 1.0 40,324 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_23 s_64 (cost=0..1,469.86 rows=40,316 width=38) (actual time=0.689..31.25 rows=40,324 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-27 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=1 read=864
410. 26.962 26.962 ↓ 1.0 33,247 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_24 s_65 (cost=0..1,178.7 rows=33,240 width=38) (actual time=0.82..26.962 rows=33,247 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=679
411. 2.275 2.275 ↑ 1.0 2,091 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_25 s_66 (cost=0..72.36 rows=2,091 width=38) (actual time=0.668..2.275 rows=2,091 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=40
412. 2.613 2.613 ↓ 1.0 2,803 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_26 s_67 (cost=0..98.05 rows=2,802 width=38) (actual time=0.698..2.613 rows=2,803 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=55
413. 29.531 29.531 ↓ 1.0 35,186 1

Seq Scan on ms_app_sharing_stream_sfb_qoe_p2020_01_27 s_68 (cost=0..1,272.79 rows=35,179 width=38) (actual time=0.616..29.531 rows=35,186 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=744
414. 0.006 0.018 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=10) (actual time=0.018..0.018 rows=27 loops=1)

  • Buffers: shared hit=1
415. 0.012 0.012 ↑ 1.0 27 1

Seq Scan on ms_payload_description_sfb_qoe pd_2 (cost=0..1.27 rows=27 width=10) (actual time=0.008..0.012 rows=27 loops=1)

  • Buffers: shared hit=1
416.          

CTE prepared_dataset

417. 24,658.402 1,003,256.046 ↑ 71.2 3,855,364 1

WindowAgg (cost=5,198,614,232.26..11,864,671,084.82 rows=274,436,264 width=9,495) (actual time=917,480.657..1,003,256.046 rows=3,855,364 loops=1)

  • Buffers: shared hit=331770901 read=3304865 dirtied=36 written=8001, temp read=3969419 written=4001061
418. 72,896.012 943,899.368 ↑ 71.2 3,855,364 1

Sort (cost=5,198,614,232.26..5,199,300,322.92 rows=274,436,264 width=9,443) (actual time=917,480.412..943,899.368 rows=3,855,364 loops=1)

  • Sort Key: sd_ml.ms_source_id, sd_ml.dialog, sd_ml.media_line_label
  • Sort Method: external merge Disk: 6828536kB
  • Buffers: shared hit=331770846 read=3304865 dirtied=36 written=8001, temp read=3964271 written=3998359
419. 7,787.305 871,003.356 ↑ 71.2 3,855,364 1

WindowAgg (cost=3,201,103,265.44..3,208,650,262.7 rows=274,436,264 width=9,443) (actual time=861,317.324..871,003.356 rows=3,855,364 loops=1)

  • Buffers: shared hit=331770846 read=3304865 dirtied=36 written=8001, temp read=1983673 written=2017242
420. 17,470.876 863,216.051 ↑ 71.2 3,855,364 1

Sort (cost=3,201,103,265.44..3,201,789,356.1 rows=274,436,264 width=9,411) (actual time=861,307.861..863,216.051 rows=3,855,364 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: 2590096kB
  • Buffers: shared hit=331765248 read=3304862 dirtied=36 written=8001, temp read=1749645 written=1899340
421. 4,665.395 845,745.175 ↑ 71.2 3,855,364 1

Nested Loop (cost=355,288,549.42..1,217,732,200.44 rows=274,436,264 width=9,411) (actual time=594,381.203..845,745.175 rows=3,855,364 loops=1)

  • Buffers: shared hit=331765248 read=3304862 dirtied=36 written=8001, temp read=1214264 written=1363763
422. 4,836.615 821,802.960 ↑ 37.9 3,855,364 1

Nested Loop (cost=355,288,549.27..1,188,167,832.52 rows=145,976,736 width=9,379) (actual time=594,381.169..821,802.96 rows=3,855,364 loops=1)

  • Buffers: shared hit=328620156 read=3304862 dirtied=36 written=8001, temp read=1214264 written=1363763
423. 2,168.020 797,689.525 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,288,549.12..1,172,442,104.91 rows=77,647,200 width=9,347) (actual time=594,381.089..797,689.525 rows=3,855,364 loops=1)

  • Buffers: shared hit=324930195 read=3304856 dirtied=36 written=8001, temp read=1214264 written=1363763
424. 3,750.951 791,666.141 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,288,548.7..1,137,878,674.01 rows=77,647,200 width=9,333) (actual time=594,379.934..791,666.141 rows=3,855,364 loops=1)

  • Buffers: shared hit=318775248 read=3303786 dirtied=36 written=8001, temp read=1214264 written=1363763
425. 1,718.416 784,059.826 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,288,548.27..1,103,315,243.11 rows=77,647,200 width=9,319) (actual time=594,379.331..784,059.826 rows=3,855,364 loops=1)

  • Buffers: shared hit=312825970 read=3298555 dirtied=36 written=8001, temp read=1214264 written=1363763
426. 2,526.580 778,486.046 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,288,547.85..1,068,751,812.21 rows=77,647,200 width=9,309) (actual time=594,379.323..778,486.046 rows=3,855,364 loops=1)

  • Buffers: shared hit=306841604 read=3298395 dirtied=36 written=8001, temp read=1214264 written=1363763
427. 2,105.568 772,104.102 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,288,547.42..1,034,188,381.31 rows=77,647,200 width=9,299) (actual time=594,378.876..772,104.102 rows=3,855,364 loops=1)

  • Buffers: shared hit=301226545 read=3297053 dirtied=36 written=8001, temp read=1214264 written=1363763
428. 3,330.557 766,143.170 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,288,547..999,624,950.41 rows=77,647,200 width=9,285) (actual time=594,378.864..766,143.17 rows=3,855,364 loops=1)

  • Buffers: shared hit=295243830 read=3296888 dirtied=36 written=8001, temp read=1214264 written=1363763
429. 2,549.290 758,957.249 ↑ 20.1 3,855,364 1

Hash Join (cost=355,288,546.57..965,061,519.51 rows=77,647,200 width=9,271) (actual time=594,375.669..758,957.249 rows=3,855,364 loops=1)

  • Buffers: shared hit=289631097 read=3295792 dirtied=36 written=8001, temp read=1214264 written=1363763
430. 2,608.157 756,401.083 ↑ 20.1 3,855,364 1

Hash Join (cost=355,288,132.7..735,044,649.9 rows=77,647,200 width=8,615) (actual time=594,368.749..756,401.083 rows=3,855,364 loops=1)

  • Buffers: shared hit=289631097 read=3295792 dirtied=36 written=8001, temp read=1214264 written=1363763
431. 2,443.776 753,758.478 ↑ 20.1 3,855,364 1

Hash Join (cost=355,287,718.82..505,122,712.99 rows=77,647,200 width=7,957) (actual time=594,334.265..753,758.478 rows=3,855,364 loops=1)

  • Buffers: shared hit=289631097 read=3295607 dirtied=34 written=8001, temp read=1214264 written=1363763
432. 2,925.198 751,206.530 ↑ 20.1 3,855,364 1

Hash Join (cost=355,275,576.27..504,702,922.63 rows=77,647,200 width=7,945) (actual time=594,225.846..751,206.53 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625506 read=3295607 dirtied=34 written=8001, temp read=1214264 written=1363763
433. 2,505.426 748,034.737 ↑ 20.1 3,855,364 1

Hash Join (cost=355,263,433.72..504,283,132.26 rows=77,647,200 width=7,933) (actual time=593,979.036..748,034.737 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625506 read=3290016 dirtied=28 written=8001, temp read=1214264 written=1363763
434. 2,508.648 745,529.297 ↑ 20.1 3,855,364 1

Hash Join (cost=355,263,421.25..504,074,976.76 rows=77,647,200 width=7,815) (actual time=593,979.016..745,529.297 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625505 read=3290016 dirtied=28 written=8001, temp read=1214264 written=1363763
435. 2,467.914 743,020.337 ↑ 20.1 3,855,364 1

Hash Join (cost=355,263,408.77..503,866,821.26 rows=77,647,200 width=7,697) (actual time=593,978.696..743,020.337 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625505 read=3290015 dirtied=28 written=8001, temp read=1214264 written=1363763
436. 2,788.879 740,552.408 ↑ 20.1 3,855,364 1

Hash Join (cost=355,263,405.83..503,280,806.46 rows=77,647,200 width=7,553) (actual time=593,978.672..740,552.408 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625505 read=3290015 dirtied=28 written=8001, temp read=1214264 written=1363763
437. 2,353.139 737,761.887 ↑ 20.1 3,855,364 1

Hash Join (cost=355,263,402.89..502,694,791.66 rows=77,647,200 width=7,409) (actual time=593,977.015..737,761.887 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625505 read=3290013 dirtied=26 written=8001, temp read=1214264 written=1363763
438. 2,509.858 735,401.402 ↑ 20.1 3,855,364 1

Hash Join (cost=355,262,609.49..502,286,350.25 rows=77,647,200 width=7,368) (actual time=593,969.625..735,401.402 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625280 read=3290013 dirtied=26 written=8001, temp read=1214264 written=1363763
439. 2,380.693 732,884.221 ↑ 20.1 3,855,364 1

Hash Join (cost=355,261,816.09..501,877,908.85 rows=77,647,200 width=7,327) (actual time=593,962.26..732,884.221 rows=3,855,364 loops=1)

  • Buffers: shared hit=289625055 read=3290013 dirtied=26 written=8001, temp read=1214264 written=1363763
440. 2,457.547 730,496.124 ↑ 20.1 3,855,364 1

Hash Join (cost=355,261,022.69..501,469,467.44 rows=77,647,200 width=7,286) (actual time=593,954.807..730,496.124 rows=3,855,364 loops=1)

  • Buffers: shared hit=289624830 read=3290013 dirtied=26 written=8001, temp read=1214264 written=1363763
441. 2,765.964 728,025.124 ↑ 20.1 3,855,364 1

Hash Join (cost=355,260,229.29..501,061,026.03 rows=77,647,200 width=7,245) (actual time=593,941.309..728,025.124 rows=3,855,364 loops=1)

  • Buffers: shared hit=289624830 read=3289788 dirtied=25 written=8001, temp read=1214264 written=1363763
442. 2,953.802 725,252.027 ↑ 20.1 3,855,364 1

Hash Join (cost=355,259,423.59..500,652,572.3 rows=77,647,200 width=7,170) (actual time=593,934.13..725,252.027 rows=3,855,364 loops=1)

  • Buffers: shared hit=289624541 read=3289788 dirtied=25 written=8001, temp read=1214264 written=1363763
443. 2,395.350 722,281.769 ↑ 20.1 3,855,364 1

Hash Join (cost=355,258,617.89..500,244,118.56 rows=77,647,200 width=7,095) (actual time=593,917.585..722,281.769 rows=3,855,364 loops=1)

  • Buffers: shared hit=289624529 read=3289499 dirtied=24 written=8001, temp read=1214264 written=1363763
444. 2,635.840 719,886.410 ↑ 20.1 3,855,364 1

Hash Join (cost=355,258,616.49..499,836,172.12 rows=77,647,200 width=7,081) (actual time=593,917.565..719,886.41 rows=3,855,364 loops=1)

  • Buffers: shared hit=289624528 read=3289499 dirtied=24 written=8001, temp read=1214264 written=1363763
445. 5,664.790 717,250.537 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,258,615.09..499,428,225.67 rows=77,647,200 width=7,067) (actual time=593,917.517..717,250.537 rows=3,855,364 loops=1)

  • Buffers: shared hit=289624528 read=3289498 dirtied=24 written=8001, temp read=1214264 written=1363763
446. 7,714.551 700,019.655 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,258,614.67..464,730,882.75 rows=77,647,200 width=7,039) (actual time=593,917.5..700,019.655 rows=3,855,364 loops=1)

  • Buffers: shared hit=283328901 read=3288543 dirtied=24 written=8001, temp read=1214264 written=1363763
447. 2,482.656 665,317.556 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,258,614.24..430,033,539.83 rows=77,647,200 width=7,011) (actual time=593,917.438..665,317.556 rows=3,855,364 loops=1)

  • Buffers: shared hit=269040497 read=3285850 dirtied=24 written=8001, temp read=1214264 written=1363763
448. 4,118.862 651,268.808 ↑ 20.1 3,855,364 1

Nested Loop (cost=355,258,613.81..394,789,944.03 rows=77,647,200 width=6,942) (actual time=593,917.43..651,268.808 rows=3,855,364 loops=1)

  • Buffers: shared hit=262402374 read=3276331 dirtied=24 written=8001, temp read=1214264 written=1363763
449. 2,243.502 624,017.762 ↑ 20.1 3,855,364 1

Merge Join (cost=355,258,613.38..359,546,348.23 rows=77,647,200 width=6,873) (actual time=593,917.397..624,017.762 rows=3,855,364 loops=1)

  • Buffers: shared hit=247003491 read=3252384 dirtied=24 written=8001, temp read=1214264 written=1363763
450. 2,206.780 620,591.561 ↑ 20.2 3,845,270 1

Merge Join (cost=355,247,226.06..358,952,061.17 rows=77,647,200 width=6,733) (actual time=592,914.604..620,591.561 rows=3,845,270 loops=1)

  • Buffers: shared hit=247003491 read=3252384 dirtied=24 written=8001, temp read=1196997 written=1360032
451. 2,164.288 614,362.719 ↑ 20.2 3,840,245 1

Merge Join (cost=355,235,838.74..358,357,774.11 rows=77,647,200 width=6,593) (actual time=589,044.179..614,362.719 rows=3,840,245 loops=1)

  • Buffers: shared hit=247003467 read=3240739 dirtied=24 written=8001, temp read=1183689 written=1344585
452. 2,050.780 611,142.562 ↑ 20.2 3,840,244 1

Merge Join (cost=355,228,946.67..357,768,197.4 rows=77,647,200 width=6,429) (actual time=588,200.414..611,142.562 rows=3,840,244 loops=1)

  • Buffers: shared hit=247003467 read=3240739 dirtied=24 written=8001, temp read=1162226 written=1341707
453. 2,319.635 606,231.238 ↑ 20.2 3,840,243 1

Merge Join (cost=355,222,054.6..357,178,620.7 rows=77,647,200 width=6,265) (actual time=585,371.063..606,231.238 rows=3,840,243 loops=1)

  • Buffers: shared hit=247003440 read=3231763 dirtied=24 written=8001, temp read=1159933 written=1335368
454. 2,339.855 599,855.410 ↑ 20.2 3,839,783 1

Merge Join (cost=355,212,992..356,586,769.51 rows=77,647,200 width=6,069) (actual time=581,746.636..599,855.41 rows=3,839,783 loops=1)

  • Buffers: shared hit=247003424 read=3231763 dirtied=24 written=8001, temp read=1115247 written=1324604
455. 4,213.661 583,215.100 ↑ 20.2 3,839,647 1

Merge Join (cost=355,203,929.4..355,994,918.33 rows=77,647,200 width=5,873) (actual time=567,834.924..583,215.1 rows=3,839,647 loops=1)

  • Buffers: shared hit=246997651 read=3177085 dirtied=23 written=8001, temp read=1080190 written=1278628
456. 23,454.723 544,496.520 ↑ 20.2 3,839,647 1

Sort (cost=354,487,329.42..354,681,447.42 rows=77,647,200 width=5,855) (actual time=534,026.022..544,496.52 rows=3,839,647 loops=1)

  • Sort Key: sd_ml.ms_source_id, sd_ml.conference_date_time, sd_ml.session_seq
  • Sort Method: external merge Disk: 1312016kB
  • Buffers: shared hit=246997636 read=2660066 dirtied=23 written=8001, temp read=1074259 written=1272693
457. 521,041.797 521,041.797 ↑ 20.2 3,839,647 1

CTE Scan on session_details_with_media_line sd_ml (cost=0..1,552,944 rows=77,647,200 width=5,855) (actual time=498,508.587..521,041.797 rows=3,839,647 loops=1)

  • Buffers: shared hit=246997636 read=2660066 dirtied=23 written=8001, temp read=910257 written=1108607
458. 372.165 34,504.919 ↓ 1.6 1,818,742 1

Materialize (cost=716,599.98..722,396.91 rows=1,159,386 width=30) (actual time=33,806.678..34,504.919 rows=1,818,742 loops=1)

  • Buffers: shared hit=15 read=517019, temp read=5931 written=5935
459. 1,062.449 34,132.754 ↑ 1.0 1,148,707 1

Sort (cost=716,599.98..719,498.44 rows=1,159,386 width=30) (actual time=33,806.672..34,132.754 rows=1,148,707 loops=1)

  • Sort Key: session_qoe.ms_source_id, session_qoe.conference_date_time, session_qoe.session_seq
  • Sort Method: external merge Disk: 47448kB
  • Buffers: shared hit=15 read=517019, temp read=5931 written=5935
460. 136.418 33,070.305 ↑ 1.0 1,153,974 1

Append (cost=0..583,572.93 rows=1,159,386 width=30) (actual time=17.321..33,070.305 rows=1,153,974 loops=1)

  • Buffers: shared hit=15 read=517019
461. 218.766 218.766 ↓ 1.0 5,582 1

Seq Scan on ms_session_sfb_qoe_p2020_01_05 session_qoe (cost=0..417.73 rows=5,581 width=30) (actual time=17.32..218.766 rows=5,582 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=333
462. 11,568.866 11,568.866 ↓ 1.0 59,329 1

Seq Scan on ms_session_sfb_qoe_p2020_01_06 session_qoe_1 (cost=0..25,570.94 rows=59,317 width=30) (actual time=32.12..11,568.866 rows=59,329 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=24681
463. 1,326.817 1,326.817 ↓ 1.0 69,472 1

Seq Scan on ms_session_sfb_qoe_p2020_01_07 session_qoe_2 (cost=0..30,837.08 rows=69,458 width=30) (actual time=0.902..1,326.817 rows=69,472 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=29795
464. 1,231.214 1,231.214 ↓ 1.0 69,812 1

Seq Scan on ms_session_sfb_qoe_p2020_01_08 session_qoe_3 (cost=0..34,686.99 rows=69,185 width=30) (actual time=0.565..1,231.214 rows=69,812 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=33649
465. 1,375.894 1,375.894 ↑ 1.0 73,665 1

Seq Scan on ms_session_sfb_qoe_p2020_01_09 session_qoe_4 (cost=0..35,549.67 rows=74,763 width=30) (actual time=0.889..1,375.894 rows=73,665 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=34428
466. 1,126.461 1,126.461 ↓ 1.0 55,760 1

Seq Scan on ms_session_sfb_qoe_p2020_01_10 session_qoe_5 (cost=0..27,467.4 rows=55,749 width=30) (actual time=0.39..1,126.461 rows=55,760 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=26630
467. 31.789 31.789 ↓ 1.0 6,274 1

Seq Scan on ms_session_sfb_qoe_p2020_01_11 session_qoe_6 (cost=0..809.11 rows=6,273 width=30) (actual time=0.382..31.789 rows=6,274 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=714
468. 6.185 6.185 ↓ 1.0 5,887 1

Seq Scan on ms_session_sfb_qoe_p2020_01_12 session_qoe_7 (cost=0..217.31 rows=5,886 width=30) (actual time=0.461..6.185 rows=5,887 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=128
469. 1,339.748 1,339.748 ↓ 1.0 65,363 1

Seq Scan on ms_session_sfb_qoe_p2020_01_13 session_qoe_8 (cost=0..29,366.44 rows=65,350 width=30) (actual time=0.5..1,339.748 rows=65,363 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=28385
470. 830.834 830.834 ↓ 1.0 71,491 1

Seq Scan on ms_session_sfb_qoe_p2020_01_14 session_qoe_9 (cost=0..25,013.37 rows=71,477 width=30) (actual time=0.521..830.834 rows=71,491 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=23941
471. 1,580.939 1,580.939 ↑ 1.0 69,308 1

Seq Scan on ms_session_sfb_qoe_p2020_01_15 session_qoe_10 (cost=0..48,966.71 rows=69,567 width=30) (actual time=0.513..1,580.939 rows=69,308 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=47923
472. 1,062.780 1,062.780 ↑ 1.0 70,372 1

Seq Scan on ms_session_sfb_qoe_p2020_01_16 session_qoe_11 (cost=0..34,691.88 rows=71,178 width=30) (actual time=0.754..1,062.78 rows=70,372 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=33624
473. 881.491 881.491 ↓ 1.0 57,799 1

Seq Scan on ms_session_sfb_qoe_p2020_01_17 session_qoe_12 (cost=0..26,978.99 rows=57,787 width=30) (actual time=0.45..881.491 rows=57,799 loops=1)

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

Seq Scan on ms_session_sfb_qoe_p2020_01_18 session_qoe_13 (cost=0..1,079.18 rows=6,211 width=30) (actual time=0.416..33.87 rows=6,212 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=985
475. 8.066 8.066 ↓ 1.0 5,644 1

Seq Scan on ms_session_sfb_qoe_p2020_01_19 session_qoe_14 (cost=0..316.66 rows=5,643 width=30) (actual time=0.391..8.066 rows=5,644 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=231
476. 121.331 121.331 ↓ 1.0 15,000 1

Seq Scan on ms_session_sfb_qoe_p2020_01_20 session_qoe_15 (cost=0..2,371 rows=14,997 width=30) (actual time=0.357..121.331 rows=15,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=2145
477. 4,237.062 4,237.062 ↑ 1.0 74,351 1

Seq Scan on ms_session_sfb_qoe_p2020_01_21 session_qoe_16 (cost=0..34,995.46 rows=75,082 width=30) (actual time=93.157..4,237.062 rows=74,351 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=33869
478. 1,533.998 1,533.998 ↑ 1.0 79,286 1

Seq Scan on ms_session_sfb_qoe_p2020_01_22 session_qoe_17 (cost=0..44,038.13 rows=80,726 width=30) (actual time=0.348..1,533.998 rows=79,286 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=42826
479. 1,668.083 1,668.083 ↓ 1.0 73,834 1

Seq Scan on ms_session_sfb_qoe_p2020_01_23 session_qoe_18 (cost=0..48,660.53 rows=72,021 width=30) (actual time=0.441..1,668.083 rows=73,834 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=47579
480. 1,287.007 1,287.007 ↑ 1.0 62,377 1

Seq Scan on ms_session_sfb_qoe_p2020_01_24 session_qoe_19 (cost=0..38,884.57 rows=62,426 width=30) (actual time=0.904..1,287.007 rows=62,377 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=37948
481. 51.430 51.430 ↓ 1.0 6,973 1

Seq Scan on ms_session_sfb_qoe_p2020_01_25 session_qoe_20 (cost=0..1,622.6 rows=6,972 width=30) (actual time=0.342..51.43 rows=6,973 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=1517
482. 6.083 6.083 ↓ 1.0 6,913 1

Seq Scan on ms_session_sfb_qoe_p2020_01_26 session_qoe_21 (cost=0..286.69 rows=6,912 width=30) (actual time=0.488..6.083 rows=6,913 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=182
483. 1,015.989 1,015.989 ↑ 1.0 66,510 1

Seq Scan on ms_session_sfb_qoe_p2020_01_27 session_qoe_22 (cost=0..31,810.01 rows=66,588 width=30) (actual time=0.779..1,015.989 rows=66,510 loops=1)

  • Filter: ((conference_date_time >= '2020-01-05 00:00:01'::timestamp without time zone) AND (conference_date_time < '2020-01-28 23:59:59'::timestamp without time zone))
  • Buffers: shared read=30811
484. 55.023 389.184 ↑ 1.0 76,760 1

Bitmap Heap Scan on ms_session_sfb_qoe_p2020_01_28 session_qoe_23 (cost=7,282.21..58,934.5 rows=80,237 width=30) (actual time=335.031..389.184 rows=76,760 loops=1)

  • Heap Blocks: exact=2749
  • Buffers: shared hit=3 read=8583
485. 334.161 334.161 ↑ 1.0 77,189 1

Bitmap Index Scan on ms_session_sfb_qoe_p2020_01_28_pkey (cost=0..7,262.15 rows=80,237 width=0) (actual time=334.161..334.161 rows=77,189 loops=1)

  • Index Cond: ((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=2 read=5835
486. 3,671.468 14,300.455 ↓ 607.1 1,208,067 1

Sort (cost=9,062.6..9,067.57 rows=1,990 width=212) (actual time=13,910.17..14,300.455 rows=1,208,067 loops=1)

  • Sort Key: caller_astr.ms_source_id, caller_astr.conference_date_time, caller_astr.session_seq
  • Sort Method: external sort Disk: 86312kB
  • Buffers: shared hit=5773 read=54678 dirtied=1, temp read=29378 written=45976
487. 10,628.987 10,628.987 ↓ 395.4 786,760 1

CTE Scan on audio_stream caller_astr (cost=0..8,953.56 rows=1,990 width=212) (actual time=3,743.774..10,628.987 rows=786,760 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=5773 read=54678 dirtied=1, temp read=12910 written=35187
488. 3,718.310 4,056.193 ↓ 605.5 1,204,983 1

Sort (cost=9,062.6..9,067.57 rows=1,990 width=212) (actual time=3,622.882..4,056.193 rows=1,204,983 loops=1)

  • Sort Key: callee_astr.ms_source_id, callee_astr.conference_date_time, callee_astr.session_seq
  • Sort Method: external sort Disk: 86104kB
  • Buffers: shared hit=16, temp read=38859 written=10764
489. 337.883 337.883 ↓ 393.7 783,390 1

CTE Scan on audio_stream callee_astr (cost=0..8,953.56 rows=1,990 width=212) (actual time=0.022..337.883 rows=783,390 loops=1)

  • Filter: (sender_is_caller_pai = 0)
  • Buffers: temp read=22269 written=1
490. 60.824 2,860.544 ↓ 150.3 227,490 1

Sort (cost=6,892.07..6,895.86 rows=1,514 width=180) (actual time=2,829.309..2,860.544 rows=227,490 loops=1)

  • Sort Key: caller_vstr.ms_source_id, caller_vstr.conference_date_time, caller_vstr.session_seq
  • Sort Method: quicksort Memory: 14643kB
  • Buffers: shared hit=27 read=8976, temp read=2293 written=6339
491. 2,799.720 2,799.720 ↓ 54.3 82,281 1

CTE Scan on video_stream caller_vstr (cost=0..6,812.1 rows=1,514 width=180) (actual time=1,536.17..2,799.72 rows=82,281 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=27 read=8976, temp read=2293 written=6339
492. 991.712 1,055.869 ↓ 513.8 777,851 1

Sort (cost=6,892.07..6,895.86 rows=1,514 width=180) (actual time=843.676..1,055.869 rows=777,851 loops=1)

  • Sort Key: callee_vstr.ms_source_id, callee_vstr.conference_date_time, callee_vstr.session_seq
  • Sort Method: external sort Disk: 23016kB
  • Buffers: temp read=14193 written=2878
493. 64.157 64.157 ↓ 145.3 219,999 1

CTE Scan on video_stream callee_vstr (cost=0..6,812.1 rows=1,514 width=180) (actual time=0.022..64.157 rows=219,999 loops=1)

  • Filter: (sender_is_caller_pai = 0)
  • Buffers: temp read=4046 written=1
494. 1,060.008 4,022.062 ↓ 189.4 473,218 1

Sort (cost=11,387.32..11,393.57 rows=2,499 width=156) (actual time=3,870.26..4,022.062 rows=473,218 loops=1)

  • Sort Key: caller_appshstr.ms_source_id, caller_appshstr.conference_date_time, caller_appshstr.session_seq
  • Sort Method: external sort Disk: 30080kB
  • Buffers: shared hit=24 read=11645, temp read=10446 written=15447
495. 2,962.054 2,962.054 ↓ 108.4 270,940 1

CTE Scan on app_sharing_stream caller_appshstr (cost=0..11,246.29 rows=2,499 width=156) (actual time=1,023.309..2,962.054 rows=270,940 loops=1)

  • Filter: (sender_is_caller_pai = 1)
  • Buffers: shared hit=24 read=11645, temp read=3824 written=11687
496. 1,074.979 1,182.699 ↓ 193.8 484,213 1

Sort (cost=11,387.32..11,393.57 rows=2,499 width=156) (actual time=1,002.514..1,182.699 rows=484,213 loops=1)

  • Sort Key: callee_appshstr.ms_source_id, callee_appshstr.conference_date_time, callee_appshstr.session_seq
  • Sort Method: external sort Disk: 29840kB
  • Buffers: temp read=14430 written=3731
497. 107.720 107.720 ↓ 110.1 275,253 1

CTE Scan on app_sharing_stream callee_appshstr (cost=0..11,246.29 rows=2,499 width=156) (actual time=0.014..107.72 rows=275,253 loops=1)

  • Filter: (sender_is_caller_pai = 0)
  • Buffers: temp read=7863 written=1
498. 23,132.184 23,132.184 ↑ 1.0 1 3,855,364

Index Scan using ms_users_sfb_cdr_pkey on ms_users_sfb_cdr u1 (cost=0.43..0.45 rows=1 width=73) (actual time=0.006..0.006 rows=1 loops=3,855,364)

  • Index Cond: ((sd_ml.ms_source_id = ms_source_id) AND (sd_ml.user_1_id = user_id))
  • Buffers: shared hit=15398883 read=23947
499. 11,566.092 11,566.092 ↓ 0.0 0 3,855,364

Index Scan using ms_users_sfb_cdr_pkey on ms_users_sfb_cdr u2 (cost=0.43..0.45 rows=1 width=73) (actual time=0.003..0.003 rows=0 loops=3,855,364)

  • Index Cond: ((sd_ml.ms_source_id = ms_source_id) AND (sd_ml.user_2_id = user_id))
  • Buffers: shared hit=6638123 read=9519
500. 26,987.548 26,987.548 ↑ 1.0 1 3,855,364

Index Scan using ad_users_pkey on ad_users uad1 (cost=0.42..0.45 rows=1 width=57) (actual time=0.007..0.007 rows=1 loops=3,855,364)

  • Index Cond: (lower((u1.email)::text) = (email_new)::text)
  • Buffers: shared hit=14288404 read=2693
501. 11,566.092 11,566.092 ↓ 0.0 0 3,855,364

Index Scan using ad_users_pkey on ad_users uad2 (cost=0.42..0.45 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=3,855,364)

  • Index Cond: (lower((u2.email)::text) = (email_new)::text)
  • Buffers: shared hit=6295627 read=955
502. 0.006 0.033 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=20) (actual time=0.033..0.033 rows=16 loops=1)

  • Buffers: shared read=1
503. 0.027 0.027 ↑ 1.0 16 1

Seq Scan on ms_uri_types_sfb_cdr ut1 (cost=0..1.16 rows=16 width=20) (actual time=0.025..0.027 rows=16 loops=1)

  • Buffers: shared read=1
504. 0.004 0.009 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=20) (actual time=0.009..0.009 rows=16 loops=1)

  • Buffers: shared hit=1
505. 0.005 0.005 ↑ 1.0 16 1

Seq Scan on ms_uri_types_sfb_cdr ut2 (cost=0..1.16 rows=16 width=20) (actual time=0.003..0.005 rows=16 loops=1)

  • Buffers: shared hit=1
506. 4.154 16.456 ↑ 1.0 20,466 1

Hash (cost=495.68..495.68 rows=20,668 width=79) (actual time=16.456..16.456 rows=20,466 loops=1)

  • Buffers: shared read=289 dirtied=1
507. 12.302 12.302 ↑ 1.0 20,466 1

Seq Scan on ms_client_versions_sfb_cdr caller_clv (cost=0..495.68 rows=20,668 width=79) (actual time=0.537..12.302 rows=20,466 loops=1)

  • Buffers: shared read=289 dirtied=1
508. 3.762 7.133 ↑ 1.0 20,466 1

Hash (cost=495.68..495.68 rows=20,668 width=79) (actual time=7.133..7.133 rows=20,466 loops=1)

  • Buffers: shared hit=289
509. 3.371 3.371 ↑ 1.0 20,466 1

Seq Scan on ms_client_versions_sfb_cdr callee_clv (cost=0..495.68 rows=20,668 width=79) (actual time=0.006..3.371 rows=20,466 loops=1)

  • Buffers: shared hit=289
510. 4.284 13.453 ↑ 1.0 22,118 1

Hash (cost=452.36..452.36 rows=22,736 width=47) (actual time=13.453..13.453 rows=22,118 loops=1)

  • Buffers: shared read=225 dirtied=1
511. 9.169 9.169 ↑ 1.0 22,118 1

Seq Scan on ms_device_sfb_qoe dev_caller_cap (cost=0..452.36 rows=22,736 width=47) (actual time=1.217..9.169 rows=22,118 loops=1)

  • Buffers: shared read=225 dirtied=1
512. 3.977 7.404 ↑ 1.0 22,118 1

Hash (cost=452.36..452.36 rows=22,736 width=47) (actual time=7.404..7.404 rows=22,118 loops=1)

  • Buffers: shared hit=225
513. 3.427 3.427 ↑ 1.0 22,118 1

Seq Scan on ms_device_sfb_qoe dev_caller_ren (cost=0..452.36 rows=22,736 width=47) (actual time=0.005..3.427 rows=22,118 loops=1)

  • Buffers: shared hit=225
514. 3.929 7.323 ↑ 1.0 22,118 1

Hash (cost=452.36..452.36 rows=22,736 width=47) (actual time=7.323..7.323 rows=22,118 loops=1)

  • Buffers: shared hit=225
515. 3.394 3.394 ↑ 1.0 22,118 1

Seq Scan on ms_device_sfb_qoe dev_callee_cap (cost=0..452.36 rows=22,736 width=47) (actual time=0.005..3.394 rows=22,118 loops=1)

  • Buffers: shared hit=225
516. 3.987 7.346 ↑ 1.0 22,118 1

Hash (cost=452.36..452.36 rows=22,736 width=47) (actual time=7.346..7.346 rows=22,118 loops=1)

  • Buffers: shared hit=225
517. 3.359 3.359 ↑ 1.0 22,118 1

Seq Scan on ms_device_sfb_qoe dev_callee_ren (cost=0..452.36 rows=22,736 width=47) (actual time=0.006..3.359 rows=22,118 loops=1)

  • Buffers: shared hit=225
518. 0.011 1.642 ↑ 2.0 42 1

Hash (cost=1.68..1.68 rows=84 width=152) (actual time=1.642..1.642 rows=42 loops=1)

  • Buffers: shared read=2 dirtied=2
519. 1.631 1.631 ↑ 2.0 42 1

CTE Scan on user_agent_def caller_uad (cost=0..1.68 rows=84 width=152) (actual time=1.611..1.631 rows=42 loops=1)

  • Buffers: shared read=2 dirtied=2
520. 0.008 0.015 ↑ 2.0 42 1

Hash (cost=1.68..1.68 rows=84 width=152) (actual time=0.015..0.015 rows=42 loops=1)

521. 0.007 0.007 ↑ 2.0 42 1

CTE Scan on user_agent_def callee_uad (cost=0..1.68 rows=84 width=152) (actual time=0.001..0.007 rows=42 loops=1)

522. 0.007 0.312 ↑ 2.6 43 1

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

  • Buffers: shared read=1
523. 0.305 0.305 ↑ 2.6 43 1

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

  • Buffers: shared read=1
524. 0.007 0.014 ↑ 2.6 43 1

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

  • Buffers: shared hit=1
525. 0.007 0.007 ↑ 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.007 rows=43 loops=1)

  • Buffers: shared hit=1
526. 62.234 246.595 ↑ 1.0 254,830 1

Hash (cost=8,211.62..8,211.62 rows=262,062 width=18) (actual time=246.595..246.595 rows=254,830 loops=1)

  • Buffers: shared read=5591 dirtied=6
527. 184.361 184.361 ↑ 1.0 254,830 1

Seq Scan on ms_endpoint_sfb_qoe caller_endpoint (cost=0..8,211.62 rows=262,062 width=18) (actual time=0.854..184.361 rows=254,830 loops=1)

  • Buffers: shared read=5591 dirtied=6
528. 57.835 108.172 ↑ 1.0 254,830 1

Hash (cost=8,211.62..8,211.62 rows=262,062 width=18) (actual time=108.172..108.172 rows=254,830 loops=1)

  • Buffers: shared hit=5591
529. 50.337 50.337 ↑ 1.0 254,830 1

Seq Scan on ms_endpoint_sfb_qoe callee_endpoint (cost=0..8,211.62 rows=262,062 width=18) (actual time=0.009..50.337 rows=254,830 loops=1)

  • Buffers: shared hit=5591
530. 4.011 34.448 ↑ 1.0 11,457 1

Hash (cost=236.5..236.5 rows=11,825 width=668) (actual time=34.448..34.448 rows=11,457 loops=1)

  • Buffers: shared read=185 dirtied=2
531. 30.437 30.437 ↑ 1.0 11,457 1

CTE Scan on user_agent caller_ua (cost=0..236.5 rows=11,825 width=668) (actual time=17.589..30.437 rows=11,457 loops=1)

  • Buffers: shared read=185 dirtied=2
532. 3.538 6.876 ↑ 1.0 11,457 1

Hash (cost=236.5..236.5 rows=11,825 width=668) (actual time=6.876..6.876 rows=11,457 loops=1)

533. 3.338 3.338 ↑ 1.0 11,457 1

CTE Scan on user_agent callee_ua (cost=0..236.5 rows=11,825 width=668) (actual time=0.002..3.338 rows=11,457 loops=1)

534. 3,855.364 3,855.364 ↓ 0.0 0 3,855,364

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe caller_subn (cost=0.42..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=3,855,364)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.caller_subnet_key))
  • Buffers: shared hit=5612733 read=1096
535. 3,855.364 3,855.364 ↓ 0.0 0 3,855,364

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe callee_subn (cost=0.42..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=3,855,364)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.callee_subnet_key))
  • Buffers: shared hit=5982715 read=165
536. 3,855.364 3,855.364 ↓ 0.0 0 3,855,364

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe caller_refl_ip (cost=0.42..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=3,855,364)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.caller_reflexive_local_ip_addr))
  • Buffers: shared hit=5615059 read=1342
537. 3,855.364 3,855.364 ↓ 0.0 0 3,855,364

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe callee_refl_ip (cost=0.42..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=3,855,364)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.callee_reflexive_local_ip_addr))
  • Buffers: shared hit=5984366 read=160
538. 3,855.364 3,855.364 ↓ 0.0 0 3,855,364

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe caller_ip (cost=0.42..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=3,855,364)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.caller_ip_addr_key))
  • Buffers: shared hit=5949278 read=5231
539. 3,855.364 3,855.364 ↓ 0.0 0 3,855,364

Index Scan using ms_ip_address_sfb_qoe_pkey on ms_ip_address_sfb_qoe callee_ip (cost=0.42..0.45 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=3,855,364)

  • Index Cond: ((ms_source_id = sd_ml.ms_source_id) AND (ip_address_key = sd_ml.callee_ip_addr_key))
  • Buffers: shared hit=6154947 read=1070
540. 19,276.820 19,276.820 ↓ 0.0 0 3,855,364

Index Scan using idx_internal_network_region_mapping_network_network_ip on internal_network_region_mapping caller_locations (cost=0.15..0.18 rows=2 width=39) (actual time=0.005..0.005 rows=0 loops=3,855,364)

  • Index Cond: ((NULLIF((caller_ip.ip_address)::text, ''::text))::inet << ip)
  • Buffers: shared hit=3689961 read=6
541. 19,276.820 19,276.820 ↓ 0.0 0 3,855,364

Index Scan using idx_internal_network_region_mapping_network_network_ip on internal_network_region_mapping callee_locations (cost=0.15..0.18 rows=2 width=39) (actual time=0.005..0.005 rows=0 loops=3,855,364)

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

SubPlan (for WindowAgg)

543. 7,710.728 19,276.820 ↑ 1.0 1 3,855,364

Aggregate (cost=12.05..12.06 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=3,855,364)

  • Buffers: shared hit=51
544. 3,855.364 11,566.092 ↓ 0.0 0 3,855,364

HashAggregate (cost=5.3..8.3 rows=300 width=32) (actual time=0.003..0.003 rows=0 loops=3,855,364)

  • Group Key: (unnest(caller_astr.codecs))
545. 7,710.728 7,710.728 ↓ 0.0 0 3,855,364

Append (cost=0..4.55 rows=300 width=32) (actual time=0.001..0.002 rows=0 loops=3,855,364)

546. 0.000 0.000 ↓ 0.0 0 3,855,364

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=3,855,364)

547. 0.000 0.000 ↑ 1.0 1 3,855,364

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=3,855,364)

548. 0.000 0.000 ↓ 0.0 0 3,855,364

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=3,855,364)

549. 0.000 0.000 ↑ 1.0 1 3,855,364

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=3,855,364)

550. 0.000 0.000 ↓ 0.0 0 3,855,364

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=3,855,364)

551. 0.000 0.000 ↑ 1.0 1 3,855,364

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=3,855,364)

552. 3,855.364 15,421.456 ↑ 1.0 1 3,855,364

Aggregate (cost=12.05..12.06 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=3,855,364)

553. 7,710.728 11,566.092 ↓ 0.0 0 3,855,364

HashAggregate (cost=5.3..8.3 rows=300 width=32) (actual time=0.003..0.003 rows=0 loops=3,855,364)

  • Group Key: (unnest(callee_astr.codecs))
554. 3,855.364 3,855.364 ↓ 0.0 0 3,855,364

Append (cost=0..4.55 rows=300 width=32) (actual time=0.001..0.001 rows=0 loops=3,855,364)

555. 0.000 0.000 ↓ 0.0 0 3,855,364

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=3,855,364)

556. 0.000 0.000 ↑ 1.0 1 3,855,364

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=3,855,364)

557. 0.000 0.000 ↓ 0.0 0 3,855,364

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=3,855,364)

558. 0.000 0.000 ↑ 1.0 1 3,855,364

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=3,855,364)

559. 0.000 0.000 ↓ 0.0 0 3,855,364

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0 rows=0 loops=3,855,364)

560. 0.000 0.000 ↑ 1.0 1 3,855,364

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=3,855,364)

561.          

CTE stitched_data_phase1

562. 15,854.806 1,391,407.681 ↑ 485,937.8 3,855,364 1

WindowAgg (cost=72,511,840,661,123..75,888,765,229,788.3 rows=1,873,467,167,082 width=15,553) (actual time=1,263,191.789..1,391,407.681 rows=3,855,364 loops=1)

  • Buffers: shared hit=331770901 read=3304865 dirtied=36 written=8001, temp read=6859306 written=6891840
563. 54,999.062 1,279,168.775 ↑ 485,937.8 3,855,364 1

Sort (cost=72,511,840,661,123..72,516,524,329,040.7 rows=1,873,467,167,082 width=26,721) (actual time=1,263,191.681..1,279,168.775 rows=3,855,364 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 sort Disk: 7015688kB
  • Buffers: shared hit=331770901 read=3304865 dirtied=36 written=8001, temp read=6859306 written=6891840
564. 15,730.490 1,224,169.713 ↑ 485,937.8 3,855,364 1

Merge Join (cost=5,612,759,386.22..9,420,022,692,442.9 rows=1,873,467,167,082 width=26,721) (actual time=1,164,326.862..1,224,169.713 rows=3,855,364 loops=1)

  • Buffers: shared hit=331770901 read=3304865 dirtied=36 written=8001, temp read=5982345 written=6014879
565. 88,530.682 1,125,693.075 ↑ 71.2 3,855,364 1

Sort (cost=2,946,478,867.14..2,947,164,957.8 rows=274,436,264 width=14,059) (actual time=1,085,441.267..1,125,693.075 rows=3,855,364 loops=1)

  • Sort Key: d1_24.dialog
  • Sort Method: external sort Disk: 7009352kB
  • Buffers: shared hit=331770901 read=3304865 dirtied=36 written=8001, temp read=4845588 written=5772529
566. 1,037,162.393 1,037,162.393 ↑ 71.2 3,855,364 1

CTE Scan on prepared_dataset d1_24 (cost=0..5,488,725.28 rows=274,436,264 width=14,059) (actual time=917,480.668..1,037,162.393 rows=3,855,364 loops=1)

  • Buffers: shared hit=331770901 read=3304865 dirtied=36 written=8001, temp read=3969419 written=4896360
567. 902.249 82,746.148 ↑ 36.8 7,462,004 1

Materialize (cost=2,666,280,519.09..2,667,652,700.41 rows=274,436,264 width=12,700) (actual time=78,885.56..82,746.148 rows=7,462,004 loops=1)

  • Buffers: temp read=1136757 written=242350
568. 37,004.412 81,843.899 ↑ 71.5 3,835,710 1

Sort (cost=2,666,280,519.09..2,666,966,609.75 rows=274,436,264 width=12,700) (actual time=78,885.529..81,843.899 rows=3,835,710 loops=1)

  • Sort Key: d2.dialog
  • Sort Method: external sort Disk: 1938792kB
  • Buffers: temp read=1136757 written=242350
569. 44,839.487 44,839.487 ↑ 71.2 3,855,364 1

CTE Scan on prepared_dataset d2 (cost=0..5,488,725.28 rows=274,436,264 width=12,700) (actual time=0.565..44,839.487 rows=3,855,364 loops=1)

  • Buffers: temp read=895301 written=1
570.          

SubPlan (for WindowAgg)

571. 73,251.916 96,384.100 ↑ 1.0 1 3,855,364

Aggregate (cost=1.77..1.78 rows=1 width=32) (actual time=0.025..0.025 rows=1 loops=3,855,364)

572. 23,132.184 23,132.184 ↑ 1.5 65 3,855,364

ProjectSet (cost=0..0.52 rows=100 width=32) (actual time=0..0.006 rows=65 loops=3,855,364)

573. 0.000 0.000 ↑ 1.0 1 3,855,364

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=3,855,364)

Planning time : 826.575 ms
Execution time : 1,418,314.419 ms