explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5tu7

Settings
# exclusive inclusive rows x rows loops node
1. 0.077 0.291 ↑ 1.0 94 1

Sort (cost=48.97..49.21 rows=97 width=277) (actual time=0.284..0.291 rows=94 loops=1)

  • Sort Key: uipriority.prioritisedscore DESC
  • Sort Method: quicksort Memory: 53kB
2. 0.030 0.214 ↑ 1.0 94 1

Hash Join (cost=31.27..45.77 rows=97 width=277) (actual time=0.093..0.214 rows=94 loops=1)

  • Hash Cond: (insights.sourcetypeid = st.sourcetypeid)
3. 0.022 0.180 ↑ 1.0 94 1

Hash Join (cost=9.57..22.73 rows=97 width=245) (actual time=0.084..0.180 rows=94 loops=1)

  • Hash Cond: (insights.categoryid = c.categoryid)
4. 0.029 0.129 ↑ 1.0 97 1

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

  • Hash Cond: (insights.insightid = uipriority.insightid)
5. 0.059 0.059 ↓ 1.0 147 1

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
7. 0.023 0.023 ↑ 1.0 103 1

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

  • Filter: (userid = 3)
8. 0.001 0.029 ↑ 4.2 4 1

Hash (cost=2.79..2.79 rows=17 width=80) (actual time=0.029..0.029 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.010 0.028 ↑ 4.2 4 1

Hash Join (cost=1.38..2.79 rows=17 width=80) (actual time=0.024..0.028 rows=4 loops=1)

  • Hash Cond: (c.parentid = c1.categoryid)
10. 0.006 0.006 ↑ 1.0 17 1

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

11. 0.005 0.012 ↑ 1.0 17 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.007 0.007 ↑ 1.0 17 1

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

13. 0.002 0.004 ↑ 260.0 2 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 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 : 0.542 ms
Execution time : 0.342 ms