explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sh84h

Settings
# exclusive inclusive rows x rows loops node
1. 18.737 1,606.592 ↑ 1.0 114,617 1

Unique (cost=123,377.88..123,971.92 rows=115,550 width=92) (actual time=1,562.078..1,606.592 rows=114,617 loops=1)

2. 92.565 1,587.855 ↑ 1.0 116,628 1

Sort (cost=123,377.88..123,674.90 rows=118,807 width=92) (actual time=1,562.076..1,587.855 rows=116,628 loops=1)

  • Sort Key: feedback_customer_feedback.order_id
  • Sort Method: quicksort Memory: 12,033kB
3. 89.690 1,495.290 ↑ 1.0 116,628 1

Hash Left Join (cost=6,924.03..113,363.48 rows=118,807 width=92) (actual time=134.309..1,495.290 rows=116,628 loops=1)

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

Hash Join (cost=4,759.16..109,565.10 rows=118,807 width=24) (actual time=99.982..1,371.417 rows=116,628 loops=1)

  • Hash Cond: (essays_order.id = feedback_customer_feedback.order_id)
5. 259.127 259.127 ↓ 1.0 1,451,311 1

Seq Scan on essays_order (cost=0.00..78,460.59 rows=1,437,559 width=12) (actual time=0.016..259.127 rows=1,451,311 loops=1)

6. 43.942 99.625 ↑ 1.0 116,628 1

Hash (cost=3,274.07..3,274.07 rows=118,807 width=20) (actual time=99.625..99.625 rows=116,628 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 7,365kB
7. 55.683 55.683 ↑ 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.024..55.683 rows=116,628 loops=1)

8. 13.663 34.183 ↓ 1.0 51,121 1

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

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,344kB
9. 8.132 20.520 ↓ 1.0 51,121 1

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

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

  • Heap Fetches: 340
11. 0.822 1.088 ↓ 1.9 1,450 1

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

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

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

Planning time : 0.883 ms
Execution time : 1,618.372 ms