explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LtUh

Settings
# exclusive inclusive rows x rows loops node
1. 191.482 12,208.212 ↓ 1.2 441,130 1

Gather (cost=130,206.61..1,455,333.58 rows=368,712 width=8) (actual time=10,923.308..12,208.212 rows=441,130 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,291.195 12,016.730 ↑ 1.0 147,043 3

Hash Join (cost=129,206.61..1,417,462.38 rows=153,630 width=8) (actual time=10,912.392..12,016.730 rows=147,043 loops=3)

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

Parallel Index Only Scan using test on scheduling_flownode f (cost=0.56..1,265,469.04 rows=2,031,350 width=8) (actual time=0.037..1,723.753 rows=1,642,157 loops=3)

  • Index Cond: ((state = 1) AND (root_node = true))
  • Filter: root_node
  • Heap Fetches: 322171
4. 206.948 9,001.782 ↓ 1.1 441,128 3

Hash (cost=122,549.64..122,549.64 rows=405,712 width=4) (actual time=9,001.782..9,001.782 rows=441,128 loops=3)

  • Buckets: 131072 Batches: 8 Memory Usage: 2966kB
5. 8,768.805 8,794.834 ↓ 1.1 441,128 3

Bitmap Heap Scan on xact_message m (cost=9,765.56..122,549.64 rows=405,712 width=4) (actual time=28.690..8,794.834 rows=441,128 loops=3)

  • Recheck Cond: (state = 4)
  • Filter: (templatelanguage_id = ANY ('{17,18,19,20,21,22,23,24}'::integer[]))
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=16585
6. 26.029 26.029 ↓ 1.0 441,132 3

Bitmap Index Scan on test_2 (cost=0.00..9,664.13 rows=421,826 width=0) (actual time=26.029..26.029 rows=441,132 loops=3)

  • Index Cond: (state = 4)
Planning time : 1.034 ms
Execution time : 12,333.734 ms