explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hgTC : covid

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 1,083.169 ↑ 1.0 1 1

Aggregate (cost=34,187.42..34,187.45 rows=1 width=8) (actual time=1,083.169..1,083.169 rows=1 loops=1)

  • Buffers: shared hit=970,202 read=50,529 dirtied=2 written=210
  • I/O Timings: read=577.824 write=3.053
2. 0.000 1,083.161 ↓ 0.0 0 1

Unique (cost=34,187.38..34,187.39 rows=1 width=37) (actual time=1,083.161..1,083.161 rows=0 loops=1)

  • Buffers: shared hit=970,202 read=50,529 dirtied=2 written=210
  • I/O Timings: read=577.824 write=3.053
3. 0.000 1,083.161 ↓ 0.0 0 1

Sort (cost=34,187.38..34,187.39 rows=1 width=37) (actual time=1,083.160..1,083.161 rows=0 loops=1)

  • Sort Key: res.id_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=970,202 read=50,529 dirtied=2 written=210
  • I/O Timings: read=577.824 write=3.053
4. 18.580 1,096.735 ↓ 0.0 0 1

Gather (cost=1,010.92..34,187.37 rows=1 width=37) (actual time=1,083.131..1,096.735 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=970,199 read=50,529 dirtied=2 written=210
  • I/O Timings: read=577.824 write=3.053
5. 36.864 1,078.155 ↓ 0.0 0 3 / 3

Nested Loop Semi Join (cost=10.92..33,187.27 rows=1 width=37) (actual time=1,078.155..1,078.155 rows=0 loops=3)

  • Buffers: shared hit=970,199 read=50,529 dirtied=2 written=210
  • I/O Timings: read=577.824 write=3.053
6. 23.505 84.715 ↓ 9.5 79,715 3 / 3

Hash Join (cost=10.49..15,909.73 rows=8,370 width=37) (actual time=0.195..84.715 rows=79,715 loops=3)

  • Hash Cond: ((res.proc_def_id_)::text = (p.id_)::text)
  • Buffers: shared hit=87 read=12,343 written=31
  • I/O Timings: read=96.604 write=0.464
7. 61.138 61.138 ↑ 1.2 80,439 3 / 3

Parallel Seq Scan on act_ru_execution res (cost=0.00..15,615.52 rows=100,447 width=96) (actual time=0.033..61.138 rows=80,439 loops=3)

  • Filter: (suspension_state_ = 1)
  • Buffers: shared hit=8 read=12,343 written=31
  • I/O Timings: read=96.604 write=0.464
8. 0.010 0.072 ↑ 1.0 13 3 / 3

Hash (cost=10.07..10.07 rows=13 width=57) (actual time=0.071..0.072 rows=13 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=15
9. 0.062 0.062 ↑ 1.0 13 3 / 3

Seq Scan on act_re_procdef p (cost=0.00..10.07 rows=13 width=57) (actual time=0.017..0.062 rows=13 loops=3)

  • Filter: ((key_)::text = 'scheduling_process'::text)
  • Rows Removed by Filter: 143
  • Buffers: shared hit=15
10. 956.576 956.576 ↓ 0.0 0 239,144 / 3

Index Scan using act_idx_var_exe on act_ru_variable (cost=0.42..2.06 rows=1 width=37) (actual time=0.012..0.012 rows=0 loops=239,144)

  • Index Cond: ((execution_id_)::text = (res.id_)::text)
  • Filter: ((type_ IS NOT NULL) AND (long_ IS NOT NULL) AND ((name_)::text = 'personId'::text) AND ((type_)::text = 'integer'::text) AND (long_ = '1490335'::bi
  • Rows Removed by Filter: 3
  • Buffers: shared hit=970,112 read=38,186 dirtied=2 written=179
  • I/O Timings: read=481.220 write=2.588
Planning time : 3.107 ms
Execution time : 1,097.055 ms