explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8cw7

Settings
# exclusive inclusive rows x rows loops node
1. 11.259 151.186 ↓ 385.4 16,574 1

WindowAgg (cost=9,499.47..9,500.33 rows=43 width=24) (actual time=136.408..151.186 rows=16,574 loops=1)

2. 11.550 139.927 ↓ 385.4 16,574 1

Sort (cost=9,499.47..9,499.58 rows=43 width=24) (actual time=136.395..139.927 rows=16,574 loops=1)

  • Sort Key: u0.order_id, u0.approve_date DESC
  • Sort Method: quicksort Memory: 2,063kB
3. 41.083 128.377 ↓ 385.4 16,574 1

Hash Join (cost=7,140.73..9,498.31 rows=43 width=24) (actual time=69.941..128.377 rows=16,574 loops=1)

  • Hash Cond: (u0.writer_id = u6.id)
4. 17.589 19.341 ↓ 2.2 18,969 1

Bitmap Heap Scan on feedback_customer_feedback u0 (cost=372.43..2,697.18 rows=8,640 width=28) (actual time=1.955..19.341 rows=18,969 loops=1)

  • Filter: ((NOT is_deleted) AND is_approved AND is_shareable AND ((comment)::text <> ''::text))
  • Rows Removed by Filter: 67
  • Heap Blocks: exact=1,744
5. 1.752 1.752 ↑ 1.0 19,036 1

Bitmap Index Scan on feedback_is_shareable__idx (cost=0.00..370.27 rows=19,980 width=0) (actual time=1.752..1.752 rows=19,036 loops=1)

  • Index Cond: (is_shareable = true)
6. 0.499 67.953 ↓ 3.2 1,450 1

Hash (cost=6,762.64..6,762.64 rows=453 width=4) (actual time=67.953..67.953 rows=1,450 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 67kB
7. 67.454 67.454 ↓ 3.2 1,450 1

Seq Scan on writers_writer u6 (cost=0.00..6,762.64 rows=453 width=4) (actual time=0.077..67.454 rows=1,450 loops=1)

  • Filter: ((status)::text ~~ 'active:%'::text)
  • Rows Removed by Filter: 49,668
Planning time : 0.549 ms
Execution time : 152.194 ms