explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bZR82

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.521 ↓ 0.0 0 1

Update on deals d0 (cost=0.43..101.08 rows=42 width=518) (actual time=0.521..0.521 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.057 0.057 ↓ 0.0 0 1

Index Scan using deals_new_y2015_pkey on deals_y2015 d0_1 (cost=0.43..8.73 rows=1 width=877) (actual time=0.057..0.057 rows=0 loops=1)

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

Index Scan using deals_new_y2016_deal_batch_id_expr_numeric_idx on deals_y2016 d0_2 (cost=0.12..2.35 rows=1 width=642) (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[])))
4. 0.030 0.030 ↓ 0.0 0 1

Index Scan using deals_new_y2017_deal_batch_id_expr_numeric_idx on deals_y2017 d0_3 (cost=0.14..1.74 rows=1 width=653) (actual time=0.030..0.030 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.043 0.043 ↓ 0.0 0 1

Index Scan using deals_new_y2018_deal_batch_id_expr_numeric_idx on deals_y2018 d0_4 (cost=0.14..2.36 rows=1 width=513) (actual time=0.043..0.043 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.024 0.024 ↓ 0.0 0 1

Index Scan using deals_new_y2019_deal_batch_id_expr_numeric_idx on deals_y2019 d0_5 (cost=0.13..1.84 rows=1 width=542) (actual time=0.024..0.024 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.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
8. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
9. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
10. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
11. 0.013 0.013 ↓ 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.013..0.013 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.012 0.012 ↓ 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.012..0.012 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.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
14. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
15. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
16. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
17. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
18. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
19. 0.008 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
20. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
21. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
22. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
23. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
24. 0.010 0.010 ↓ 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.010..0.010 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.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
26. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
27. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
28. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
29. 0.008 0.008 ↓ 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.007..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
30. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
31. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
32. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
33. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
34. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
35. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
36. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
37. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
38. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
39. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
40. 0.018 0.018 ↓ 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.018..0.018 rows=0 loops=1)

  • Index Cond: (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[]))
  • Filter: (opened AND ((status)::text = 'open'::text))
41. 0.018 0.018 ↓ 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=497) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[]))
  • Filter: (opened AND ((status)::text = 'open'::text))
42. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Filter: (opened AND ((status)::text = 'open'::text) AND (id = ANY ('{556001664,556001810,556001990,556002010}'::integer[])))
43. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

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