explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uiGd

Settings
# exclusive inclusive rows x rows loops node
1. 8.074 17.643 ↑ 1.0 157 1

Hash Semi Join (cost=154.94..563.13 rows=157 width=408) (actual time=0.863..17.643 rows=157 loops=1)

  • Hash Cond: (college.id = collegesearchable.collegeid)
2. 8.802 8.802 ↑ 1.0 3,599 1

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

3. 0.336 0.767 ↑ 1.0 157 1

Hash (cost=152.98..152.98 rows=157 width=4) (actual time=0.767..0.767 rows=157 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
4. 0.394 0.431 ↑ 1.0 157 1

Bitmap Heap Scan on collegesearchable (cost=9.22..152.98 rows=157 width=4) (actual time=0.050..0.431 rows=157 loops=1)

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

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

  • Index Cond: (searchableuniversity @@ '''technolog'''::tsquery)
Planning time : 0.324 ms
Execution time : 17.988 ms