explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uiRBv : cc1

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

Group (cost=11,062.26..11,063.12 rows=49 width=1,025) (actual rows= loops=)

  • Group Key: b.id, bs.version, bs.spec, s.spec, s.error, s.phase
2. 0.000 0.000 ↓ 0.0

Sort (cost=11,062.26..11,062.39 rows=49 width=1,025) (actual rows= loops=)

  • Sort Key: b.id, bs.version, bs.spec, s.spec, s.error, s.phase
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,503.51..11,060.89 rows=49 width=1,025) (actual rows= loops=)

  • Join Filter: (((s.phase)::text = 'ERROR'::text) OR (b.updated_at >= '2020-01-30 16:13:33.775456+00'::timestamp with time zone))
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,503.09..9,233.16 rows=1,619 width=482) (actual rows= loops=)

  • Hash Cond: (bs.binding_id = b.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on binding_specs bs (cost=0.00..3,520.27 rows=51,627 width=370) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=5,481.81..5,481.81 rows=1,703 width=112) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on bindings b (cost=84.97..5,481.81 rows=1,703 width=112) (actual rows= loops=)

  • Recheck Cond: (deleted_at IS NULL)
  • Filter: (provisioner_id = '029e716c-e32f-49cc-b308-d160fda44406'::uuid)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on bindings_deleted_at (cost=0.00..84.54 rows=2,700 width=0) (actual rows= loops=)

  • Index Cond: (deleted_at IS NULL)
9. 0.000 0.000 ↓ 0.0

Index Scan using binding_statuses_binding_id_key on binding_statuses s (cost=0.41..1.11 rows=1 width=575) (actual rows= loops=)

  • Index Cond: (binding_id = bs.binding_id)