explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g28A

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 256.713 ↓ 6.0 6 1

Nested Loop Left Join (cost=3.69..12,696.47 rows=1 width=707) (actual time=2.401..256.713 rows=6 loops=1)

2. 0.002 256.704 ↓ 6.0 6 1

Nested Loop Left Join (cost=3.26..12,691.93 rows=1 width=589) (actual time=2.395..256.704 rows=6 loops=1)

3. 0.005 256.654 ↓ 6.0 6 1

Nested Loop Left Join (cost=2.82..12,687.39 rows=1 width=492) (actual time=2.358..256.654 rows=6 loops=1)

4. 0.003 256.529 ↓ 6.0 6 1

Nested Loop Left Join (cost=2.39..12,682.84 rows=1 width=395) (actual time=2.316..256.529 rows=6 loops=1)

5. 0.007 256.520 ↓ 6.0 6 1

Nested Loop Left Join (cost=1.97..12,678.32 rows=1 width=350) (actual time=2.311..256.520 rows=6 loops=1)

6. 0.005 256.507 ↓ 6.0 6 1

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

7. 0.005 256.466 ↓ 6.0 6 1

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

8. 256.407 256.407 ↓ 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=2.250..256.407 rows=6 loops=1)

  • Index Cond: ((order_state)::text = 'AVAILABLE'::text)
  • Filter: ((order_group_id IS NULL) AND ((order_type)::text = 'LOOP_DELIVERY'::text) AND (origin_id = '5607828'::bigint))
  • Rows Removed by Filter: 1118
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.036 0.036 ↑ 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.006..0.006 rows=1 loops=6)

  • Index Cond: (id = 1)
  • Heap Fetches: 6
11. 0.006 0.006 ↓ 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.001..0.001 rows=0 loops=6)

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

Index Scan using pk_order_group on order_group orderentit4_ (cost=0.41..4.52 rows=1 width=45) (actual time=0.001..0.001 rows=0 loops=6)

  • Index Cond: (orderentit0_.order_group_id = id)
13. 0.120 0.120 ↑ 1.0 1 6

Index Scan using pk_address on address address5_ (cost=0.43..4.54 rows=1 width=97) (actual time=0.020..0.020 rows=1 loops=6)

  • Index Cond: (orderentit0_.destination_address_id = id)
14. 0.048 0.048 ↑ 1.0 1 6

Index Scan using pk_address on address address6_ (cost=0.43..4.54 rows=1 width=97) (actual time=0.007..0.008 rows=1 loops=6)

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

Index Scan using pk_address on address address7_ (cost=0.43..4.54 rows=1 width=97) (actual time=0.001..0.001 rows=0 loops=6)

  • Index Cond: (orderentit0_.physical_origin_address_id = id)
Planning time : 2.841 ms
Execution time : 256.899 ms