explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3tC1

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3,288.096 ↑ 1.0 1 1

Limit (cost=825.49..825.56 rows=1 width=148) (actual time=3,288.094..3,288.096 rows=1 loops=1)

2. 0.000 3,288.093 ↑ 1.0 1 1

Unique (cost=825.49..825.56 rows=1 width=148) (actual time=3,288.092..3,288.093 rows=1 loops=1)

3. 0.119 3,288.093 ↑ 1.0 1 1

Sort (cost=825.49..825.50 rows=1 width=148) (actual time=3,288.091..3,288.093 rows=1 loops=1)

  • Sort Key: order0_.id, order0_.created_date, order0_.last_modified_date, order0_.currency_id, order0_.customer_first_name, order0_.customer_free_from_fraud_control, order0_.customer_guest, order0_.customer_last_name, or
  • Sort Method: quicksort Memory: 25kB
4. 0.012 3,287.974 ↑ 1.0 1 1

Nested Loop (cost=171.35..825.48 rows=1 width=148) (actual time=3,273.357..3,287.974 rows=1 loops=1)

5. 4.575 3,287.893 ↑ 1.0 1 1

Hash Join (cost=170.78..820.81 rows=1 width=156) (actual time=3,273.276..3,287.893 rows=1 loops=1)

  • Hash Cond: (orderlines1_.order_id = order0_.id)
6. 3,279.123 3,279.123 ↓ 17.1 3,668 1

Index Scan using idx_order_lines_product_code on order_lines orderlines1_ (cost=0.57..649.78 rows=215 width=16) (actual time=141.668..3,279.123 rows=3,668 loops=1)

  • Index Cond: (product_code = 10265155)
7. 0.016 4.195 ↑ 9.2 6 1

Hash (cost=169.53..169.53 rows=55 width=148) (actual time=4.195..4.195 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
8. 4.179 4.179 ↑ 9.2 6 1

Index Scan using idx_orders_customer_id_f on orders order0_ (cost=0.56..169.53 rows=55 width=148) (actual time=0.801..4.179 rows=6 loops=1)

  • Index Cond: (customer_id = 17194911)
9. 0.069 0.069 ↑ 2.0 1 1

Index Only Scan using order_line_items_order_line_id_index on order_line_items orderlinei2_ (cost=0.57..4.65 rows=2 width=8) (actual time=0.067..0.069 rows=1 loops=1)

  • Index Cond: (order_line_id = orderlines1_.id)
  • Heap Fetches: 1