explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VtYC

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.272 ↓ 0.0 0 1

Update on deals d0 (cost=0.15..96.66 rows=42 width=518) (actual time=0.272..0.272 rows=0 loops=1)

  • Update on deals_y2015 d0_1
  • Update on deals_y2016 d0_2
  • Update on deals_y2017 d0_3
  • Update on deals_y2018 d0_4
  • Update on deals_y2019 d0_5
  • Update on deals_y2020_m01 d0_6
  • Update on deals_y2020_m02 d0_7
  • Update on deals_y2020_m03 d0_8
  • Update on deals_y2020_m04 d0_9
  • Update on deals_y2020_m05 d0_10
  • Update on deals_y2020_m06 d0_11
  • Update on deals_y2020_m07_d01 d0_12
  • Update on deals_y2020_m07_d02 d0_13
  • Update on deals_y2020_m07_d03 d0_14
  • Update on deals_y2020_m07_d04 d0_15
  • Update on deals_y2020_m07_d05 d0_16
  • Update on deals_y2020_m07_d06 d0_17
  • Update on deals_y2020_m07_d07 d0_18
  • Update on deals_y2020_m07_d08 d0_19
  • Update on deals_y2020_m07_d09 d0_20
  • Update on deals_y2020_m07_d10 d0_21
  • Update on deals_y2020_m07_d11 d0_22
  • Update on deals_y2020_m07_d12 d0_23
  • Update on deals_y2020_m07_d13 d0_24
  • Update on deals_y2020_m07_d14 d0_25
  • Update on deals_y2020_m07_d15 d0_26
  • Update on deals_y2020_m07_d16 d0_27
  • Update on deals_y2020_m07_d17 d0_28
  • Update on deals_y2020_m07_d18 d0_29
  • Update on deals_y2020_m07_d19 d0_30
  • Update on deals_y2020_m07_d20 d0_31
  • Update on deals_y2020_m07_d21 d0_32
  • Update on deals_y2020_m07_d22 d0_33
  • Update on deals_y2020_m07_d23 d0_34
  • Update on deals_y2020_m07_d24 d0_35
  • Update on deals_y2020_m07_d25 d0_36
  • Update on deals_y2020_m07_d26 d0_37
  • Update on deals_y2020_m07_d27 d0_38
  • Update on deals_y2020_m07_d28 d0_39
  • Update on deals_y2020_m07_d29 d0_40
  • Update on deals_y2020_m07_d30 d0_41
  • Update on deals_def d0_42
2. 0.014 0.014 ↓ 0.0 0 1

Index Scan using deals_y2015_id_idx on deals_y2015 d0_1 (cost=0.15..3.93 rows=1 width=868) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[]))
  • Filter: (opened AND ((status)::text = 'open'::text))
3. 0.005 0.005 ↓ 0.0 0 1

Index Scan using deals_y2016_id_idx on deals_y2016 d0_2 (cost=0.12..1.64 rows=1 width=642) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[]))
  • Filter: (opened AND ((status)::text = 'open'::text))
4. 0.022 0.022 ↓ 0.0 0 1

Index Scan using deals_new_y2017_deal_batch_id_expr_numeric_idx on deals_y2017 d0_3 (cost=0.12..2.35 rows=1 width=653) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
  • Rows Removed by Filter: 9
5. 0.040 0.040 ↓ 0.0 0 1

