explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5LzA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=9,816.34..9,816.47 rows=27 width=24) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=9,816.34..9,816.40 rows=27 width=24) (actual rows= loops=)

  • Sort Key: u0.order_id, u0.approve_date DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7,141.86..9,815.69 rows=27 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7,141.58..9,802.46 rows=43 width=28) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7,141.15..9,758.17 rows=43 width=28) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,140.73..9,498.31 rows=43 width=24) (actual rows= loops=)

  • Hash Cond: (u0.writer_id = u6.id)
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feedback_customer_feedback u0 (cost=372.43..2,697.18 rows=8,640 width=28) (actual rows= loops=)

  • Filter: ((NOT is_deleted) AND is_approved AND is_shareable AND ((comment)::text <> ''::text))
8. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (is_shareable = true)
9. 0.000 0.000 ↓ 0.0

Hash (cost=6,762.64..6,762.64 rows=453 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

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

  • Filter: ((status)::text ~~ 'active:%'::text)
11. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = u0.order_id)
12. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = u1.customer_id)
13. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = u2.site_id)
  • Filter: (region_id = 2)