explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YHtp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 26,184.399 ↓ 1.1 19 1

Group (cost=489,147.71..489,152 rows=18 width=4) (actual time=26,184.355..26,184.399 rows=19 loops=1)

  • Buffers: shared hit=59 read=138159
2. 0.000 26,187.691 ↓ 1.5 55 1

Gather Merge (cost=489,147.71..489,151.91 rows=36 width=4) (actual time=26,184.352..26,187.691 rows=55 loops=1)

  • Buffers: shared hit=147 read=432889
3. 0.120 78,533.442 ↑ 1.0 18 3

Sort (cost=488,147.68..488,147.73 rows=18 width=4) (actual time=26,177.806..26,177.814 rows=18 loops=3)

  • Sort Key: fact_contract_view.client_sk
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=147 read=432889
4. 2,810.067 78,533.322 ↑ 1.0 18 3

Aggregate (cost=488,147.13..488,147.31 rows=18 width=4) (actual time=26,177.769..26,177.774 rows=18 loops=3)

  • Buffers: shared hit=129 read=432889
5. 75,723.255 75,723.255 ↑ 1.2 3,528,499 3

Seq Scan on fact_contract_view fact_contract_view (cost=0..477,121.3 rows=4,410,330 width=4) (actual time=6.416..25,241.085 rows=3,528,499 loops=3)

  • Buffers: shared hit=129 read=432889