explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yvE3

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

Hash Anti Join (cost=31.60..67.30 rows=800 width=57) (actual rows= loops=)

  • Hash Cond: (p1."projectRevisionId" = p2."projectRevisionId")
  • Join Filter: (p1."createdAt" < p2."createdAt")
2. 0.000 0.000 ↓ 0.0

Seq Scan on "projectQualifications" p1 (cost=0.00..19.60 rows=960 width=57) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=19.60..19.60 rows=960 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on "projectQualifications" p2 (cost=0.00..19.60 rows=960 width=12) (actual rows= loops=)