explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3sOb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 460.130 118,978.756 ↑ 2.3 97,000 1

Unique (cost=696,297.48..718,290.57 rows=219,931 width=319) (actual time=112,312.016..118,978.756 rows=97,000 loops=1)

  • Buffers: shared hit=62488, temp read=2567532 written=2567543
2. 109,579.894 118,518.626 ↓ 1.0 2,199,346 1

Sort (cost=696,297.48..701,795.75 rows=2,199,309 width=319) (actual time=112,312.014..118,518.626 rows=2,199,346 loops=1)

  • Sort Key: type, provider_id, id_session
  • Sort Method: external merge Disk: 20540256kB
  • Buffers: shared hit=62488, temp read=2567532 written=2567543
3. 6,929.603 8,938.732 ↓ 1.0 2,199,346 1

WindowAgg (cost=316,162.11..464,615.46 rows=2,199,309 width=319) (actual time=1,872.059..8,938.732 rows=2,199,346 loops=1)

  • Buffers: shared hit=62487
4. 1,368.862 2,009.129 ↓ 1.0 2,199,346 1

Sort (cost=316,162.11..321,660.38 rows=2,199,309 width=183) (actual time=1,872.036..2,009.129 rows=2,199,346 loops=1)

  • Sort Key: type, provider, provider_id, id_session, updated_at_end
  • Sort Method: quicksort Memory: 682428kB
  • Buffers: shared hit=62487
5. 640.267 640.267 ↓ 1.0 2,199,346 1

Seq Scan on paris_tab_03 (cost=0.00..84,480.09 rows=2,199,309 width=183) (actual time=0.006..640.267 rows=2,199,346 loops=1)