explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rULO

Settings
# exclusive inclusive rows x rows loops node
1. 0.440 216.884 ↓ 1.5 407 1

Sort (cost=185,527.69..185,528.34 rows=263 width=503) (actual time=216.866..216.884 rows=407 loops=1)

  • Sort Key: c.id, mis."createdDate
  • Sort Method: quicksort Memory: 175kB
2. 1.310 216.444 ↓ 1.5 407 1

Nested Loop Left Join (cost=2.29..185,517.11 rows=263 width=503) (actual time=2.156..216.444 rows=407 loops=1)

3. 0.191 150.421 ↓ 1.5 407 1

Nested Loop Left Join (cost=2.00..167,609.23 rows=263 width=241) (actual time=2.116..150.421 rows=407 loops=1)

4. 0.133 150.230 ↓ 1.5 407 1

Nested Loop Left Join (cost=1.71..165,478.30 rows=263 width=233) (actual time=2.114..150.230 rows=407 loops=1)

5. 0.240 132.596 ↓ 1.5 407 1

Nested Loop (cost=1.15..163,261.44 rows=263 width=207) (actual time=1.618..132.596 rows=407 loops=1)

6. 46.456 46.456 ↑ 1.0 50 1

Index Only Scan using "Check_pkey" on "Check" c (cost=0.57..233.50 rows=50 width=8) (actual time=0.620..46.456 rows=50 loops=1)

  • Index Cond: (id = ANY ('{5740006427358748,5740006427184479,5740006427063290,5740006427257345,5740006427186856,5740006427066281,5740006427114873,5740006427093574,5740006426852876,5740006427031624,5740006426344790,5740006427013841,5740006426787705,5740006426426045,5740006426689443,5740006426854424,5740006426735965,5740006426674407,5740006426177974,5740006426219731,5740006426444230,5740006426538225,5740006426400083,5740006426200862,5740006426424371,5740006425901136,5740006426396238,5740006426394030,5740006426124795,5740006426377803,5740006426363826,5740006426357459,5740006426324278,5740006426260779,5740006425974582,5740006426242266,5740006426220499,5740006426183899,5740006426177378,5740006426164931,5740006426044773,5740006426034973,5740006426012467,5740006425909693,5740006425542414,5740006425894164,5740006425827526,5740006425869497,5740006425688186,5740006425614954}'::bigint[]))
  • Heap Fetches: 128
7. 85.900 85.900 ↑ 1,253.2 8 50

Index Scan using menuitemselection__check_id3 on "MenuItemSelection" mis (cost=0.58..3,160.30 rows=10,026 width=207) (actual time=1.334..1.718 rows=8 loops=50)

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

Index Scan using menuitemsel_external_id_selection_fk on "MenuItemSelectionExternalIdentifier" eid (cost=0.56..8.42 rows=1 width=34) (actual time=0.043..0.043 rows=0 loops=407)

  • Index Cond: (selection_id = mis.id)
  • Filter: (("statusEnum")::text = 'ACTIVE'::text)
9. 0.000 0.000 ↓ 0.0 0 407

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

  • Index Cond: (id = mis.decorator_id)
10. 0.000 0.000 ↓ 0.0 0 407

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

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

SubPlan (for Nested Loop Left Join)

12. 0.000 0.000 ↓ 0.0 0 407

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

  • Recheck Cond: (diningoption_id = dineopt.id)
13. 0.000 0.000 ↓ 0.0 0 407

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=407)

  • Index Cond: (diningoption_id = dineopt.id)
14. 2.442 2.442 ↓ 0.0 0 407

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

  • Index Cond: (id = mis.voiddate_day_id)
15. 49.654 49.654 ↑ 1.0 1 407

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

  • Index Cond: (id = mis.item_id)
16. 8.140 8.140 ↓ 0.0 0 407

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

  • Index Cond: (id = mis.group_id)
17. 0.000 0.000 ↓ 0.0 0 407

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=407)

  • Index Cond: (id = mis.voidreason_id)
18. 4.070 4.070 ↑ 1.0 1 407

Index Scan using "MenuOptionGroup_pkey" on "MenuOptionGroup" mog (cost=0.42..8.45 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=407)

  • Index Cond: (id = mis.optiongroup_id)
19. 0.407 0.407 ↓ 0.0 0 407

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

  • Index Cond: (id = mis.salescategory_id)
Planning time : 0.951 ms
Execution time : 217.008 ms