explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QeH2

Settings
# exclusive inclusive rows x rows loops node
1. 189.086 2,894.446 ↓ 1.2 441,130 1

Gather (cost=22,594.06..247,318.56 rows=382,714 width=8) (actual time=1,506.579..2,894.446 rows=441,130 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,294.106 2,705.360 ↑ 1.1 147,043 3

Hash Join (cost=21,594.06..208,047.16 rows=159,464 width=8) (actual time=1,564.085..2,705.360 rows=147,043 loops=3)

  • Hash Cond: (f.target_object_id = m.id)
3. 919.173 919.173 ↑ 1.2 1,642,157 3

Parallel Index Only Scan using "Test" on scheduling_flownode f (cost=0.56..163,576.15 rows=2,034,105 width=8) (actual time=0.024..919.173 rows=1,642,157 loops=3)

  • Index Cond: ((state = 1) AND (root_node = true))
  • Filter: root_node
  • Heap Fetches: 0
4. 258.827 492.081 ↓ 1.0 441,128 3

Hash (cost=14,681.34..14,681.34 rows=421,292 width=4) (actual time=492.080..492.081 rows=441,128 loops=3)

  • Buckets: 131072 Batches: 8 Memory Usage: 2966kB
5. 233.254 233.254 ↓ 1.0 441,128 3

Index Only Scan using test_2 on xact_message m (cost=0.43..14,681.34 rows=421,292 width=4) (actual time=0.040..233.254 rows=441,128 loops=3)

  • Index Cond: ((state = 4) AND (templatelanguage_id = ANY ('{17,18,19,20,21,22,23,24}'::integer[])))
  • Heap Fetches: 0
Planning time : 1.193 ms
Execution time : 3,011.161 ms