explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v7Pb

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

Sort (cost=2,373.52..2,382.60 rows=3,631 width=214) (actual rows= loops=)

  • Sort Key: plates.set_label, plates.plate_number
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2,036.27..2,158.82 rows=3,631 width=214) (actual rows= loops=)

  • Hash Cond: (plates_1.id = plates.id)
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,852.58..1,888.89 rows=3,631 width=12) (actual rows= loops=)

  • Group Key: plates_1.id
4. 0.000 0.000 ↓ 0.0

Merge Join (cost=706.03..1,628.76 rows=44,763 width=4) (actual rows= loops=)

  • Merge Cond: (((plates_1.set_label)::text = (sibling.set_label)::text) AND (plates_1.plate_number = sibling.plate_number))
  • Join Filter: (plates_1.id <> sibling.id)
5. 0.000 0.000 ↓ 0.0

Sort (cost=353.01..362.09 rows=3,631 width=35) (actual rows= loops=)

  • Sort Key: plates_1.set_label, plates_1.plate_number
6. 0.000 0.000 ↓ 0.0

Seq Scan on plates plates_1 (cost=0.00..138.31 rows=3,631 width=35) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=353.01..362.09 rows=3,631 width=35) (actual rows= loops=)

  • Sort Key: sibling.set_label, sibling.plate_number
8. 0.000 0.000 ↓ 0.0

Seq Scan on plates sibling (cost=0.00..138.31 rows=3,631 width=35) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=138.31..138.31 rows=3,631 width=206) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on plates (cost=0.00..138.31 rows=3,631 width=206) (actual rows= loops=)