explain.depesz.com

PostgreSQL's explain analyze made readable

Result: izcC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=26,501,109.91..26,501,134.91 rows=10,001 width=48) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=26,501,109.91..26,501,706.52 rows=238,646 width=48) (actual rows= loops=)

  • Sort Key: mss_session_summary.mintimestamp, (lpad(upper(to_hex(mss_session.sessionid)), 16, '0'::text))
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,093,761.93..26,484,061.21 rows=238,646 width=48) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,093,761.36..25,108,383.52 rows=301,802 width=24) (actual rows= loops=)

  • Hash Cond: (mss_session_summary.sessionid = session_identity.sessionid)
5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..22,424,692.30 rows=423,176,492 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary (cost=0.00..0.00 rows=1 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
7. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_mintimestamp_idx on mss_session_summary_20170829130000 (cost=0.56..4.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
8. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190503194825_mintimestamp_idx on mss_session_summary_20190503194825 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
9. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190504043028_mintimestamp_idx on mss_session_summary_20190504043028 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
10. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190504074432_mintimestamp_idx on mss_session_summary_20190504074432 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
11. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190504110035_mintimestamp_idx on mss_session_summary_20190504110035 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
12. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190504142440_mintimestamp_idx on mss_session_summary_20190504142440 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
13. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190504171043_mintimestamp_idx on mss_session_summary_20190504171043 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
14. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190504194247_mintimestamp_idx on mss_session_summary_20190504194247 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
15. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190505042131_mintimestamp_idx on mss_session_summary_20190505042131 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
16. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190505073735_mintimestamp_idx on mss_session_summary_20190505073735 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
17. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190505105139_mintimestamp_idx on mss_session_summary_20190505105139 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
18. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190506124558_mintimestamp_idx on mss_session_summary_20190506124558 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
19. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190506155802_mintimestamp_idx on mss_session_summary_20190506155802 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
20. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190507041606_mintimestamp_idx on mss_session_summary_20190507041606 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
21. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190507082612_mintimestamp_idx on mss_session_summary_20190507082612 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
22. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190508130153_mintimestamp_idx on mss_session_summary_20190508130153 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
23. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190508161200_mintimestamp_idx on mss_session_summary_20190508161200 (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
24. 0.000 0.000 ↓ 0.0

Index Scan using mss_session_summary_20190508183604_mintimestamp_idx on mss_session_summary_20190508183604 (cost=0.43..160,955.65 rows=1,770,255 width=16) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
25. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509022208 (cost=0.00..549,733.07 rows=10,211,046 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
26. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509065216 (cost=0.00..552,873.90 rows=10,285,112 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
27. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509101619 (cost=0.00..564,287.46 rows=10,530,997 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
28. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509131424 (cost=0.00..563,463.79 rows=10,554,063 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
29. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509152628 (cost=0.00..560,636.01 rows=10,440,561 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
30. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509170830 (cost=0.00..566,168.25 rows=10,500,180 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
31. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509184236 (cost=0.00..559,998.70 rows=10,135,736 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
32. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190509211642 (cost=0.00..588,986.03 rows=10,755,522 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
33. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510043031 (cost=0.00..562,125.38 rows=10,352,990 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
34. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510064637 (cost=0.00..556,891.39 rows=10,155,471 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
35. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510084842 (cost=0.00..569,610.72 rows=10,615,818 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
36. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510110646 (cost=0.00..573,443.00 rows=10,739,280 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
37. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510132849 (cost=0.00..564,118.97 rows=10,559,838 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
38. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510153853 (cost=0.00..564,491.54 rows=10,507,803 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
39. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510171856 (cost=0.00..563,353.32 rows=10,444,266 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
40. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190510185301 (cost=0.00..586,730.50 rows=10,704,280 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
41. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190511052053 (cost=0.00..554,107.57 rows=10,143,406 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
42. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190511084458 (cost=0.00..563,098.90 rows=10,447,352 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
43. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190511192304 (cost=0.00..579,461.93 rows=10,354,874 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
44. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190512010309 (cost=0.00..570,500.22 rows=10,625,698 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
45. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190512052917 (cost=0.00..556,769.24 rows=10,151,459 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
46. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190512073126 (cost=0.00..557,465.86 rows=10,235,749 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
47. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190512093731 (cost=0.00..573,643.15 rows=10,742,492 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
48. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190512115937 (cost=0.00..573,582.60 rows=10,741,328 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
49. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190512142141 (cost=0.00..560,443.53 rows=10,488,682 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
50. 0.000 0.000 ↓ 0.0

Seq Scan on mss_session_summary_20190512161945 (cost=0.00..564,434.80 rows=10,453,424 width=16) (actual rows= loops=)

  • Filter: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
51. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190512175350 (cost=264,721.14..914,659.92 rows=17,806,542 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
52. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190512175350_mintimestamp_idx (cost=0.00..260,269.51 rows=17,806,542 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
53. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190512193355 (cost=239,991.67..930,878.88 rows=18,928,417 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
54. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190512193355_mintimestamp_idx (cost=0.00..235,259.57 rows=18,928,417 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
55. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190513015359 (cost=251,875.44..907,853.44 rows=17,972,000 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
56. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190513015359_mintimestamp_idx (cost=0.00..247,382.44 rows=17,972,000 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
57. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190513054007 (cost=265,978.77..913,683.43 rows=17,745,333 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
58. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190513054007_mintimestamp_idx (cost=0.00..261,542.44 rows=17,745,333 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
59. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190513074014 (cost=264,875.70..920,572.35 rows=17,964,292 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
60. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190513074014_mintimestamp_idx (cost=0.00..260,384.63 rows=17,964,292 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
61. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190513094818 (cost=249,697.08..907,528.98 rows=18,022,792 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
62. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190513094818_mintimestamp_idx (cost=0.00..245,191.38 rows=18,022,792 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
63. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190513122823 (cost=250,742.49..899,802.21 rows=17,782,458 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
64. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190513122823_mintimestamp_idx (cost=0.00..246,296.88 rows=17,782,458 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
65. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190513154430 (cost=246,639.77..907,046.43 rows=18,093,333 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
66. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190513154430_mintimestamp_idx (cost=0.00..242,116.44 rows=18,093,333 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
67. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mss_session_summary_20190513181035 (cost=70,918.03..261,215.34 rows=5,213,625 width=16) (actual rows= loops=)

  • Recheck Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
68. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mss_session_summary_20190513181035_mintimestamp_idx (cost=0.00..69,614.62 rows=5,213,625 width=0) (actual rows= loops=)

  • Index Cond: (mintimestamp >= '2019-05-08 23:00:00'::timestamp without time zone)
69. 0.000 0.000 ↓ 0.0

Hash (cost=1,089,988.83..1,089,988.83 rows=301,802 width=8) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,089,988.83 rows=301,802 width=8) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on session_identity (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: (imsi = '234990001902369'::text)
72. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20170829130000_imsi_idx on session_identity_20170829130000 (cost=0.56..28.67 rows=6 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
73. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190504111836_imsi_idx on session_identity_20190504111836 (cost=0.56..24.65 rows=5 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
74. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190505001329_imsi_idx on session_identity_20190505001329 (cost=0.56..24.65 rows=5 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
75. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190506125159_imsi_idx on session_identity_20190506125159 (cost=0.56..24.65 rows=5 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
76. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190508113349_imsi_idx on session_identity_20190508113349 (cost=0.56..28.67 rows=6 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
77. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190509051612_imsi_idx on session_identity_20190509051612 (cost=0.56..20.63 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
78. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190509152627_imsi_idx1 on session_identity_20190509152627 (cost=0.56..20.63 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
79. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190510021108_imsi_idx on session_identity_20190510021108 (cost=0.56..20.63 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
80. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190510105845_imsi_idx on session_identity_20190510105845 (cost=0.56..24.65 rows=5 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
81. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190510175658_imsi_idx on session_identity_20190510175658 (cost=0.56..20.63 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
82. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190511191102_imsi_idx on session_identity_20190511191102 (cost=0.56..24.65 rows=5 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
83. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190512081728_imsi_idx on session_identity_20190512081728 (cost=0.56..20.63 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
84. 0.000 0.000 ↓ 0.0

Index Scan using session_identity_20190512160145_imsi_idx on session_identity_20190512160145 (cost=0.56..20.63 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
85. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on session_identity_20190513035202 (cost=4,143.14..379,908.05 rows=178,913 width=8) (actual rows= loops=)

  • Recheck Cond: (imsi = '234990001902369'::text)
86. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on session_identity_20190513035202_imsi_idx (cost=0.00..4,098.41 rows=178,913 width=0) (actual rows= loops=)

  • Index Cond: (imsi = '234990001902369'::text)
87. 0.000 0.000 ↓ 0.0

Seq Scan on session_identity_20190513114823 (cost=0.00..709,776.38 rows=122,827 width=8) (actual rows= loops=)

  • Filter: (imsi = '234990001902369'::text)
88. 0.000 0.000 ↓ 0.0

Index Only Scan using mss_session_pkey on mss_session (cost=0.57..4.54 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (sessionid = mss_session_summary.sessionid)