explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AbJs

Settings
# exclusive inclusive rows x rows loops node
1. 2.246 920.186 ↓ 556.4 15,023 1

Unique (cost=9,816.24..9,816.37 rows=27 width=24) (actual time=915.330..920.186 rows=15,023 loops=1)

2. 20.977 917.940 ↓ 557.1 15,043 1

Sort (cost=9,816.24..9,816.31 rows=27 width=24) (actual time=915.329..917.940 rows=15,043 loops=1)

  • Sort Key: u0.order_id, u0.approve_date DESC
  • Sort Method: quicksort Memory: 1,560kB
3. 31.327 896.963 ↓ 557.1 15,043 1

Nested Loop (cost=7,141.85..9,815.60 rows=27 width=24) (actual time=106.362..896.963 rows=15,043 loops=1)

4. 28.493 782.766 ↓ 385.4 16,574 1

Nested Loop (cost=7,141.58..9,802.35 rows=43 width=28) (actual time=106.344..782.766 rows=16,574 loops=1)

5. 17.935 489.089 ↓ 385.4 16,574 1

Nested Loop (cost=7,141.15..9,758.17 rows=43 width=28) (actual time=106.321..489.089 rows=16,574 loops=1)

6. 38.177 189.396 ↓ 385.4 16,574 1

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

  • Hash Cond: (u0.writer_id = u6.id)
7. 45.210 47.024 ↓ 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=2.065..47.024 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
8. 1.814 1.814 ↑ 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.814..1.814 rows=19,036 loops=1)

  • Index Cond: (is_shareable = true)
9. 0.411 104.195 ↓ 3.2 1,450 1

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

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

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

  • Filter: ((status)::text ~~ 'active:%'::text)
  • Rows Removed by Filter: 49,668
11. 281.758 281.758 ↑ 1.0 1 16,574

Index Scan using essays_order_pkey on essays_order u1 (cost=0.43..6.03 rows=1 width=12) (actual time=0.017..0.017 rows=1 loops=16,574)

  • Index Cond: (id = u0.order_id)
12. 265.184 265.184 ↑ 1.0 1 16,574

Index Scan using customers_customer_pkey on customers_customer u2 (cost=0.42..1.02 rows=1 width=12) (actual time=0.016..0.016 rows=1 loops=16,574)

  • Index Cond: (id = u1.customer_id)
13. 82.870 82.870 ↑ 1.0 1 16,574

Index Scan using core_site_pkey on core_site u3 (cost=0.28..0.30 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=16,574)

  • Index Cond: (id = u2.site_id)
  • Filter: (region_id = 2)
  • Rows Removed by Filter: 0
Planning time : 1.539 ms
Execution time : 921.587 ms