explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ggre

Settings
# exclusive inclusive rows x rows loops node
1. 80.133 16,641.065 ↑ 1.0 1 1

Aggregate (cost=278,322.43..278,322.44 rows=1 width=8) (actual time=16,641.065..16,641.065 rows=1 loops=1)

  • Buffers: shared hit=1 read=129196
2. 16,503.338 16,560.932 ↓ 1.0 205,473 1

Bitmap Heap Scan on tweets (cost=1,880.58..277,819.01 rows=201,365 width=0) (actual time=86.709..16,560.932 rows=205,473 loops=1)

  • Recheck Cond: (to_tsvector('english'::regconfig, text) @@ '''love'''::tsquery)
  • Heap Blocks: exact=129147
  • Buffers: shared hit=1 read=129196
3. 57.594 57.594 ↓ 1.0 205,473 1

Bitmap Index Scan on idx_tweets_txt (cost=0.00..1,830.24 rows=201,365 width=0) (actual time=57.594..57.594 rows=205,473 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, text) @@ '''love'''::tsquery)
  • Buffers: shared hit=1 read=49