explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 71ud

Settings
# exclusive inclusive rows x rows loops node
1. 41.472 323.345 ↑ 1.0 114,617 1

Unique (cost=17,086.85..17,680.89 rows=115,550 width=88) (actual time=248.446..323.345 rows=114,617 loops=1)

2. 109.831 281.873 ↑ 1.0 116,628 1

Sort (cost=17,086.85..17,383.87 rows=118,807 width=88) (actual time=248.444..281.873 rows=116,628 loops=1)

  • Sort Key: feedback_customer_feedback.order_id
  • Sort Method: quicksort Memory: 11,375kB
3. 85.908 172.042 ↑ 1.0 116,628 1

Hash Left Join (cost=2,164.87..7,072.45 rows=118,807 width=88) (actual time=46.348..172.042 rows=116,628 loops=1)

  • Hash Cond: (feedback_customer_feedback.writer_id = writers_writer.id)
4. 39.983 39.983 ↑ 1.0 116,628 1

Seq Scan on feedback_customer_feedback (cost=0.00..3,274.07 rows=118,807 width=20) (actual time=0.022..39.983 rows=116,628 loops=1)

5. 22.153 46.151 ↓ 1.0 51,121 1

Hash (cost=1,527.53..1,527.53 rows=50,987 width=76) (actual time=46.151..46.151 rows=51,121 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,344kB
6. 16.107 23.998 ↓ 1.0 51,121 1

Merge Left Join (cost=55.56..1,527.53 rows=50,987 width=76) (actual time=0.710..23.998 rows=51,121 loops=1)

  • Merge Cond: (writers_writer.id = writers_widget_stats_view.writer_id)
7. 6.788 6.788 ↓ 1.0 51,121 1

Index Only Scan using writers_writer_pkey on writers_writer (cost=0.29..1,333.09 rows=50,987 width=4) (actual time=0.024..6.788 rows=51,121 loops=1)

  • Heap Fetches: 340
8. 0.820 1.103 ↓ 1.9 1,450 1

Sort (cost=55.27..57.22 rows=780 width=76) (actual time=0.679..1.103 rows=1,450 loops=1)

  • Sort Key: writers_widget_stats_view.writer_id
  • Sort Method: quicksort Memory: 162kB
9. 0.283 0.283 ↓ 1.9 1,450 1

Seq Scan on writers_widget_stats_view (cost=0.00..17.80 rows=780 width=76) (actual time=0.020..0.283 rows=1,450 loops=1)

Planning time : 0.540 ms
Execution time : 334.255 ms