explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jwbL

Settings
# exclusive inclusive rows x rows loops node
1. 0.100 4.781 ↑ 1.0 84 1

Limit (cost=495.09..495.30 rows=84 width=16) (actual time=4.634..4.781 rows=84 loops=1)

2. 0.257 4.681 ↑ 1.0 84 1

Sort (cost=495.09..495.30 rows=84 width=16) (actual time=4.631..4.681 rows=84 loops=1)

  • Sort Key: ('KEYSWON'::text), cmd.id, memp.operation_data_id
  • Sort Method: quicksort Memory: 31kB
3. 0.122 4.424 ↑ 1.0 84 1

HashAggregate (cost=491.56..492.40 rows=84 width=16) (actual time=4.381..4.424 rows=84 loops=1)

  • Group Key: memp.operation_data_id, cmd.id, ('KEYSWON'::text)
4. 0.094 4.302 ↑ 1.0 84 1

Append (cost=18.16..490.93 rows=84 width=16) (actual time=0.378..4.302 rows=84 loops=1)

5. 0.000 0.596 ↑ 1.0 14 1

Hash Join (cost=18.16..66.48 rows=14 width=16) (actual time=0.376..0.596 rows=14 loops=1)

  • Hash Cond: (cod.model_id = cmd.id)
6.          

Initplan (forHash Join)

7. 0.105 0.229 ↑ 1.0 1 1

Hash Join (cost=5.81..12.48 rows=1 width=8) (actual time=0.080..0.229 rows=1 loops=1)

  • Hash Cond: (t_5.id = m_5.terminal_id)
8. 0.103 0.103 ↑ 1.0 193 1

Seq Scan on cq_terminals t_5 (cost=0.00..5.93 rows=193 width=16) (actual time=0.003..0.103 rows=193 loops=1)

9. 0.003 0.021 ↑ 1.0 1 1

Hash (cost=5.80..5.80 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
10. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on cq_machines m_5 (cost=0.00..5.80 rows=1 width=8) (actual time=0.013..0.018 rows=1 loops=1)

  • Filter: (id = 86)
  • Rows Removed by Filter: 143
11. 0.045 0.542 ↑ 1.0 14 1

Nested Loop (cost=4.37..52.49 rows=14 width=16) (actual time=0.338..0.542 rows=14 loops=1)

12. 0.021 0.427 ↑ 1.0 14 1

Nested Loop (cost=4.09..47.11 rows=14 width=8) (actual time=0.325..0.427 rows=14 loops=1)

13. 0.015 0.369 ↑ 1.0 1 1

Nested Loop (cost=0.00..27.08 rows=1 width=8) (actual time=0.300..0.369 rows=1 loops=1)

  • Join Filter: (cl.id = me.data_class_id)
  • Rows Removed by Join Filter: 12
14. 0.012 0.256 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.19 rows=1 width=8) (actual time=0.250..0.256 rows=1 loops=1)

  • Join Filter: (cmes.id = cl.message_id)
15. 0.239 0.239 ↑ 1.0 1 1

Seq Scan on cq_messages cmes (cost=0.00..1.01 rows=1 width=8) (actual time=0.237..0.239 rows=1 loops=1)

  • Filter: (version = $15)
16. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on cq_data_class cl (cost=0.00..1.16 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: ((data_class_no)::text = '1200'::text)
  • Rows Removed by Filter: 12
17. 0.098 0.098 ↑ 1.0 13 1

Seq Scan on cq_message_formats me (cost=0.00..24.73 rows=13 width=16) (actual time=0.003..0.098 rows=13 loops=1)

  • Filter: (data_no = 1)
  • Rows Removed by Filter: 765
18. 0.025 0.037 ↑ 1.0 14 1

Bitmap Heap Scan on cq_message_format_mappings memp (cost=4.09..19.89 rows=14 width=16) (actual time=0.018..0.037 rows=14 loops=1)

  • Recheck Cond: (message_format_id = me.id)
  • Heap Blocks: exact=14
19. 0.012 0.012 ↑ 1.0 14 1

Bitmap Index Scan on cq_message_format_mappings_index03 (cost=0.00..4.08 rows=14 width=0) (actual time=0.012..0.012 rows=14 loops=1)

  • Index Cond: (message_format_id = me.id)
20. 0.070 0.070 ↑ 1.0 1 14

Index Scan using cq_operation_data_index01 on cq_operation_data cod (cost=0.29..0.37 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=14)

  • Index Cond: (id = memp.operation_data_id)
21. 0.010 0.022 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.022..0.022 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
22. 0.012 0.012 ↑ 1.0 14 1

Seq Scan on cq_models cmd (cost=0.00..1.14 rows=14 width=8) (actual time=0.005..0.012 rows=14 loops=1)

23. 0.000 1.015 ↑ 1.0 14 1

Hash Join (cost=18.47..84.72 rows=14 width=16) (actual time=0.736..1.015 rows=14 loops=1)

  • Hash Cond: (cod_1.model_id = cmd_1.id)
24.          

Initplan (forHash Join)

25. 0.241 0.367 ↑ 1.0 1 1

Hash Join (cost=5.81..12.48 rows=1 width=8) (actual time=0.111..0.367 rows=1 loops=1)

  • Hash Cond: (t_4.id = m_4.terminal_id)
26. 0.105 0.105 ↑ 1.0 193 1

Seq Scan on cq_terminals t_4 (cost=0.00..5.93 rows=193 width=16) (actual time=0.004..0.105 rows=193 loops=1)

27. 0.003 0.021 ↑ 1.0 1 1

Hash (cost=5.80..5.80 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
28. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on cq_machines m_4 (cost=0.00..5.80 rows=1 width=8) (actual time=0.013..0.018 rows=1 loops=1)

  • Filter: (id = 86)
  • Rows Removed by Filter: 143
29. 0.053 0.830 ↑ 1.0 14 1

Nested Loop (cost=4.68..70.74 rows=14 width=16) (actual time=0.568..0.830 rows=14 loops=1)

30. 0.027 0.721 ↑ 1.0 14 1

Nested Loop (cost=4.39..65.36 rows=14 width=8) (actual time=0.557..0.721 rows=14 loops=1)

31. 0.016 0.634 ↑ 1.0 1 1

Nested Loop (cost=0.00..28.88 rows=1 width=8) (actual time=0.519..0.634 rows=1 loops=1)

  • Join Filter: (cl_1.id = me_1.data_class_id)
  • Rows Removed by Join Filter: 2
32. 0.026 0.420 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.19 rows=1 width=8) (actual time=0.416..0.420 rows=1 loops=1)

  • Join Filter: (cmes_1.id = cl_1.message_id)
33. 0.381 0.381 ↑ 1.0 1 1

Seq Scan on cq_messages cmes_1 (cost=0.00..1.01 rows=1 width=8) (actual time=0.380..0.381 rows=1 loops=1)

  • Filter: (version = $12)
34. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on cq_data_class cl_1 (cost=0.00..1.16 rows=1 width=16) (actual time=0.011..0.013 rows=1 loops=1)

  • Filter: ((data_class_no)::text = '0200'::text)
  • Rows Removed by Filter: 12
35. 0.198 0.198 ↓ 1.5 3 1

Seq Scan on cq_message_formats me_1 (cost=0.00..26.67 rows=2 width=16) (actual time=0.022..0.198 rows=3 loops=1)

  • Filter: ((byte_position = 1) AND (bit_position = 8))
  • Rows Removed by Filter: 775
36. 0.041 0.060 ↑ 1.0 14 1

Bitmap Heap Scan on cq_message_format_mappings memp_1 (cost=4.39..36.33 rows=14 width=16) (actual time=0.026..0.060 rows=14 loops=1)

  • Recheck Cond: (message_format_id = me_1.id)
  • Heap Blocks: exact=14
37. 0.019 0.019 ↑ 1.0 14 1

Bitmap Index Scan on cq_message_format_mappings_index03 (cost=0.00..4.39 rows=14 width=0) (actual time=0.019..0.019 rows=14 loops=1)

  • Index Cond: (message_format_id = me_1.id)
38. 0.056 0.056 ↑ 1.0 1 14

Index Scan using cq_operation_data_index01 on cq_operation_data cod_1 (cost=0.29..0.37 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=14)

  • Index Cond: (id = memp_1.operation_data_id)
39. 0.016 0.145 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.145..0.145 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
40. 0.129 0.129 ↑ 1.0 14 1

Seq Scan on cq_models cmd_1 (cost=0.00..1.14 rows=14 width=8) (actual time=0.002..0.129 rows=14 loops=1)

41. 0.000 0.641 ↑ 1.0 14 1

Hash Join (cost=18.47..84.72 rows=14 width=16) (actual time=0.478..0.641 rows=14 loops=1)

  • Hash Cond: (cod_2.model_id = cmd_2.id)
42.          

Initplan (forHash Join)

43. 0.118 0.239 ↑ 1.0 1 1

Hash Join (cost=5.81..12.48 rows=1 width=8) (actual time=0.082..0.239 rows=1 loops=1)

  • Hash Cond: (t_3.id = m_3.terminal_id)
44. 0.104 0.104 ↑ 1.0 193 1

Seq Scan on cq_terminals t_3 (cost=0.00..5.93 rows=193 width=16) (actual time=0.003..0.104 rows=193 loops=1)

45. 0.003 0.017 ↑ 1.0 1 1

Hash (cost=5.80..5.80 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
46. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on cq_machines m_3 (cost=0.00..5.80 rows=1 width=8) (actual time=0.009..0.014 rows=1 loops=1)

  • Filter: (id = 86)
  • Rows Removed by Filter: 143
47. 0.048 0.580 ↑ 1.0 14 1

Nested Loop (cost=4.68..70.74 rows=14 width=16) (actual time=0.433..0.580 rows=14 loops=1)

48. 0.028 0.490 ↑ 1.0 14 1

Nested Loop (cost=4.39..65.36 rows=14 width=8) (actual time=0.424..0.490 rows=14 loops=1)

49. 0.013 0.428 ↑ 1.0 1 1

Nested Loop (cost=0.00..28.88 rows=1 width=8) (actual time=0.392..0.428 rows=1 loops=1)

  • Join Filter: (cl_2.id = me_2.data_class_id)
  • Rows Removed by Join Filter: 2
50. 0.015 0.266 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.19 rows=1 width=8) (actual time=0.262..0.266 rows=1 loops=1)

  • Join Filter: (cmes_2.id = cl_2.message_id)
51. 0.246 0.246 ↑ 1.0 1 1

Seq Scan on cq_messages cmes_2 (cost=0.00..1.01 rows=1 width=8) (actual time=0.246..0.246 rows=1 loops=1)

  • Filter: (version = $9)
52. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on cq_data_class cl_2 (cost=0.00..1.16 rows=1 width=16) (actual time=0.003..0.005 rows=1 loops=1)

  • Filter: ((data_class_no)::text = '0200'::text)
  • Rows Removed by Filter: 12
53. 0.149 0.149 ↓ 1.5 3 1

Seq Scan on cq_message_formats me_2 (cost=0.00..26.67 rows=2 width=16) (actual time=0.021..0.149 rows=3 loops=1)

  • Filter: ((byte_position = 1) AND (bit_position = 5))
  • Rows Removed by Filter: 775
54. 0.023 0.034 ↑ 1.0 14 1

Bitmap Heap Scan on cq_message_format_mappings memp_2 (cost=4.39..36.33 rows=14 width=16) (actual time=0.019..0.034 rows=14 loops=1)

  • Recheck Cond: (message_format_id = me_2.id)
  • Heap Blocks: exact=14
55. 0.011 0.011 ↑ 1.0 14 1

Bitmap Index Scan on cq_message_format_mappings_index03 (cost=0.00..4.39 rows=14 width=0) (actual time=0.011..0.011 rows=14 loops=1)

  • Index Cond: (message_format_id = me_2.id)
56. 0.042 0.042 ↑ 1.0 1 14

Index Scan using cq_operation_data_index01 on cq_operation_data cod_2 (cost=0.29..0.37 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=14)

  • Index Cond: (id = memp_2.operation_data_id)
57. 0.011 0.022 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.022..0.022 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
58. 0.011 0.011 ↑ 1.0 14 1

Seq Scan on cq_models cmd_2 (cost=0.00..1.14 rows=14 width=8) (actual time=0.004..0.011 rows=14 loops=1)

59. 0.000 0.768 ↑ 1.0 14 1

Hash Join (cost=18.47..84.72 rows=14 width=16) (actual time=0.579..0.768 rows=14 loops=1)

  • Hash Cond: (cod_3.model_id = cmd_3.id)
60.          

Initplan (forHash Join)

61. 0.237 0.357 ↑ 1.0 1 1

Hash Join (cost=5.81..12.48 rows=1 width=8) (actual time=0.078..0.357 rows=1 loops=1)

  • Hash Cond: (t_2.id = m_2.terminal_id)
62. 0.106 0.106 ↑ 1.0 193 1

Seq Scan on cq_terminals t_2 (cost=0.00..5.93 rows=193 width=16) (actual time=0.002..0.106 rows=193 loops=1)

63. 0.002 0.014 ↑ 1.0 1 1

Hash (cost=5.80..5.80 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
64. 0.012 0.012 ↑ 1.0 1 1

Seq Scan on cq_machines m_2 (cost=0.00..5.80 rows=1 width=8) (actual time=0.008..0.012 rows=1 loops=1)

  • Filter: (id = 86)
  • Rows Removed by Filter: 143
65. 0.045 0.716 ↑ 1.0 14 1

Nested Loop (cost=4.68..70.74 rows=14 width=16) (actual time=0.545..0.716 rows=14 loops=1)

66. 0.052 0.629 ↑ 1.0 14 1

Nested Loop (cost=4.39..65.36 rows=14 width=8) (actual time=0.538..0.629 rows=14 loops=1)

67. 0.035 0.549 ↑ 1.0 1 1

Nested Loop (cost=0.00..28.88 rows=1 width=8) (actual time=0.514..0.549 rows=1 loops=1)

  • Join Filter: (cl_3.id = me_3.data_class_id)
  • Rows Removed by Join Filter: 2
68. 0.040 0.408 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.19 rows=1 width=8) (actual time=0.404..0.408 rows=1 loops=1)

  • Join Filter: (cmes_3.id = cl_3.message_id)
69. 0.362 0.362 ↑ 1.0 1 1

Seq Scan on cq_messages cmes_3 (cost=0.00..1.01 rows=1 width=8) (actual time=0.362..0.362 rows=1 loops=1)

  • Filter: (version = $6)
70. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on cq_data_class cl_3 (cost=0.00..1.16 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: ((data_class_no)::text = '0200'::text)
  • Rows Removed by Filter: 12
71. 0.106 0.106 ↓ 1.5 3 1

Seq Scan on cq_message_formats me_3 (cost=0.00..26.67 rows=2 width=16) (actual time=0.030..0.106 rows=3 loops=1)

  • Filter: ((byte_position = 1) AND (bit_position = 1))
  • Rows Removed by Filter: 775
72. 0.019 0.028 ↑ 1.0 14 1

Bitmap Heap Scan on cq_message_format_mappings memp_3 (cost=4.39..36.33 rows=14 width=16) (actual time=0.014..0.028 rows=14 loops=1)

  • Recheck Cond: (message_format_id = me_3.id)
  • Heap Blocks: exact=14
73. 0.009 0.009 ↑ 1.0 14 1

Bitmap Index Scan on cq_message_format_mappings_index03 (cost=0.00..4.39 rows=14 width=0) (actual time=0.009..0.009 rows=14 loops=1)

  • Index Cond: (message_format_id = me_3.id)
74. 0.042 0.042 ↑ 1.0 1 14

Index Scan using cq_operation_data_index01 on cq_operation_data cod_3 (cost=0.29..0.37 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=14)

  • Index Cond: (id = memp_3.operation_data_id)
75. 0.009 0.019 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.019..0.019 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
76. 0.010 0.010 ↑ 1.0 14 1

Seq Scan on cq_models cmd_3 (cost=0.00..1.14 rows=14 width=8) (actual time=0.002..0.010 rows=14 loops=1)

77. 0.000 0.574 ↑ 1.0 14 1

Hash Join (cost=18.47..84.72 rows=14 width=16) (actual time=0.392..0.574 rows=14 loops=1)

  • Hash Cond: (cod_4.model_id = cmd_4.id)
78.          

Initplan (forHash Join)

79. 0.118 0.233 ↑ 1.0 1 1

Hash Join (cost=5.81..12.48 rows=1 width=8) (actual time=0.080..0.233 rows=1 loops=1)

  • Hash Cond: (t_1.id = m_1.terminal_id)
80. 0.100 0.100 ↑ 1.0 193 1

Seq Scan on cq_terminals t_1 (cost=0.00..5.93 rows=193 width=16) (actual time=0.002..0.100 rows=193 loops=1)

81. 0.003 0.015 ↑ 1.0 1 1

Hash (cost=5.80..5.80 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
82. 0.012 0.012 ↑ 1.0 1 1

Seq Scan on cq_machines m_1 (cost=0.00..5.80 rows=1 width=8) (actual time=0.008..0.012 rows=1 loops=1)

  • Filter: (id = 86)
  • Rows Removed by Filter: 143
83. 0.058 0.516 ↑ 1.0 14 1

Nested Loop (cost=4.68..70.74 rows=14 width=16) (actual time=0.355..0.516 rows=14 loops=1)

84. 0.027 0.416 ↑ 1.0 14 1

Nested Loop (cost=4.39..65.36 rows=14 width=8) (actual time=0.348..0.416 rows=14 loops=1)

85. 0.012 0.359 ↑ 1.0 1 1

Nested Loop (cost=0.00..28.88 rows=1 width=8) (actual time=0.326..0.359 rows=1 loops=1)

  • Join Filter: (cl_4.id = me_4.data_class_id)
  • Rows Removed by Join Filter: 2
86. 0.012 0.255 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.19 rows=1 width=8) (actual time=0.251..0.255 rows=1 loops=1)

  • Join Filter: (cmes_4.id = cl_4.message_id)
87. 0.239 0.239 ↑ 1.0 1 1

Seq Scan on cq_messages cmes_4 (cost=0.00..1.01 rows=1 width=8) (actual time=0.238..0.239 rows=1 loops=1)

  • Filter: (version = $3)
88. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on cq_data_class cl_4 (cost=0.00..1.16 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=1)

  • Filter: ((data_class_no)::text = '0200'::text)
  • Rows Removed by Filter: 12
89. 0.092 0.092 ↓ 1.5 3 1

Seq Scan on cq_message_formats me_4 (cost=0.00..26.67 rows=2 width=16) (actual time=0.012..0.092 rows=3 loops=1)

  • Filter: ((byte_position = 1) AND (bit_position = 7))
  • Rows Removed by Filter: 775
90. 0.023 0.030 ↑ 1.0 14 1

Bitmap Heap Scan on cq_message_format_mappings memp_4 (cost=4.39..36.33 rows=14 width=16) (actual time=0.013..0.030 rows=14 loops=1)

  • Recheck Cond: (message_format_id = me_4.id)
  • Heap Blocks: exact=14
91. 0.007 0.007 ↑ 1.0 14 1

Bitmap Index Scan on cq_message_format_mappings_index03 (cost=0.00..4.39 rows=14 width=0) (actual time=0.007..0.007 rows=14 loops=1)

  • Index Cond: (message_format_id = me_4.id)
92. 0.042 0.042 ↑ 1.0 1 14

Index Scan using cq_operation_data_index01 on cq_operation_data cod_4 (cost=0.29..0.37 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=14)

  • Index Cond: (id = memp_4.operation_data_id)
93. 0.010 0.020 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.020..0.020 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
94. 0.010 0.010 ↑ 1.0 14 1

Seq Scan on cq_models cmd_4 (cost=0.00..1.14 rows=14 width=8) (actual time=0.002..0.010 rows=14 loops=1)

95. 0.000 0.614 ↑ 1.0 14 1

Hash Join (cost=18.47..84.72 rows=14 width=16) (actual time=0.463..0.614 rows=14 loops=1)

  • Hash Cond: (cod_5.model_id = cmd_5.id)
96.          

Initplan (forHash Join)

97. 0.158 0.278 ↑ 1.0 1 1

Hash Join (cost=5.81..12.48 rows=1 width=8) (actual time=0.093..0.278 rows=1 loops=1)

  • Hash Cond: (t.id = m.terminal_id)
98. 0.105 0.105 ↑ 1.0 193 1

Seq Scan on cq_terminals t (cost=0.00..5.93 rows=193 width=16) (actual time=0.002..0.105 rows=193 loops=1)

99. 0.002 0.015 ↑ 1.0 1 1

Hash (cost=5.80..5.80 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
100. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on cq_machines m (cost=0.00..5.80 rows=1 width=8) (actual time=0.008..0.013 rows=1 loops=1)

  • Filter: (id = 86)
  • Rows Removed by Filter: 143
101. 0.040 0.562 ↑ 1.0 14 1

Nested Loop (cost=4.68..70.74 rows=14 width=16) (actual time=0.427..0.562 rows=14 loops=1)

102. 0.022 0.480 ↑ 1.0 14 1

Nested Loop (cost=4.39..65.36 rows=14 width=8) (actual time=0.418..0.480 rows=14 loops=1)

103. 0.011 0.425 ↑ 1.0 1 1

Nested Loop (cost=0.00..28.88 rows=1 width=8) (actual time=0.390..0.425 rows=1 loops=1)

  • Join Filter: (cl_5.id = me_5.data_class_id)
  • Rows Removed by Join Filter: 2
104. 0.022 0.314 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.19 rows=1 width=8) (actual time=0.311..0.314 rows=1 loops=1)

  • Join Filter: (cmes_5.id = cl_5.message_id)
105. 0.285 0.285 ↑ 1.0 1 1

Seq Scan on cq_messages cmes_5 (cost=0.00..1.01 rows=1 width=8) (actual time=0.284..0.285 rows=1 loops=1)

  • Filter: (version = $0)
106. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on cq_data_class cl_5 (cost=0.00..1.16 rows=1 width=16) (actual time=0.006..0.007 rows=1 loops=1)

  • Filter: ((data_class_no)::text = '0200'::text)
  • Rows Removed by Filter: 12
107. 0.100 0.100 ↓ 1.5 3 1

Seq Scan on cq_message_formats me_5 (cost=0.00..26.67 rows=2 width=16) (actual time=0.021..0.100 rows=3 loops=1)

  • Filter: ((byte_position = 1) AND (bit_position = 6))
  • Rows Removed by Filter: 775
108. 0.020 0.033 ↑ 1.0 14 1

Bitmap Heap Scan on cq_message_format_mappings memp_5 (cost=4.39..36.33 rows=14 width=16) (actual time=0.019..0.033 rows=14 loops=1)

  • Recheck Cond: (message_format_id = me_5.id)
  • Heap Blocks: exact=14
109. 0.013 0.013 ↑ 1.0 14 1

Bitmap Index Scan on cq_message_format_mappings_index03 (cost=0.00..4.39 rows=14 width=0) (actual time=0.013..0.013 rows=14 loops=1)

  • Index Cond: (message_format_id = me_5.id)
110. 0.042 0.042 ↑ 1.0 1 14

Index Scan using cq_operation_data_index01 on cq_operation_data cod_5 (cost=0.29..0.37 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=14)

  • Index Cond: (id = memp_5.operation_data_id)
111. 0.010 0.019 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.019..0.019 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
112. 0.009 0.009 ↑ 1.0 14 1

Seq Scan on cq_models cmd_5 (cost=0.00..1.14 rows=14 width=8) (actual time=0.001..0.009 rows=14 loops=1)