explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcRD

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 263.979 ↓ 0.0 0 1

Nested Loop (cost=3.69..12,696.47 rows=1 width=707) (actual time=263.979..263.979 rows=0 loops=1)

2. 0.000 263.978 ↓ 0.0 0 1

Nested Loop (cost=3.26..12,691.93 rows=1 width=589) (actual time=263.978..263.978 rows=0 loops=1)

3. 0.000 263.978 ↓ 0.0 0 1

Nested Loop (cost=2.82..12,687.39 rows=1 width=492) (actual time=263.978..263.978 rows=0 loops=1)

4. 0.001 263.978 ↓ 0.0 0 1

Nested Loop (cost=2.39..12,682.84 rows=1 width=395) (actual time=263.978..263.978 rows=0 loops=1)

5. 0.000 263.977 ↓ 0.0 0 1

Nested Loop (cost=1.97..12,678.32 rows=1 width=350) (actual time=263.977..263.977 rows=0 loops=1)

6. 0.006 263.965 ↓ 6.0 6 1

Nested Loop (cost=1.41..12,673.65 rows=1 width=175) (actual time=3.268..263.965 rows=6 loops=1)

7. 0.009 263.935 ↓ 6.0 6 1

Nested Loop (cost=1.13..12,669.17 rows=1 width=183) (actual time=3.252..263.935 rows=6 loops=1)

8. 263.872 263.872 ↓ 6.0 6 1

Index Scan using idx_order_delivery_order_state on order_delivery orderentit0_ (cost=0.56..12,664.49 rows=1 width=175) (actual time=3.223..263.872 rows=6 loops=1)

  • Index Cond: ((order_state)::text = 'AVAILABLE'::text)
  • Filter: ((origin_id = '5607828'::bigint) AND ((order_type)::text = 'LOOP_DELIVERY'::text))
  • Rows Removed by Filter: 1120
9. 0.054 0.054 ↑ 1.0 1 6

Index Only Scan using order_subset_pkey on order_subset subsets1_ (cost=0.57..4.68 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=6)

  • Index Cond: ((order_id = orderentit0_.id) AND (subset_id = 1))
  • Heap Fetches: 6
10. 0.024 0.024 ↑ 1.0 1 6

Index Only Scan using pk_subset on subset subset2_ (cost=0.28..4.38 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (id = 1)
  • Heap Fetches: 6
11. 0.012 0.012 ↓ 0.0 0 6

Index Scan using pk_order_delivery on order_delivery orderentit3_ (cost=0.56..4.67 rows=1 width=175) (actual time=0.002..0.002 rows=0 loops=6)

  • Index Cond: (id = orderentit0_.parent_id)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_order_group on order_group orderentit4_ (cost=0.41..4.52 rows=1 width=45) (never executed)

  • Index Cond: (id = orderentit0_.order_group_id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_address on address address5_ (cost=0.43..4.54 rows=1 width=97) (never executed)

  • Index Cond: (id = orderentit0_.destination_address_id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_address on address address6_ (cost=0.43..4.54 rows=1 width=97) (never executed)

  • Index Cond: (id = orderentit0_.origin_address_id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_address on address address7_ (cost=0.43..4.54 rows=1 width=97) (never executed)

  • Index Cond: (id = orderentit0_.physical_origin_address_id)
Planning time : 2.506 ms
Execution time : 264.117 ms