explain.depesz.com

PostgreSQL's explain analyze made readable

Result: axSZ

Settings
# exclusive inclusive rows x rows loops node
1. 2,647.812 44,249.915 ↑ 1.9 3,107,590 1

WindowAgg (cost=1,398,233.93..1,557,072.61 rows=5,775,952 width=112) (actual time=36,152.936..44,249.915 rows=3,107,590 loops=1)

2. 40,660.828 41,602.103 ↑ 1.9 3,107,590 1

Sort (cost=1,398,233.93..1,412,673.81 rows=5,775,952 width=96) (actual time=36,152.881..41,602.103 rows=3,107,590 loops=1)

  • Sort Key: parentid, systemmodstamp DESC
  • Sort Method: external merge Disk: 317,504kB
3. 941.275 941.275 ↑ 1.9 3,107,590 1

Seq Scan on sfdc_email_msg (cost=0.00..157,284.52 rows=5,775,952 width=96) (actual time=0.023..941.275 rows=3,107,590 loops=1)

Planning time : 0.229 ms
Execution time : 44,472.868 ms