explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6YeP

Settings
# exclusive inclusive rows x rows loops node
1. 8.587 437.561 ↓ 557.1 15,043 1

WindowAgg (cost=9,816.24..9,816.78 rows=27 width=24) (actual time=426.498..437.561 rows=15,043 loops=1)

2. 8.530 428.974 ↓ 557.1 15,043 1

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

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

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

4. 4.332 363.116 ↓ 385.4 16,574 1

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

5. 15.312 226.192 ↓ 385.4 16,574 1

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

6. 14.748 111.436 ↓ 385.4 16,574 1

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

  • Hash Cond: (u0.writer_id = u6.id)
7. 22.792 24.339 ↓ 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.750..24.339 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.547 1.547 ↑ 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.547..1.547 rows=19,036 loops=1)

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

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

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 67kB
10. 71.872 71.872 ↓ 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..71.872 rows=1,450 loops=1)

  • Filter: ((status)::text ~~ 'active:%'::text)
  • Rows Removed by Filter: 49,668
11. 99.444 99.444 ↑ 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.006..0.006 rows=1 loops=16,574)

  • Index Cond: (id = u0.order_id)
12. 132.592 132.592 ↑ 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.008..0.008 rows=1 loops=16,574)

  • Index Cond: (id = u1.customer_id)
13. 49.722 49.722 ↑ 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.002..0.003 rows=1 loops=16,574)

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