explain.depesz.com

PostgreSQL's explain analyze made readable

Result: neU5 : wqer

Settings
# exclusive inclusive rows x rows loops node
1. 3.280 9.268 ↓ 1.2 3,000 1

Hash Join (cost=120.55..383.10 rows=2,600 width=2,443) (actual time=5.218..9.268 rows=3,000 loops=1)

  • Hash Cond: (users.id = (unnest(issue_user_mentions.mentioned_users_ids)))
2. 0.833 0.833 ↑ 1.0 5,112 1

Seq Scan on users (cost=0.00..249.12 rows=5,112 width=2,443) (actual time=0.008..0.833 rows=5,112 loops=1)

3. 1.169 5.155 ↓ 1.2 3,000 1

Hash (cost=88.05..88.05 rows=2,600 width=4) (actual time=5.154..5.155 rows=3,000 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 138kB
4. 2.832 3.986 ↓ 1.2 3,000 1

HashAggregate (cost=29.55..62.05 rows=2,600 width=4) (actual time=3.144..3.986 rows=3,000 loops=1)

  • Group Key: unnest(issue_user_mentions.mentioned_users_ids)
5. 1.122 1.154 ↓ 2.3 8,118 1

ProjectSet (cost=0.42..20.80 rows=3,500 width=4) (actual time=0.018..1.154 rows=8,118 loops=1)

6. 0.032 0.032 ↓ 1.1 40 1

Index Scan using index_issue_user_mentions_on_issue_id on issue_user_mentions (cost=0.42..3.04 rows=35 width=41) (actual time=0.016..0.032 rows=40 loops=1)

  • Index Cond: (issue_id = 3937)
Planning time : 0.437 ms
Execution time : 9.683 ms