explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uVUO

Settings
# exclusive inclusive rows x rows loops node
1. 210.661 3,338.249 ↑ 5.5 441,130 1

Nested Loop (cost=91,860.28..94,909.22 rows=2,437,620 width=8) (actual time=703.681..3,338.249 rows=441,130 loops=1)

2.          

CTE message_ids

3. 199.605 199.605 ↓ 1.1 441,128 1

Index Only Scan using test_2 on xact_message (cost=0.43..82,731.20 rows=405,712 width=4) (actual time=0.033..199.605 rows=441,128 loops=1)

  • Index Cond: ((state = 4) AND (templatelanguage_id = ANY ('{17,18,19,20,21,22,23,24}'::integer[])))
  • Heap Fetches: 331201
4. 481.282 921.948 ↓ 2,205.6 441,128 1

HashAggregate (cost=9,128.52..9,130.52 rows=200 width=4) (actual time=703.652..921.948 rows=441,128 loops=1)

  • Group Key: m.m_id
5. 440.666 440.666 ↓ 1.1 441,128 1

CTE Scan on message_ids m (cost=0.00..8,114.24 rows=405,712 width=4) (actual time=0.036..440.666 rows=441,128 loops=1)

6. 2,205.640 2,205.640 ↑ 30.0 1 441,128

Index Only Scan using "Test" on scheduling_flownode f (cost=0.56..14.94 rows=30 width=8) (actual time=0.004..0.005 rows=1 loops=441,128)

  • Index Cond: ((state = 1) AND (root_node = true) AND (target_object_id = m.m_id))
  • Filter: root_node
  • Heap Fetches: 29746
Planning time : 0.317 ms
Execution time : 3,425.455 ms