explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cRuq

Settings
# exclusive inclusive rows x rows loops node
1. 613.589 879.849 ↑ 1.0 1,000,000 1

Sort (cost=140,907.84..143,407.84 rows=1,000,000 width=219) (actual time=719.208..879.849 rows=1,000,000 loops=1)

  • Sort Key: userid
  • Sort Method: quicksort Memory: 290202kB
2. 266.260 266.260 ↑ 1.0 1,000,000 1

Seq Scan on users (cost=0.00..41,250.00 rows=1,000,000 width=219) (actual time=0.039..266.260 rows=1,000,000 loops=1)

Planning time : 0.079 ms
Execution time : 966.795 ms