explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y7Co : select count(distinct sender) from events;

Settings
# exclusive inclusive rows x rows loops node
1. 1,648.104 2,031.004 ↑ 1.0 1 1

Aggregate (cost=46,069.14..46,069.15 rows=1 width=8) (actual time=2,031.004..2,031.004 rows=1 loops=1)

  • Buffers: shared hit=30442, temp read=4752 written=4753
2. 382.900 382.900 ↑ 1.0 1,248,677 1

Seq Scan on events (cost=0.00..42,943.71 rows=1,250,171 width=27) (actual time=0.016..382.900 rows=1,248,677 loops=1)

  • Buffers: shared hit=30442
Planning time : 0.090 ms
Execution time : 2,031.070 ms