explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f1Zq

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2,177.450 ↑ 1.0 1 1

Limit (cost=831.50..831.56 rows=1 width=148) (actual time=2,177.448..2,177.450 rows=1 loops=1)

2. 0.001 2,177.448 ↑ 1.0 1 1

Unique (cost=831.50..831.56 rows=1 width=148) (actual time=2,177.447..2,177.448 rows=1 loops=1)

3. 0.082 2,177.447 ↑ 1.0 1 1

Sort (cost=831.50..831.50 rows=1 width=148) (actual time=2,177.446..2,177.447 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.020 2,177.365 ↑ 1.0 1 1

Nested Loop (cost=171.35..831.49 rows=1 width=148) (actual time=18.864..2,177.365 rows=1 loops=1)

5. 4.329 2,177.261 ↑ 1.0 1 1

Hash Join (cost=170.78..826.82 rows=1 width=156) (actual time=18.763..2,177.261 rows=1 loops=1)

  • Hash Cond: (orderlines1_.order_id = order0_.id)
6. 2,172.819 2,172.819 ↓ 17.0 3,667 1

Index Scan using idx_order_lines_product_code_fill on order_lines orderlines1_ (cost=0.57..655.79 rows=216 width=16) (actual time=2.727..2,172.819 rows=3,667 loops=1)

  • Index Cond: (product_code = 10265155)
7. 0.013 0.113 ↑ 9.2 6 1

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

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

Index Scan using idx_orders_customer_id_fill on orders order0_ (cost=0.56..169.53 rows=55 width=148) (actual time=0.057..0.100 rows=6 loops=1)

  • Index Cond: (customer_id = 17194911)
9. 0.084 0.084 ↑ 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.083..0.084 rows=1 loops=1)

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