explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DArO : select count(*) from (select distinct(sender) from events) e;

Settings
# exclusive inclusive rows x rows loops node
1. 12.871 851.800 ↑ 1.0 1 1

Aggregate (cost=46,518.69..46,518.70 rows=1 width=8) (actual time=851.800..851.800 rows=1 loops=1)

  • Buffers: shared hit=30442
2. 604.747 838.929 ↓ 7.1 141,547 1

HashAggregate (cost=46,069.14..46,268.94 rows=19,980 width=27) (actual time=802.041..838.929 rows=141,547 loops=1)

  • Group Key: events.sender
  • Buffers: shared hit=30442
3. 234.182 234.182 ↑ 1.0 1,248,675 1

Seq Scan on events (cost=0.00..42,943.71 rows=1,250,171 width=27) (actual time=0.018..234.182 rows=1,248,675 loops=1)

  • Buffers: shared hit=30442
Planning time : 0.256 ms
Execution time : 852.101 ms