explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ufbB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.053 1.060 ↑ 3.5 78 1

Sort (cost=270,683.72..270,684.39 rows=270 width=523) (actual time=1.056..1.060 rows=78 loops=1)

  • Sort Key: c.id, mis.""createdDate"
  • Sort Method: quicksort Memory: 49kB
2. 0.216 1.007 ↑ 3.5 78 1

Nested Loop Left Join (cost=2.29..270,672.81 rows=270 width=523) (actual time=0.068..1.007 rows=78 loops=1)

3. 0.034 0.323 ↑ 3.5 78 1

Nested Loop Left Join (cost=2.00..252,272.59 rows=270 width=261) (actual time=0.036..0.323 rows=78 loops=1)

4. 0.036 0.289 ↑ 3.5 78 1

Nested Loop Left Join (cost=1.71..250,058.85 rows=270 width=253) (actual time=0.034..0.289 rows=78 loops=1)

  • Join Filter: (eid.selection_id = mis.id)
5. 0.061 0.253 ↑ 3.5 78 1

Nested Loop (cost=1.15..250,048.46 rows=270 width=205) (actual time=0.022..0.253 rows=78 loops=1)

6. 0.092 0.092 ↑ 1.0 50 1

Index Only Scan using "Check_pkey" on "Check" c (cost=0.57..236.35 rows=50 width=8) (actual time=0.013..0.092 rows=50 loops=1)

  • Index Cond: (id = ANY ('{300000008753285117,300000008753285107,300000008753284897,300000008753284875,300000008753284868,300000008753284861,300000008753284850,300000008753278994,300000008753278987,300000008753278982,300000008753278978,300000008753278958,300000008753267440,300000008753267434,300000008753267422,300000008753266998,300000008753266997,300000008753266996,300000008753266995,300000008753266994,300000008753266993,300000008753266992,300000008753266991,300000008753266990,300000008753266989,300000008753266988,300000008753266987,300000008753266986,300000008753266985,300000008753266984,300000008753266983,300000008753266982,300000008753266981,300000008753266980,300000008753266979,300000008753266978,300000008753266977,300000008753266976,300000008753266975,300000008753266974,300000008753266973,300000008753266972,300000008753266971,300000008753266970,300000008753266969,300000008753266968,300000008753266967,300000008753266966,300000008753266965,300000008753266964}'::bigint[]))
  • Heap Fetches: 50
7. 0.100 0.100 ↑ 7,617.5 2 50

Index Scan using menuitemselection__check_id3 on "MenuItemSelection" mis (cost=0.58..4,843.89 rows=15,235 width=205) (actual time=0.002..0.002 rows=2 loops=50)

  • Index Cond: (check_id = c.id)
  • Filter: (deleted IS FALSE)
8. 0.000 0.000 ↓ 0.0 0 78

Materialize (cost=0.56..6.34 rows=1 width=56) (actual time=0.000..0.000 rows=0 loops=78)

9. 0.010 0.010 ↓ 0.0 0 1

Index Scan using "MenuItemSelectionExternalId_authName_id_key_entityId" on "MenuItemSelectionExternalIdentifier" eid (cost=0.56..6.33 rows=1 width=56) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (("authorityName")::text = 'TOAST'::text)
  • Filter: (("statusEnum")::text = 'ACTIVE'::text)
10. 0.000 0.000 ↓ 0.0 0 78

Index Scan using "ModifierDecorator_pkey" on "ModifierDecorator" md (cost=0.29..8.20 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=78)

  • Index Cond: (id = mis.decorator_id)
11. 0.000 0.000 ↓ 0.0 0 78

Index Scan using "DiningOption_pkey" on "DiningOption" dineopt (cost=0.29..8.19 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=78)

  • Index Cond: (mis.diningoption_id = id)
12.          

SubPlan (for Nested Loop Left Join)

13. 0.000 0.000 ↓ 0.0 0 78

Bitmap Heap Scan on "DiningOptionExternalIdentifier" (cost=4.16..9.50 rows=2 width=90) (actual time=0.000..0.000 rows=0 loops=78)

  • Recheck Cond: (diningoption_id = dineopt.id)
14. 0.000 0.000 ↓ 0.0 0 78

Bitmap Index Scan on dineopt_external_id_dinopt_fk (cost=0.00..4.16 rows=2 width=0) (actual time=0.000..0.000 rows=0 loops=78)

  • Index Cond: (diningoption_id = dineopt.id)
15. 0.000 0.000 ↓ 0.0 0 78

Index Scan using "Day_pkey" on "Day" day (cost=0.43..8.45 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=78)

  • Index Cond: (id = mis.voiddate_day_id)
16. 0.234 0.234 ↑ 1.0 1 78

Index Scan using "MenuItem_pkey" on "MenuItem" mi (cost=0.43..8.46 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=78)

  • Index Cond: (id = mis.item_id)
17. 0.156 0.156 ↑ 1.0 1 78

Index Scan using "MenuItem_pkey" on "MenuItem" mg (cost=0.43..8.46 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=78)

  • Index Cond: (id = mis.group_id)
18. 0.000 0.000 ↓ 0.0 0 78

Index Scan using "VoidReason_pkey" on "VoidReason" vr (cost=0.29..8.31 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=78)

  • Index Cond: (id = mis.voidreason_id)
19. 0.078 0.078 ↓ 0.0 0 78

Index Scan using "MenuOptionGroup_pkey" on "MenuOptionGroup" mog (cost=0.43..8.45 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=78)

  • Index Cond: (id = mis.optiongroup_id)
20. 0.000 0.000 ↓ 0.0 0 78

Index Scan using "SalesCategory_pkey" on "SalesCategory" sc (cost=0.29..8.31 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=78)

  • Index Cond: (id = mis.salescategory_id)
Planning time : 0.910 ms
Execution time : 1.156 ms