explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ggBk

Settings
# exclusive inclusive rows x rows loops node
1. 206.306 258,741.930 ↓ 1.2 441,130 1

Gather (cost=252,781.83..1,710,829.20 rows=368,712 width=8) (actual time=10,871.593..258,741.930 rows=441,130 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,984.908 258,535.624 ↑ 1.0 147,043 3

Hash Join (cost=251,781.83..1,672,958.00 rows=153,630 width=8) (actual time=12,809.622..258,535.624 rows=147,043 loops=3)

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

Parallel Bitmap Heap Scan on scheduling_flownode f (cost=122,575.79..1,520,964.67 rows=2,031,350 width=8) (actual time=546.104..255,898.896 rows=1,642,157 loops=3)

  • Recheck Cond: (state = 1)
  • Rows Removed by Index Recheck: 44
  • Filter: root_node
  • Rows Removed by Filter: 12406874
  • Heap Blocks: exact=10601 lossy=425970
4. 559.745 559.745 ↓ 1.0 4,926,472 1

Bitmap Index Scan on "root-nodeand state" (cost=0.00..121,356.98 rows=4,875,241 width=0) (actual time=559.745..559.745 rows=4,926,472 loops=1)

  • Index Cond: ((root_node = true) AND (state = 1))
5. 256.784 651.820 ↓ 1.1 441,128 3

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

  • Buckets: 131072 Batches: 8 Memory Usage: 2966kB
6. 361.988 395.036 ↓ 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=35.536..395.036 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
7. 33.048 33.048 ↓ 1.0 441,132 3

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

  • Index Cond: (state = 4)
Planning time : 16.440 ms
Execution time : 258,848.819 ms