explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZVD

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 0.130 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.87..87.05 rows=1 width=404) (actual time=0.121..0.130 rows=1 loops=1)

2. 0.001 0.078 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.59..75.83 rows=1 width=301) (actual time=0.070..0.078 rows=1 loops=1)

3. 0.001 0.070 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.16..67.37 rows=1 width=285) (actual time=0.063..0.070 rows=1 loops=1)

4. 0.002 0.061 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.73..58.91 rows=1 width=289) (actual time=0.055..0.061 rows=1 loops=1)

5. 0.001 0.058 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.29..50.45 rows=1 width=293) (actual time=0.054..0.058 rows=1 loops=1)

6. 0.003 0.053 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.01..42.14 rows=1 width=285) (actual time=0.049..0.053 rows=1 loops=1)

7. 0.001 0.044 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.72..33.82 rows=1 width=277) (actual time=0.041..0.044 rows=1 loops=1)

8. 0.001 0.036 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.43..25.51 rows=1 width=269) (actual time=0.034..0.036 rows=1 loops=1)

9. 0.005 0.028 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.01..17.05 rows=1 width=261) (actual time=0.026..0.028 rows=1 loops=1)

  • Join Filter: (eid.order_id = o.id)
10. 0.016 0.016 ↑ 1.0 1 1

Index Scan using "Orders_pkey" on "Orders" o (cost=0.57..8.59 rows=1 width=207) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (id = '300000004443297303'::bigint)
11. 0.007 0.007 ↓ 0.0 0 1

Index Scan using order_external_id_order_fk on "OrderExternalIdentifier" eid (cost=0.43..8.45 rows=1 width=62) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (order_id = '300000004443297303'::bigint)
12. 0.007 0.007 ↑ 1.0 1 1

Index Scan using "Tables_pkey" on "Tables" (cost=0.42..8.44 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (o.table_id = id)
13. 0.007 0.007 ↑ 1.0 1 1

Index Scan using "ServiceArea_pkey" on "ServiceArea" (cost=0.29..8.30 rows=1 width=24) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (o.servicearea_id = id)
14. 0.006 0.006 ↑ 1.0 1 1

Index Scan using "RestaurantService_pkey" on "RestaurantService" (cost=0.29..8.30 rows=1 width=24) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (o.service_id = id)
15. 0.004 0.004 ↑ 1.0 1 1

Index Scan using "RevenueCenter_pkey" on "RevenueCenter" (cost=0.29..8.30 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (o.revenuecenter_id = id)
16. 0.001 0.001 ↓ 0.0 0 1

Index Scan using "Day_pkey" on "Day" voidday (cost=0.43..8.45 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (o.voiddate_day_id = id)
17. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "Day_pkey" on "Day" openedday (cost=0.43..8.45 rows=1 width=12) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (o.openeddate_day_id = id)
18. 0.007 0.007 ↑ 1.0 1 1

Index Scan using "RestaurantUser_pkey" on "RestaurantUser" (cost=0.42..8.44 rows=1 width=24) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (o.server_id = id)
19. 0.003 0.003 ↓ 0.0 0 1

Index Scan using restuser_external_id_restuser_fk on "RestaurantUserExternalIdentifier" (cost=0.29..11.17 rows=2 width=23) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (restaurantuser_id = "RestaurantUser".id)
Planning time : 2.954 ms
Execution time : 0.416 ms