explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VLDb

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

Unique (cost=18.37..18.73 rows=72 width=549) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=18.37..18.55 rows=72 width=549) (actual rows= loops=)

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

Hash Left Join (cost=9.39..16.15 rows=72 width=549) (actual rows= loops=)

  • Hash Cond: (rpi.barcode = (reg.barcode)::text)
  • 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.barcode IS NULL) AND (sc.container_type_id > 0) AND (sc.to_post_index
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=7.76..14.20 rows=72 width=581) (actual rows= loops=)

  • Hash Cond: (ss.container_id = sc.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=6.22..12.46 rows=72 width=581) (actual rows= loops=)

  • Hash Cond: (ra.id = rpi.assignment_id)
6. 0.000 0.000 ↓ 0.0

Merge Join (cost=1.60..6.04 rows=288 width=40) (actual rows= loops=)

  • Merge Cond: (ra.forming_session_id = ss.id)
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

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

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

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

10. 0.000 0.000 ↓ 0.0

Hash (cost=3.72..3.72 rows=72 width=549) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on session_rpi rpi (cost=0.00..3.72 rows=72 width=549) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

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

13. 0.000 0.000 ↓ 0.0

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

14. 0.000 0.000 ↓ 0.0

Hash (cost=1.63..1.63 rows=1 width=14) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on sortmachine_barcode_register reg (cost=0.00..1.63 rows=1 width=14) (actual rows= loops=)

  • Filter: (machine_group_id = 3)