explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kC8j

Settings
# exclusive inclusive rows x rows loops node
1. 4.307 19.821 ↑ 1.0 1 1

Aggregate (cost=1,608.26..1,608.27 rows=1 width=8) (actual time=19.821..19.821 rows=1 loops=1)

  • Buffers: shared hit=44036
2. 15.514 15.514 ↓ 1.0 51,833 1

Index Only Scan using twitter_test on users (cost=0.41..1,479.71 rows=51,420 width=0) (actual time=0.023..15.514 rows=51,833 loops=1)

  • Heap Fetches: 1208
  • Buffers: shared hit=44036
Planning time : 0.123 ms
Execution time : 19.848 ms