explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dep0

Settings
# exclusive inclusive rows x rows loops node
1. 0.578 1,168.364 ↓ 2.3 14 1

HashAggregate (cost=154,964.72..154,964.78 rows=6 width=20) (actual time=1,168.360..1,168.364 rows=14 loops=1)

  • Group Key: workflow_fibers.step_id, workflow_fibers.status
2. 0.804 1,167.786 ↓ 2.6 994 1

Hash Join (cost=85.26..154,961.90 rows=376 width=20) (actual time=2.864..1,167.786 rows=994 loops=1)

  • Hash Cond: (workflow_fibers.step_id = new_workflow_steps.id)
3. 1,166.621 1,166.621 ↑ 3.1 994 1

Seq Scan on workflow_fibers (cost=0.00..154,864.92 rows=3,067 width=20) (actual time=2.483..1,166.621 rows=994 loops=1)

  • Filter: (call_path ~ '*.R9094.C9116.R1223.*'::lquery)
  • Rows Removed by Filter: 3064795
4. 0.037 0.361 ↓ 1.0 72 1

Hash (cost=84.38..84.38 rows=70 width=8) (actual time=0.361..0.361 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
5. 0.324 0.324 ↓ 1.0 72 1

Index Scan using index_new_workflow_steps_on_workflow_id on new_workflow_steps (cost=0.29..84.38 rows=70 width=8) (actual time=0.039..0.324 rows=72 loops=1)

  • Index Cond: (workflow_id = 45)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 18
Planning time : 1.584 ms
Execution time : 1,168.415 ms