explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pOah : covid

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.023 ↑ 1.0 1 1

Aggregate (cost=15.31..15.34 rows=1 width=8) (actual time=0.022..0.023 rows=1 loops=1)

  • Buffers: shared hit=3
2. 0.001 0.016 ↓ 0.0 0 1

Unique (cost=15.27..15.27 rows=1 width=37) (actual time=0.016..0.016 rows=0 loops=1)

  • Buffers: shared hit=3
3. 0.003 0.015 ↓ 0.0 0 1

Sort (cost=15.27..15.27 rows=1 width=37) (actual time=0.015..0.015 rows=0 loops=1)

  • Sort Key: res.id_
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
4. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=8.14..15.26 rows=1 width=37) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=3
5. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=7.87..14.93 rows=1 width=96) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=3
6. 0.000 0.011 ↓ 0.0 0 1

Unique (cost=7.47..7.48 rows=1 width=37) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=3
7. 0.002 0.011 ↓ 0.0 0 1

Sort (cost=7.47..7.47 rows=1 width=37) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: ((act_ru_variable.execution_id_)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
8. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using act_idx_var_count_tmp on act_ru_variable (cost=0.41..7.46 rows=1 width=37) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((long_ IS NOT NULL) AND (long_ = '1490335'::bigint) AND (name_ = 'personId'::text) AND (type_ IS NOT NULL) AND (type_ = 'integer'::
  • Heap Fetches: 0
  • Buffers: shared hit=3
9. 0.000 0.000 ↓ 0.0 0

Index Scan using act_ru_execution_pkey on act_ru_execution res (cost=0.41..7.44 rows=1 width=96) (never executed)

  • Index Cond: ((id_)::text = (act_ru_variable.execution_id_)::text)
  • Filter: (suspension_state_ = 1)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using act_re_procdef_pkey on act_re_procdef p (cost=0.27..0.32 rows=1 width=57) (never executed)

  • Index Cond: ((id_)::text = (res.proc_def_id_)::text)
  • Filter: ((key_)::text = 'scheduling_process'::text)
Planning time : 2.215 ms
Execution time : 0.098 ms