explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JodB

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.999 ↑ 7.3 3 1

Unique (cost=59.15..59.37 rows=22 width=763) (actual time=0.992..0.999 rows=3 loops=1)

2. 0.247 0.991 ↑ 7.3 3 1

Sort (cost=59.15..59.20 rows=22 width=763) (actual time=0.990..0.991 rows=3 loops=1)

  • Sort Key: v."guideId", v.version, ((v.rev = g.id)), v.rev DESC
  • Sort Method: quicksort Memory: 29kB
3. 0.046 0.744 ↑ 7.3 3 1

Hash Join (cost=5.00..58.66 rows=22 width=763) (actual time=0.200..0.744 rows=3 loops=1)

  • Hash Cond: (v."createdBy" = u.id)
4. 0.084 0.594 ↑ 7.3 3 1

Hash Join (cost=1.15..54.62 rows=22 width=710) (actual time=0.065..0.594 rows=3 loops=1)

  • Hash Cond: (v."guideId" = g.id)
5. 0.470 0.470 ↓ 1.2 133 1

Seq Scan on "GuideVersion" v (cost=0.00..53.08 rows=108 width=620) (actual time=0.012..0.470 rows=133 loops=1)

6. 0.016 0.040 ↑ 1.0 2 1

Hash (cost=1.12..1.12 rows=2 width=90) (actual time=0.040..0.040 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.024 0.024 ↑ 1.0 2 1

Seq Scan on "Guide" g (cost=0.00..1.12 rows=2 width=90) (actual time=0.017..0.024 rows=2 loops=1)

  • Filter: ("companyId" = 1)
  • Rows Removed by Filter: 12
8. 0.038 0.104 ↑ 1.1 35 1

Hash (cost=3.38..3.38 rows=38 width=20) (actual time=0.104..0.104 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.066 0.066 ↑ 1.1 35 1

Seq Scan on "User" u (cost=0.00..3.38 rows=38 width=20) (actual time=0.011..0.066 rows=35 loops=1)

Planning time : 0.879 ms
Execution time : 1.200 ms