explain.depesz.com

PostgreSQL's explain analyze made readable

Result: libU : 12132

Settings
# exclusive inclusive rows x rows loops node
1. 3.238 6.647 ↓ 21.3 4,870 1

Merge Join (cost=16.70..20.96 rows=229 width=2,443) (actual time=2.106..6.647 rows=4,870 loops=1)

  • Merge Cond: (users.id = issue_user_mentions.mentioned_user_id)
2. 0.952 0.952 ↑ 1.7 3,001 1

Index Scan using users_pkey on users (cost=0.28..290.96 rows=5,112 width=2,443) (actual time=0.006..0.952 rows=3,001 loops=1)

3. 1.491 2.457 ↓ 21.3 4,871 1

Sort (cost=16.41..16.99 rows=229 width=4) (actual time=2.091..2.457 rows=4,871 loops=1)

  • Sort Key: issue_user_mentions.mentioned_user_id
  • Sort Method: quicksort Memory: 423kB
4. 0.966 0.966 ↓ 21.5 4,928 1

Index Scan using index_issue_user_mentions_on_issue_id on issue_user_mentions (cost=0.43..7.44 rows=229 width=4) (actual time=0.007..0.966 rows=4,928 loops=1)

  • Index Cond: (issue_id = 3937)
Planning time : 13.102 ms
Execution time : 7.027 ms