explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Aiw3

Settings
# exclusive inclusive rows x rows loops node
1. 7,843.983 11,431.731 ↑ 1.0 4,315,780 1

Hash Left Join (cost=31,952.69..494,878.47 rows=4,328,523 width=299) (actual time=405.143..11,431.731 rows=4,315,780 loops=1)

  • Hash Cond: (user_topics.user_id = "user".id)
2. 3,182.749 3,182.749 ↑ 1.0 4,315,780 1

Seq Scan on user_topics (cost=0.00..144,873.23 rows=4,328,523 width=261) (actual time=0.010..3,182.749 rows=4,315,780 loops=1)

3. 110.992 404.999 ↓ 1.0 266,167 1

Hash (cost=26,285.64..26,285.64 rows=266,164 width=46) (actual time=404.998..404.999 rows=266,167 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 2,884kB
4. 294.007 294.007 ↓ 1.0 266,167 1

Seq Scan on users "user" (cost=0.00..26,285.64 rows=266,164 width=46) (actual time=0.006..294.007 rows=266,167 loops=1)

Planning time : 0.245 ms
Execution time : 11,748.839 ms