explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Btla : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #Ubpe; plan #Bs5n; plan #lhL5; plan #AB8; plan #s9uh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.010 0.115 ↑ 1.0 2 1

Sort (cost=11.5..11.51 rows=2 width=137) (actual time=0.115..0.115 rows=2 loops=1)

  • Sort Key: sp.id
  • Sort Method: quicksort Memory: 25kB
2. 0.025 0.105 ↑ 1.0 2 1

Hash Join (cost=8.68..11.49 rows=2 width=137) (actual time=0.103..0.105 rows=2 loops=1)

3. 0.018 0.018 ↓ 1.0 89 1

Seq Scan on org_memberships om (cost=0..1.88 rows=88 width=16) (actual time=0.006..0.018 rows=89 loops=1)

4. 0.003 0.062 ↑ 1.0 2 1

Hash (cost=8.65..8.65 rows=2 width=160) (actual time=0.062..0.062 rows=2 loops=1)

5. 0.002 0.059 ↑ 1.0 2 1

Nested Loop (cost=1.17..8.65 rows=2 width=160) (actual time=0.043..0.059 rows=2 loops=1)

6. 0.002 0.041 ↑ 1.0 2 1

Nested Loop (cost=0..6.25 rows=2 width=156) (actual time=0.031..0.041 rows=2 loops=1)

7. 0.013 0.013 ↑ 1.0 2 1

Seq Scan on step_participations sp (cost=0..1.16 rows=2 width=115) (actual time=0.011..0.013 rows=2 loops=1)

  • Filter: ((type)::text = 'StepParticipations::TodoParticipation'::text)
8. 0.006 0.026 ↑ 1.0 1 2

Aggregate (cost=0..2.52 rows=1 width=45) (actual time=0.013..0.013 rows=1 loops=2)

9. 0.006 0.020 ↓ 2.0 2 2

Nested Loop (cost=0..2.51 rows=1 width=41) (actual time=0.008..0.01 rows=2 loops=2)

10. 0.010 0.010 ↑ 1.0 1 2

Seq Scan on step_definitions sd (cost=0..1.25 rows=1 width=37) (actual time=0.004..0.005 rows=1 loops=2)

  • Filter: (id = sp.step_definition_id)
11. 0.004 0.004 ↓ 2.0 2 2

Seq Scan on step_definitions sdc (cost=0..1.25 rows=1 width=8) (actual time=0.002..0.002 rows=2 loops=2)

  • Filter: (parent_step_id = sp.step_definition_id)
12. 0.006 0.016 ↑ 1.0 1 2

Aggregate (cost=1.17..1.18 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=2)

13. 0.002 0.010 ↓ 2.0 2 2

Result (cost=0..1.16 rows=1 width=12) (actual time=0.004..0.005 rows=2 loops=2)

14. 0.008 0.008 ↓ 2.0 2 2

Seq Scan on step_participations spc (cost=0..1.16 rows=1 width=8) (actual time=0.004..0.004 rows=2 loops=2)

  • Filter: ((completed_at IS NOT NULL) AND (deleted_at IS NULL) AND (participant_id IS NOT NULL) AND (sp.id = activated_participation_id))
Planning time : 0.616 ms
Execution time : 0.19 ms