explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h7m2

Settings
# exclusive inclusive rows x rows loops node
1. 150.487 90,977.686 ↓ 1.1 441,130 1

Gather (cost=231,903.81..1,889,421.81 rows=385,322 width=8) (actual time=5,650.528..90,977.686 rows=441,130 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,791.421 90,827.199 ↑ 1.1 147,043 3

Hash Join (cost=230,903.81..1,849,889.61 rows=160,551 width=8) (actual time=5,646.518..90,827.199 rows=147,043 loops=3)

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

Parallel Seq Scan on scheduling_flownode f (cost=0.00..1,595,993.60 rows=2,045,028 width=8) (actual time=0.342..83,414.943 rows=1,642,157 loops=3)

  • Filter: (root_node AND (state = 1))
  • Rows Removed by Filter: 12629625
4. 204.682 5,620.835 ↓ 1.0 441,128 3

Hash (cost=223,993.39..223,993.39 rows=421,153 width=4) (actual time=5,620.834..5,620.835 rows=441,128 loops=3)

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

Seq Scan on xact_message m (cost=0.00..223,993.39 rows=421,153 width=4) (actual time=990.690..5,416.153 rows=441,128 loops=3)

  • Filter: ((state = 4) AND (templatelanguage_id = ANY ('{17,18,19,20,21,22,23,24}'::integer[])))
  • Rows Removed by Filter: 4923334
Planning time : 6.992 ms
Execution time : 91,077.821 ms