explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VcSD

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

Unique (cost=28.02..28.38 rows=72 width=549) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=28.02..28.20 rows=72 width=549) (actual rows= loops=)

  • Sort Key: rpi.id
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=7.48..25.80 rows=72 width=549) (actual rows= loops=)

  • Hash Cond: (ss.container_id = sc.id)
  • Join Filter: (((rpi.rpi_type_id = 5) AND (ra.created_at > '2019-09-09 00:00:00+03'::timestamp with time zone) AND (ra.retired_at IS NULL) AND (ra.cell_seal_id IS NULL) AND (reg.rpi_id IS NULL) AND (sc.container_type_id > 0) AND (sc.to_post_i
4. 0.000 0.000 ↓ 0.0

Merge Join (cost=5.94..24.03 rows=72 width=589) (actual rows= loops=)

  • Merge Cond: (ra.forming_session_id = ss.id)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.49..111.35 rows=72 width=589) (actual rows= loops=)

  • Join Filter: (rpi.id = reg.rpi_id)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..89.43 rows=72 width=581) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using idx_rpi_assignment_forming_session_id on rpi_assignment ra (cost=0.15..20.47 rows=288 width=40) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using idx_session_rpi_assignment_id on session_rpi rpi (cost=0.14..0.23 rows=1 width=549) (actual rows= loops=)

  • Index Cond: (assignment_id = ra.id)
9. 0.000 0.000 ↓ 0.0

Materialize (cost=4.20..14.38 rows=7 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sortmachine_item_register reg (cost=4.20..14.34 rows=7 width=8) (actual rows= loops=)

  • Recheck Cond: ((machine_group_id = 3) AND (rpi_id IS NOT NULL))
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uidx_sortmachine_item_register_machine_date_rpi (cost=0.00..4.20 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (machine_group_id = 3)
12. 0.000 0.000 ↓ 0.0

Sort (cost=1.44..1.48 rows=15 width=16) (actual rows= loops=)

  • Sort Key: ss.id
13. 0.000 0.000 ↓ 0.0

Seq Scan on session ss (cost=0.00..1.15 rows=15 width=16) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=1.24..1.24 rows=24 width=16) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on session_container sc (cost=0.00..1.24 rows=24 width=16) (actual rows= loops=)