explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eb9v

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

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

2.          

CTE message_ids

3. 524.086 524.086 ↓ 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=4.351..524.086 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. 487.222 1,255.244 ↓ 2,205.6 441,128 1

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

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

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

6. 1,764.512 1,764.512 ↑ 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.004 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.328 ms
Execution time : 3,672.944 ms