explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WM9a

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 762.942 ↑ 1.0 100 1

Limit (cost=132,069.97..132,070.22 rows=100 width=151) (actual time=762.934..762.942 rows=100 loops=1)

2. 113.782 762.937 ↑ 7,163.0 100 1

Sort (cost=132,069.97..133,860.71 rows=716,296 width=151) (actual time=762.934..762.937 rows=100 loops=1)

  • Sort Key: "chefclub-users_authenticationmethod".modified DESC, "chefclub-users_authenticationmethod".id DESC
  • Sort Method: top-N heapsort Memory: 64kB
3. 200.003 649.155 ↓ 1.0 716,396 1

Merge Join (cost=1.75..104,693.65 rows=716,296 width=151) (actual time=0.008..649.155 rows=716,396 loops=1)

  • Merge Cond: ("chefclub-users_authenticationmethod".user_id = "chefclub-users_user".id)
4. 157.151 157.151 ↑ 1.0 716,702 1

Index Scan using "chefclub-users_authenticationmethod_user_id_b557e19e" on "chefclub-users_authenticationmethod" (cost=0.42..36,904.96 rows=716,702 width=151) (actual time=0.004..157.151 rows=716,702 loops=1)

5. 292.001 292.001 ↓ 1.0 715,792 1

Index Scan using "chefclub-users_user_pkey" on "chefclub-users_user" (cost=0.42..57,047.22 rows=715,691 width=8) (actual time=0.003..292.001 rows=715,792 loops=1)

  • Filter: (NOT marked_as_deleted)
  • Rows Removed by Filter: 305
Planning time : 0.213 ms
Execution time : 762.965 ms