Index Scan using deals_new_y2018_deal_batch_id_expr_numeric_idx on deals_y2018 d0_4 (cost=0.12..1.73 rows=1 width=513) (actual time=0.040..0.040 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
  • Rows Removed by Filter: 20
6. 0.015 0.015 ↓ 0.0 0 1

Index Scan using deals_new_y2019_deal_batch_id_expr_numeric_idx on deals_y2019 d0_5 (cost=0.12..2.95 rows=1 width=542) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
  • Rows Removed by Filter: 5
7. 0.005 0.005 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m01_deal_batch_id_expr_numeric_idx on deals_y2020_m01 d0_6 (cost=0.12..1.73 rows=1 width=503) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
8. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m02_deal_batch_id_expr_numeric_idx on deals_y2020_m02 d0_7 (cost=0.12..1.73 rows=1 width=493) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
9. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m03_deal_batch_id_expr_numeric_idx on deals_y2020_m03 d0_8 (cost=0.12..1.73 rows=1 width=503) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
10. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m04_deal_batch_id_expr_numeric_idx on deals_y2020_m04 d0_9 (cost=0.12..1.73 rows=1 width=503) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
11. 0.008 0.008 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m05_deal_batch_id_expr_numeric_idx on deals_y2020_m05 d0_10 (cost=0.12..2.35 rows=1 width=503) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
  • Rows Removed by Filter: 1
12. 0.007 0.007 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m06_deal_batch_id_expr_numeric_idx on deals_y2020_m06 d0_11 (cost=0.12..1.73 rows=1 width=503) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
  • Rows Removed by Filter: 1
13. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d01_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d01 d0_12 (cost=0.12..2.35 rows=1 width=502) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
14. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d02_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d02 d0_13 (cost=0.12..2.35 rows=1 width=502) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
15. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d03_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d03 d0_14 (cost=0.12..1.73 rows=1 width=512) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
16. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d04_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d04 d0_15 (cost=0.12..1.73 rows=1 width=512) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
17. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d05_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d05 d0_16 (cost=0.12..2.35 rows=1 width=512) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
18. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d06_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d06 d0_17 (cost=0.12..2.35 rows=1 width=502) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
19. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d07_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d07 d0_18 (cost=0.12..1.73 rows=1 width=503) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
20. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d08_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d08 d0_19 (cost=0.12..1.73 rows=1 width=501) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
21. 0.002 0.002 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d09_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d09 d0_20 (cost=0.12..2.35 rows=1 width=501) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
22. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d10_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d10 d0_21 (cost=0.12..1.73 rows=1 width=503) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
23. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d11_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d11 d0_22 (cost=0.12..2.35 rows=1 width=513) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
24. 0.016 0.016 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d12_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d12 d0_23 (cost=0.12..1.73 rows=1 width=503) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
  • Rows Removed by Filter: 1
25. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d13_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d13 d0_24 (cost=0.12..1.73 rows=1 width=503) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
26. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d14_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d14 d0_25 (cost=0.12..1.73 rows=1 width=503) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
27. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d15_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d15 d0_26 (cost=0.12..2.35 rows=1 width=501) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
28. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d16_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d16 d0_27 (cost=0.12..2.35 rows=1 width=504) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
29. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d17_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d17 d0_28 (cost=0.12..1.73 rows=1 width=487) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
30. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d18_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d18 d0_29 (cost=0.12..1.73 rows=1 width=487) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
31. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d19_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d19 d0_30 (cost=0.12..1.73 rows=1 width=487) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
32. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d20_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d20 d0_31 (cost=0.12..1.73 rows=1 width=487) (actual time=0.003..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
33. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d21_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d21 d0_32 (cost=0.12..2.35 rows=1 width=487) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
34. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d22_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d22 d0_33 (cost=0.12..2.35 rows=1 width=490) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
35. 0.004 0.004 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d23_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d23 d0_34 (cost=0.12..1.73 rows=1 width=502) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
36. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d24_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d24 d0_35 (cost=0.12..1.73 rows=1 width=503) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
37. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d25_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d25 d0_36 (cost=0.12..1.73 rows=1 width=513) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
38. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d26_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d26 d0_37 (cost=0.12..1.73 rows=1 width=513) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
39. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d27_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d27 d0_38 (cost=0.12..1.73 rows=1 width=504) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
40. 0.015 0.015 ↓ 0.0 0 1

Index Scan using deals_new_y2020_m07_d28_pkey on deals_y2020_m07_d28 d0_39 (cost=0.43..8.85 rows=1 width=503) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[]))
  • Filter: (opened AND ((status)::text = 'open'::text))
41. 0.009 0.009 ↓ 0.0 0 1

Index Scan using deals_y2020_m07_d29_id_idx on deals_y2020_m07_d29 d0_40 (cost=0.28..6.65 rows=1 width=494) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[]))
  • Filter: (opened AND ((status)::text = 'open'::text))
42. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_y2020_m07_d30_deal_batch_id_expr_numeric_idx on deals_y2020_m07_d30 d0_41 (cost=0.12..2.35 rows=1 width=500) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
43. 0.003 0.003 ↓ 0.0 0 1

Index Scan using deals_def_deal_batch_id_expr_numeric_idx on deals_def d0_42 (cost=0.12..2.35 rows=1 width=502) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
Planning time : 564.920 ms
Execution time : 3.099 ms