explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8HV6

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.346 ↑ 1.0 10 1

Limit (cost=47.86..47.89 rows=10 width=349) (actual time=0.344..0.346 rows=10 loops=1)

2. 0.091 0.345 ↑ 9.7 10 1

Sort (cost=47.86..48.10 rows=97 width=349) (actual time=0.344..0.345 rows=10 loops=1)

  • Sort Key: uipriority.prioritisedscore DESC
  • Sort Method: top-N heapsort Memory: 30kB
3. 0.026 0.254 ↑ 1.0 97 1

Hash Join (cost=31.27..45.77 rows=97 width=349) (actual time=0.133..0.254 rows=97 loops=1)

  • Hash Cond: (insights.sourcetypeid = st.sourcetypeid)
4. 0.047 0.223 ↑ 1.0 97 1

Hash Join (cost=9.57..22.73 rows=97 width=317) (actual time=0.121..0.223 rows=97 loops=1)

  • Hash Cond: (insights.categoryid = categories.categoryid)
5. 0.034 0.137 ↑ 1.0 97 1

Hash Join (cost=6.57..18.40 rows=97 width=181) (actual time=0.060..0.137 rows=97 loops=1)

  • Hash Cond: (insights.insightid = uipriority.insightid)
6. 0.061 0.061 ↓ 1.0 147 1

Seq Scan on insights (cost=0.00..10.31 rows=145 width=176) (actual time=0.007..0.061 rows=147 loops=1)

  • Filter: (expirydate >= now())
  • Rows Removed by Filter: 7
7. 0.018 0.042 ↑ 1.0 103 1

Hash (cost=5.29..5.29 rows=103 width=13) (actual time=0.042..0.042 rows=103 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
8. 0.024 0.024 ↑ 1.0 103 1

Seq Scan on userinsightpriority uipriority (cost=0.00..5.29 rows=103 width=13) (actual time=0.004..0.024 rows=103 loops=1)

  • Filter: (userid = 3)
9. 0.005 0.039 ↑ 1.0 17 1

Hash (cost=2.79..2.79 rows=17 width=144) (actual time=0.039..0.039 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.017 0.034 ↑ 1.0 17 1

Hash Left Join (cost=1.38..2.79 rows=17 width=144) (actual time=0.028..0.034 rows=17 loops=1)

  • Hash Cond: (categories.parentid = pc.categoryid)
11. 0.006 0.006 ↑ 1.0 17 1

Seq Scan on categories (cost=0.00..1.17 rows=17 width=80) (actual time=0.006..0.006 rows=17 loops=1)

12. 0.005 0.011 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=72) (actual time=0.011..0.011 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
13. 0.006 0.006 ↑ 1.0 17 1

Seq Scan on categories pc (cost=0.00..1.17 rows=17 width=72) (actual time=0.002..0.006 rows=17 loops=1)

14. 0.003 0.005 ↑ 260.0 2 1

Hash (cost=15.20..15.20 rows=520 width=40) (actual time=0.005..0.005 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.002 0.002 ↑ 260.0 2 1

Seq Scan on sourcetypes st (cost=0.00..15.20 rows=520 width=40) (actual time=0.002..0.002 rows=2 loops=1)

Planning time : 1.417 ms
Execution time : 0.427 ms