explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yEtC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 55.024 ↑ 1.0 1 1

Limit (cost=72.32..88.38 rows=1 width=603) (actual time=55.012..55.024 rows=1 loops=1)

2.          

CTE point_id

3. 0.017 0.249 ↑ 1.0 1 1

Nested Loop (cost=10.48..71.60 rows=1 width=8) (actual time=0.175..0.249 rows=1 loops=1)

4.          

Initplan (forNested Loop)

5. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on cq_machines m (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
6. 0.019 0.158 ↑ 1.0 14 1

Nested Loop (cost=4.39..60.38 rows=14 width=8) (actual time=0.078..0.158 rows=14 loops=1)

7. 0.010 0.116 ↑ 1.0 1 1

Nested Loop (cost=0.00..25.93 rows=1 width=8) (actual time=0.061..0.116 rows=1 loops=1)

  • Join Filter: (dc.id = mf.data_class_id)
  • Rows Removed by Join Filter: 2
8. 0.005 0.005 ↑ 1.0 1 1

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

  • Filter: ((data_class_no)::text = '1200'::text)
  • Rows Removed by Filter: 12
9. 0.101 0.101 ↑ 1.0 3 1

Seq Scan on cq_message_formats mf (cost=0.00..24.73 rows=3 width=16) (actual time=0.004..0.101 rows=3 loops=1)

  • Filter: ((data_type)::text = 'POINT'::text)
  • Rows Removed by Filter: 775
10. 0.017 0.023 ↑ 1.0 14 1

Bitmap Heap Scan on cq_message_format_mappings mfm (cost=4.39..34.32 rows=14 width=16) (actual time=0.010..0.023 rows=14 loops=1)

  • Recheck Cond: (message_format_id = mf.id)
  • Heap Blocks: exact=4
11. 0.006 0.006 ↑ 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.006..0.006 rows=14 loops=1)

  • Index Cond: (message_format_id = mf.id)
12. 0.056 0.056 ↓ 0.0 0 14

Index Scan using cq_operation_data_index01 on cq_operation_data op (cost=0.29..0.38 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=14)

  • Index Cond: (id = mfm.operation_data_id)
  • Filter: (model_id = $0)
  • Rows Removed by Filter: 1
13.          

Initplan (forLimit)

14. 0.252 0.252 ↑ 1.0 1 1

CTE Scan on point_id (cost=0.00..0.02 rows=1 width=8) (actual time=0.177..0.252 rows=1 loops=1)

15. 0.012 55.019 ↑ 1.0 1 1

Nested Loop (cost=0.70..16.75 rows=1 width=603) (actual time=55.009..55.019 rows=1 loops=1)

16. 0.325 0.325 ↑ 1.0 1 1

Index Scan using cq_operation_data_history_index02 on cq_operation_data_history codh (cost=0.42..8.44 rows=1 width=603) (actual time=0.322..0.325 rows=1 loops=1)

  • Index Cond: ((machine_id = 86) AND (acquisition_time = '2019-03-16 11:04:58+09'::timestamp with time zone) AND (operation_data_id = $4))
17. 54.682 54.682 ↑ 1.0 1 1

Index Only Scan using cq_movement_history_index01 on cq_movement_history cmh (cost=0.28..8.30 rows=1 width=8) (actual time=54.677..54.682 rows=1 loops=1)

  • Index Cond: ((id = codh.id) AND (language_code = 'ja'::text))
  • Heap Fetches: 1
Planning time : 0.956 ms
Execution time : 55.147 ms