explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ehra

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on plan_step psu (cost=926.87..67,305.25 rows=2,183 width=311) (actual rows= loops=)

2.          

Initplan (for Update)

3. 0.000 0.000 ↓ 0.0

Limit (cost=926.78..926.87 rows=1 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

LockRows (cost=926.78..971.98 rows=489 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Subquery Scan on ps1 (cost=926.78..967.09 rows=489 width=40) (actual rows= loops=)

  • Filter: pg_try_advisory_xact_lock(240723, (ps1."order")::integer)
6. 0.000 0.000 ↓ 0.0

LockRows (cost=926.78..945.10 rows=1,466 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=926.78..930.44 rows=1,466 width=20) (actual rows= loops=)

  • Sort Key: ps2."order
8. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=0.43..849.68 rows=1,466 width=20) (actual rows= loops=)

  • Join Filter: (psr.step_id = ps2.id)
9. 0.000 0.000 ↓ 0.0

Index Scan using plan_step_plan_id_de798ef0 on plan_step ps2 (cost=0.43..654.26 rows=1,466 width=18) (actual rows= loops=)

  • Index Cond: (plan_id = 240723)
  • Filter: ((status)::text = 'Q'::text)
10. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..173.43 rows=1 width=10) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on plan_stepresult psr (cost=0.00..173.43 rows=1 width=10) (actual rows= loops=)

  • Filter: ((node_name)::text = 'b14b50f0-0519-42e6-8e0b-13cb2659a678'::text)
12. 0.000 0.000 ↓ 0.0

Seq Scan on plan_step psu (cost=0.00..66,378.38 rows=2,183 width=311) (actual rows= loops=)

  • Filter: ("order" = $2)