explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WtzJ

Settings
# exclusive inclusive rows x rows loops node
1. 19.524 237.844 ↑ 1.0 114,617 1

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

2. 69.798 218.320 ↑ 1.0 116,628 1

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

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

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

  • Hash Cond: (feedback_customer_feedback.writer_id = writers_writer.id)
4. 35.100 35.100 ↑ 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..35.100 rows=116,628 loops=1)

5. 25.161 50.820 ↓ 1.0 51,121 1

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

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

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

  • Merge Cond: (writers_writer.id = writers_widget_stats_view.writer_id)
7. 8.321 8.321 ↓ 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..8.321 rows=51,121 loops=1)

  • Heap Fetches: 340
8. 0.851 1.132 ↓ 1.9 1,450 1

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

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

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

Planning time : 0.530 ms
Execution time : 249.526 ms