explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IVZq

Settings
# exclusive inclusive rows x rows loops node
1. 9.059 17.134 ↑ 1.0 157 1

Hash Join (cost=154.94..567.00 rows=157 width=676) (actual time=0.763..17.134 rows=157 loops=1)

  • Hash Cond: (b.id = a.collegeid)
2. 7.370 7.370 ↑ 1.0 3,599 1

Seq Scan on college b (cost=0.00..396.99 rows=3,599 width=408) (actual time=0.004..7.370 rows=3,599 loops=1)

3. 0.315 0.705 ↑ 1.0 157 1

Hash (cost=152.98..152.98 rows=157 width=268) (actual time=0.705..0.705 rows=157 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 52kB
4. 0.356 0.390 ↑ 1.0 157 1

Bitmap Heap Scan on collegesearchable a (cost=9.22..152.98 rows=157 width=268) (actual time=0.044..0.390 rows=157 loops=1)

  • Recheck Cond: (searchableuniversity @@ '''technolog'''::tsquery)
  • Heap Blocks: exact=27
5. 0.034 0.034 ↑ 1.0 157 1

Bitmap Index Scan on searchableuniversity_collegesearchable_idx (cost=0.00..9.18 rows=157 width=0) (actual time=0.034..0.034 rows=157 loops=1)

  • Index Cond: (searchableuniversity @@ '''technolog'''::tsquery)
Planning time : 0.269 ms
Execution time : 17.490 ms